title: How to make awk ignore the field delimiter inside double quotes?
body: <p>I need to delete 2 columns in a comma seperated values file.
  Consider the following line in the csv file:</p>
  
  <pre><code>"abc@xyz.com,www.example.com",field2,field3,field4
  "def@xyz.com",field2,field3,field4
  </code></pre>
  
  <p>Now, the result I want at the end:</p>
  
  <pre><code>"abc@xyz.com,www.example.com",field4
  "def@xyz.com",field4
  </code></pre>
  
  <p>I used the following command:</p>
  
  <pre><code>awk 'BEGIN{FS=OFS=","}{print $1,$4}'
  </code></pre>
  
  <p>But the embedded comma which is inside quotes is creating a problem, Following is the result I am getting:</p>
  
  <pre><code>"abc@xyz.com,field3
  "def@xyz.com",field4
  </code></pre>
  
  <p>Now my question is how do I make awk ignore the "," which are inside the double quotes? </p>