awk print - fields separated with comma's need to ignore inbetween double quotes

Shell Programming and Scripting
1

I am trying to re-format a .csv file using awk. I have 6 fields in the .csv file. Some of the fields are enclosed in double quotes and contain comma's inside the quotes. awk is breaking this into multiple fields.

Sample lines from the .csv file:

Device Name,Personnel,Date,Solution Accessed,Personnel ID,Reason
QA06-W732,Steve,2013-03-09 05:20:20.0,"Scribe, Five",812388,Validation

Current Awk command I am using:

awk -F, '{print $1}'

I plan to call each field individually, as I have to put the .csv file into a format similar to html. Is there a way to format the awk command so it reads everything inside the double quotes as one field?

Thanks.

2

Did you search these forums for a solution? There's many, I promise!