title: Escaping separator within double quotes, in awk
body: <p>I am using awk to parse my data with "," as separator as the input is a csv file. However, there are "," within the data which is escaped by double quotes ("...").</p>
  
  <p>Example</p>
  
  <pre><code>filed1,filed2,field3,"field4,FOO,BAR",field5
  </code></pre>
  
  <p>How can i ignore the comma "," within the the double quote so that I can parse the output correctly using awk? I know we can do this in excel, but how do we do it in awk?</p>