title: Parsing csv data: TextFieldParser vs Split
body: <p>VB2005. So just diong some testing and ran into this oddity while parsing my CSV data with the TextFieldParser <a href="http://connect.microsoft.com/VisualStudio/feedback/details/679596/textfieldparser-does-not-respect-consecutive-line-breaks-in-the-middle-of-a-field" rel="nofollow">http://connect.microsoft.com/VisualStudio/feedback/details/679596/textfieldparser-does-not-respect-consecutive-line-breaks-in-the-middle-of-a-field</a> where it doesn't recognize repeated line breaks in a field. Note that this is not the same as skipping blank fields. Anyway, I am testing an alternative way to get the data. I am trying the plain old Split function but that function cant handle embedded commas in a field like the TextFieldParser can. Are there any workarounds to this issue?</p>
  
  <p>As an example the source data field reads:</p>
  
  <pre><code>"this is line 1
  this is line 2
  
  this is line 3
  
  
  this is line 4
  this is line 5"
  </code></pre>
  
  <p>And after I parse it with the TextFieldParser I get an output:</p>
  
  <pre><code>this is line 1
  this is line 2
  this is line 3
  this is line 4
  this is line 5
  </code></pre>
  
  <p>Seemingly any blank line gets ignored. If I had a memo with several paragraphs in the field this would jumble it all together with no spacing between. Does any else see this behavior?</p>
  
  <p>Update: Used the CSV reader from Code project <a href="http://www.codeproject.com/Articles/9258/A-Fast-CSV-Reader" rel="nofollow">http://www.codeproject.com/Articles/9258/A-Fast-CSV-Reader</a> and it works great. Doesn't trim the inner line breaks on empty lines.</p>