How to split csv whose columns may contain ,

by

Use the Microsoft.VisualBasic.FileIO.TextFieldParser class. This will handle parsing a delimited file, TextReader or Stream where some fields are enclosed in quotes and some are not.

For example:

using Microsoft.VisualBasic.FileIO;

string csv = "2,1016,7/31/2008 14:22,Geoff Dalgas,6/5/2011 22:21,http://stackoverflow.com,\"Corvallis, OR\",7679,351,81,b437f461b3fd27387c5d8ab47a293d35,34";

TextFieldParser parser = new TextFieldParser(new StringReader(csv));

// You can also read from a file
// TextFieldParser parser = new TextFieldParser("mycsvfile.csv");

parser.HasFieldsEnclosedInQuotes = true;
parser.SetDelimiters(",");

string[] fields;

while (!parser.EndOfData)
{
    fields = parser.ReadFields();
    foreach (string field in fields)
    {
        Console.WriteLine(field);
    }
} 

parser.Close();

This should result in the following output:

2
1016
7/31/2008 14:22
Geoff Dalgas
6/5/2011 22:21
http://stackoverflow.com
Corvallis, OR
7679
351
81
b437f461b3fd27387c5d8ab47a293d35
34

See Microsoft.VisualBasic.FileIO.TextFieldParser for more information.

You need to add a reference to Microsoft.VisualBasic in the Add References .NET tab.

More Related Contents:

  1. How to read a CSV file into a .NET Datatable
  2. Reading CSV file and storing values into an array
  3. Reading a CSV file in .NET?
  4. Using C# to search a CSV file and pull the value in the column next to it
  5. How to split csv whose columns may contain comma
  6. Writing a CSV file in .net
  7. Upload CSV file to SQL server
  8. Is there a “proper” way to read CSV files [duplicate]
  9. Does any one know of a faster method to do String.Split()?
  10. Writing a Header using CsvHelper? C#
  11. regex to split line (csv file)
  12. When reading a CSV file using a DataReader and the OLEDB Jet data provider, how can I control column data types?
  13. Get all checked nodes of a treeview
  14. GETting a URL with an url-encoded slash
  15. How to select min and max values of a column in a datatable?
  16. GetMethod for generic method [duplicate]
  17. Programmatically get the version number of a DLL
  18. How to pass a table-value parameter
  19. Do interfaces derive from System.Object? C# spec says yes, Eric says no, reality says no
  20. When is using the C# ref keyword ever a good idea?
  21. Event handlers not thread safe? [duplicate]
  22. How to correctly unregister an event handler
  23. Difference between lock(locker) and lock(variable_which_I_am_using)
  24. Binding an enum to a WinForms combo box, and then setting it
  25. Use Task.Run() in synchronous method to avoid deadlock waiting on async method?
  26. Convert Transparent PNG to JPG with Non-Black Background Color
  27. Sql Bulk Copy/Insert in C#
  28. Target 32 Bit or 64 Bit native DLL depending on environment
  29. How do I get a return value from Task.WaitAll() in a console app?
  30. .Net Excel Interop Deleting a worksheet

Leave a Comment