C#, regular expressions : how to parse comma-separated values, where some values might be quoted strings themselves containing commas

by

Try with this Regex:

"[^"\r\n]*"|'[^'\r\n]*'|[^,\r\n]*

    Regex regexObj = new Regex(@"""[^""\r\n]*""|'[^'\r\n]*'|[^,\r\n]*");
    Match matchResults = regexObj.Match(input);
    while (matchResults.Success) 
    {
        Console.WriteLine(matchResults.Value);
        matchResults = matchResults.NextMatch();
    }

Ouputs:

  • cat
  • dog
  • “0 = OFF, 1 = ON”
  • lion
  • tiger
  • ‘R = red, G = green, B = blue’
  • bear

Note: This regex solution will work for your case, however I recommend you to use a specialized library like FileHelpers.

More Related Contents:

  1. regex to split line (csv file)
  2. Regex for string matching following criteria
  3. C#. split identificator on the words [closed]
  4. Parsing CSV files in C#, with header
  5. Regex for numbers only
  6. How to read a CSV file into a .NET Datatable
  7. How can I strip HTML tags from a string in ASP.NET?
  8. Regular Expression Groups in C#
  9. Add spaces before Capital Letters
  10. Regular Expression to split on spaces unless in quotes
  11. Why does the order of alternatives matter in regex?
  12. Remove HTML tags from string including &nbsp in C#
  13. Regex: I want this AND that AND that… in any order
  14. Is there any simple way to convert .xls file to .csv file? (Excel)
  15. How to read RegEx Captures in C#
  16. Remove text in-between delimiters in a string (using a regex?)
  17. Poor man’s “lexer” for C#
  18. Sending an array of values to Oracle procedure to use in WHERE IN clause
  19. How to get text between nested parentheses?
  20. Translate Perl regular expressions to .NET
  21. Are Java and C# regular expressions compatible?
  22. C# – Regex for file paths e.g. C:\test\test.exe
  23. C# Regular Expressions, string between single quotes
  24. How do I get the name of captured groups in a C# Regex?
  25. C# Regex.Split: Removing empty results
  26. Regular expression to find and remove duplicate words
  27. using static Regex.IsMatch vs creating an instance of Regex
  28. Does any one know of a faster method to do String.Split()?
  29. Splitting a string in C#
  30. Regex to match a string after colon

Leave a Comment