title: Parsing CSV data
body: <p>I am trying to parse a CSV file with data with no luck, i have tried a bunch of tools online and none has been able to parse the CSV file correctly. I am baffled by the fact that i am in here asking for help as one would think parsing CSV data would be something super easy.</p>
  
  <p>The format of the CSV data is like this:</p>
  
  <pre><code>",95,54070,3635,""Test Reservation"",0,102,0.00,0.00,2014-12-31,""Name of customer"",""$12.34 + $10, special price"",""extra information"",,CustomerName,,,,,1234567890,youremail@domain.com,CustomerName,2014-12-31,23:59:59,16,0,60,2,120,0,NULL,NULL,NULL,"
  </code></pre>
  
  <p>Current code:</p>
  
  <pre><code>private void btnOpenFileDialog_Click(object sender, EventArgs e)
      {
          DialogResult result = openFileDialog1.ShowDialog();
  
          if (result == DialogResult.OK)
          {
              using (StreamReader reader = new StreamReader(openFileDialog1.FileName))
              {
                  string line;
  
                  while ((line = reader.ReadLine()) != null)
                  {
                      ParseCsvLine(line);
                  }
              }
          }
      }
  
      private void ParseCsvLine(string line)
      {
          if (line != string.Empty)
          {
              string[] result;
  
              using (var csvParser = new TextFieldParser(new StringReader(line)))
              {
                  csvParser.Delimiters = new string[] { "," };
  
                  result = csvParser.ReadFields();
              }
  
              foreach (var item in result)
              {
                  Console.WriteLine(item + Environment.NewLine);
              }
          }
      }
  </code></pre>
  
  <p>The result variable only has one item and its:</p>
  
  <pre><code>,95,54070,3635,"Test Reservation",0,102,0.00,0.00,2014-12-31,"Name of customer","$12.34 + $10, special price","extra information",,CustomerName,,,,,1234567890,youremail@domain.com,CustomerName,2014-12-31,23:59:59,16,0,60,2,120,0,NULL,NULL,NULL,
  </code></pre>