Java: splitting a comma-separated string but ignoring commas in quotes

by

Try:

public class Main { 
    public static void main(String[] args) {
        String line = "foo,bar,c;qual=\"baz,blurb\",d;junk=\"quux,syzygy\"";
        String[] tokens = line.split(",(?=(?:[^\"]*\"[^\"]*\")*[^\"]*$)", -1);
        for(String t : tokens) {
            System.out.println("> "+t);
        }
    }
}

Output:

> foo
> bar
> c;qual="baz,blurb"
> d;junk="quux,syzygy"

In other words: split on the comma only if that comma has zero, or an even number of quotes ahead of it.

Or, a bit friendlier for the eyes:

public class Main { 
    public static void main(String[] args) {
        String line = "foo,bar,c;qual=\"baz,blurb\",d;junk=\"quux,syzygy\"";

        String otherThanQuote = " [^\"] ";
        String quotedString = String.format(" \" %s* \" ", otherThanQuote);
        String regex = String.format("(?x) "+ // enable comments, ignore white spaces
                ",                         "+ // match a comma
                "(?=                       "+ // start positive look ahead
                "  (?:                     "+ //   start non-capturing group 1
                "    %s*                   "+ //     match 'otherThanQuote' zero or more times
                "    %s                    "+ //     match 'quotedString'
                "  )*                      "+ //   end group 1 and repeat it zero or more times
                "  %s*                     "+ //   match 'otherThanQuote'
                "  $                       "+ // match the end of the string
                ")                         ", // stop positive look ahead
                otherThanQuote, quotedString, otherThanQuote);

        String[] tokens = line.split(regex, -1);
        for(String t : tokens) {
            System.out.println("> "+t);
        }
    }
}

which produces the same as the first example.

EDIT

As mentioned by @MikeFHay in the comments:

I prefer using Guava’s Splitter, as it has saner defaults (see discussion above about empty matches being trimmed by String#split(), so I did: 

Splitter.on(Pattern.compile(",(?=(?:[^\"]*\"[^\"]*\")*[^\"]*$)"))

More Related Contents:

  1. Splitting a Java String by the pipe symbol using split(“|”)
  2. Split string to equal length substrings in Java
  3. Split string with dot as delimiter
  4. Splitting on comma outside quotes
  5. Java string split with “.” (dot) [duplicate]
  6. Java how to replace 2 or more spaces with single space in string and delete leading and trailing spaces
  7. How to split a string between letters and digits (or between digits and letters)?
  8. How can non-ASCII characters be removed from a string?
  9. How to extract numbers from a string and get an array of ints?
  10. How to split String with some separator but without removing that separator in Java? [duplicate]
  11. Get the index of a pattern in a string using regex
  12. Check and extract a number from a String in Java
  13. Why String.replaceAll() in java requires 4 slashes “\\\\” in regex to actually replace “\”?
  14. Java: Split string when an uppercase letter is found
  15. Split a string, at every nth position
  16. Java String.split() sometimes giving blank strings
  17. How to Split a mathematical expression on operators as delimiters, while keeping them in the result?
  18. How to replace ” \ ” with ” \\ ” in java
  19. Validate a file name on Windows
  20. Use Java and RegEx to convert casing in a string
  21. Java split is eating my characters
  22. Java String ReplaceAll method giving illegal repetition error?
  23. Find all words with 3 letters with regex
  24. How can I remove punctuation from input text in Java?
  25. String.replaceAll is considerably slower than doing the job yourself
  26. Regular Expressions on Punctuation
  27. Remove all occurrences of \ from string
  28. Split string into repeated characters
  29. Parse Date from String in this format : dd/MM/yyyy [to dd/MM/yyyy]
  30. Java replace all square brackets in a string

Leave a Comment