split a comma-separated string with both quoted and unquoted strings [duplicate]

by

Depending on your needs you may not be able to use a csv parser, and may in fact want to re-invent the wheel!!

You can do so with some simple regex

(?:^|,)(\"(?:[^\"]+|\"\")*\"|[^,]*)

This will do the following:

(?:^|,) = Match expression “Beginning of line or string ,“

(\"(?:[^\"]+|\"\")*\"|[^,]*) = A numbered capture group, this will select between 2 alternatives:

  1. stuff in quotes
  2. stuff between commas

This should give you the output you are looking for.

Example code in C#

 static Regex csvSplit = new Regex("(?:^|,)(\"(?:[^\"]+|\"\")*\"|[^,]*)", RegexOptions.Compiled);

public static string[] SplitCSV(string input)
{

  List<string> list = new List<string>();
  string curr = null;
  foreach (Match match in csvSplit.Matches(input))
  {        
    curr = match.Value;
    if (0 == curr.Length)
    {
      list.Add("");
    }

    list.Add(curr.TrimStart(','));
  }

  return list.ToArray();
}

private void button1_Click(object sender, RoutedEventArgs e)
{
    Console.WriteLine(SplitCSV("111,222,\"33,44,55\",666,\"77,88\",\"99\""));
}

Warning As per @MrE’s comment – if a rogue new line character appears in a badly formed csv file and you end up with an uneven (“string) you’ll get catastrophic backtracking (https://www.regular-expressions.info/catastrophic.html) in your regex and your system will likely crash (like our production system did). Can easily be replicated in Visual Studio and as I’ve discovered will crash it. A simple try/catch will not trap this issue either.

You should use:

(?:^|,)(\"(?:[^\"])*\"|[^,]*)

instead

More Related Contents:

  1. extract number out strings c# [closed]
  2. RegEx to remove key and certificate headers and footers [duplicate]
  3. c# Regular Expression for the text below? [closed]
  4. Get string between two strings in a string
  5. Using RegEx to balance match parenthesis
  6. Using String Format to show decimal up to 2 places or simple integer
  7. Overlapping matches in Regex
  8. Regular expression for decimal number
  9. How to keep the delimiters of Regex.Split?
  10. How to find multiple occurrences with regex groups?
  11. Getting overlapping regex matches in C#
  12. C# Regex for Guid
  13. Regex: C# extract text within double quotes
  14. .Net regex matching $ with the end of the string and not of line, even with multiline enabled
  15. How do I filter all HTML tags except a certain whitelist?
  16. Why \b does not match word using .net regex
  17. RegEx for an IP Address
  18. Regex word boundary expressions
  19. Count regex replaces (C#)
  20. Regex to match all us phone number formats
  21. How to remove numbers from string using Regex.Replace?
  22. .Net regex: what is the word character \w?
  23. Regex: Repeated capturing groups
  24. Canadian postal code validation
  25. Regex to match a word with + (plus) signs
  26. c# regex matches example
  27. Regex Non-Greedy (Lazy)
  28. using static Regex.IsMatch vs creating an instance of Regex
  29. Regular expression to validate valid time
  30. regex to split line (csv file)

Leave a Comment