title: How to extract multiple columns from a CSV file using Perl
body: <p>I'm pretty new with Perl and was hoping if anyone could help me with this issue. I need to extract two columns from a CSV file embedded commas. This is how the format looks like:</p>
  
  <pre><code>"ID","URL","DATE","XXID","DATE-LONGFORMAT"
  </code></pre>
  
  <p>I need to extract the <code>DATE</code> column, the <code>XXID</code> column, and the column immediately after <code>XXID</code>.  Note, each line doesn't necessarily follow the same number of columns.</p>
  
  <p>The <code>XXID</code> column contains a 2 letter prefix and doesn't always starts with the same letter. It can pretty much be any letter of the aplhabet. The length is always the same. </p>
  
  <p>Finally, once these three columns are extracted, I need to sort on the <code>XXID</code> column and get a count on duplicates.</p>