title: CSV to DataTable
body: <p>I wonder what is my best option to parse CSV into a DataTable. </p>
  
  <p>My CSV is in this format </p>
  
  <p>Separator: comma <br>
  Delimiter: double quotes (e.g."string")<br>
  Escape: 2x double quotes<br></p>
  
  <p><strong>Here is the example:</strong></p>
  
  <pre>
  Col1,Col2,Col3,Col4
  1234,active,"This is a long text with new lines, commas and all", XGF232
  1235,active,"This is also a ""long"" text with new lines and all", XHD233</pre>
  
  <ol>
  <li>The problem is that numbers or short; one word strings are not enclosed within quotes. </li>
  <li>The other problem is that long strings which are enclosed within quotes that also have a "string" nested are escaped with ""string"". </li>
  </ol>
  
  <p>PS: Excel understands this format without an issue.</p>
  
  <p>EDIT:</p>
  
  <p>The comments pointed me at a different options. I searched the libraries available and I found LumenWorks.Framework.IO.Csv which seems to do the job just perfect. </p>
  
  <pre><code>Using csv As CsvReader = New CsvReader(New StreamReader(filename), True)
                  Dim fieldCount = csv.FieldCount
                  Dim headers() As String = csv.GetFieldHeaders()
                  dt.Load(csv)
  End Using
  </code></pre>