Can awk deal with CSV file that contains comma inside a quoted field?

Question

I am using awk to perform counting the sum of one column in the csv file. The data format is something like:

id, name, value 1, foo, 17 2, bar, 76 3, "I am the, question", 99 

I was using this awk script to count the sum:

awk -F, '{sum+=$3} END {print sum}' 

Some of the value in name field contains comma and this break my awk script. My question is: can awk solve this problem? If yes, and how can I do that?

Thank you.

Answer 1

One way using GNU awk and FPAT

awk 'BEGIN { FPAT = "([^, ]+)|(\"[^\"]+\")" } { sum+=$3 } END { print sum }' file.txt 

Result:

192