title: Can awk deal with CSV file that contains comma inside a quoted field?
body: <p>I am using awk to perform counting the sum of one column in the csv file. The data format is something like:</p>
  
  <pre><code>id, name, value
  1, foo, 17
  2, bar, 76
  3, "I am the, question", 99
  </code></pre>
  
  <p>I was using this awk script to count the sum:</p>
  
  <pre><code>awk -F, '{sum+=$3} END {print sum}'
  </code></pre>
  
  <p>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?</p>
  
  <p>Thank you.</p>