regex to split line (csv file)

by

Just adding the solution I worked on this morning.

var regex = new Regex("(?<=^|,)(\"(?:[^\"]|\"\")*\"|[^,]*)");

foreach (Match m in regex.Matches("<-- input line -->"))
{
    var s = m.Value; 
}

As you can see, you need to call regex.Matches() per line. It will then return a MatchCollection with the same number of items you have as columns. The Value property of each match is, obviously, the parsed value.

This is still a work in progress, but it happily parses CSV strings like:

2,3.03,"Hello, my name is ""Joshua""",A,B,C,,,D

More Related Contents:

  1. How to split csv whose columns may contain ,
  2. Reading CSV file and storing values into an array
  3. Using RegEx to balance match parenthesis
  4. How do I extract text that lies between parentheses (round brackets)?
  5. How do I replace the *first instance* of a string in .NET?
  6. Reading a CSV file in .NET?
  7. Find a string between 2 known values
  8. Regex to strip line comments from C#
  9. C#, regular expressions : how to parse comma-separated values, where some values might be quoted strings themselves containing commas
  10. Need to perform Wildcard (*,?, etc) search on a string using Regex
  11. Why \b does not match word using .net regex
  12. RegEx for an IP Address
  13. Regex that matches a newline (\n) in C#
  14. Count regex replaces (C#)
  15. Regex replace multiple groups
  16. How to split csv whose columns may contain comma
  17. .Net regex: what is the word character \w?
  18. Writing a CSV file in .net
  19. Regex nested parentheses
  20. Regex: Repeated capturing groups
  21. Canadian postal code validation
  22. Why doesn’t $ in .NET multiline regular expressions match CRLF?
  23. Upload CSV file to SQL server
  24. Is there a “proper” way to read CSV files [duplicate]
  25. Regex for Money
  26. C# System.RegEx matches LF when it should not
  27. Regex for matching a character, but not when it’s enclosed in square bracket
  28. Does any one know of a faster method to do String.Split()?
  29. What is a “Nested Quantifier” and why is it causing my regex to fail?
  30. Regular expression to validate valid time

Leave a Comment