title: Parsing a CSV with comma in data
body: <blockquote>
    <p><strong>Possible Duplicate:</strong><br>
    <a href="https://stackoverflow.com/questions/769621/dealing-with-commas-in-a-csv-file">Dealing with commas in a CSV file</a>  </p>
  </blockquote>
  
  
  
  <p>I wrote myself a CSV parser it works fine until I hit this record:
  <code>B002VECGTG,B002VECGTG,HAS_17131_spaceshooter,"4,426",0.04%,"4,832",0.03%,0%,1,0.02%,$20.47 ,1</code>
  The escaped , in "4,426" and in "4,426" brake my parser.</p>
  
  <p>This is what I am using to parse the line of text:</p>
  
  <pre><code>            char[] comma = { ',' };
              string[] words = line.Split(comma);
  </code></pre>
  
  <p>How do I prevent my program from breaking?</p>