Splitting on comma outside quotes

by

You can try out this regex:

str.split(",(?=(?:[^\"]*\"[^\"]*\")*[^\"]*$)");

This splits the string on , that is followed by an even number of double quotes. In other words, it splits on comma outside the double quotes. This will work provided you have balanced quotes in your string.

Explanation:

,           // Split on comma
(?=         // Followed by
   (?:      // Start a non-capture group
     [^"]*  // 0 or more non-quote characters
     "      // 1 quote
     [^"]*  // 0 or more non-quote characters
     "      // 1 quote
   )*       // 0 or more repetition of non-capture group (multiple of 2 quotes will be even)
   [^"]*    // Finally 0 or more non-quotes
   $        // Till the end  (This is necessary, else every comma will satisfy the condition)
)

You can even type like this in your code, using (?x) modifier with your regex. The modifier ignores any whitespaces in your regex, so it’s becomes more easy to read a regex broken into multiple lines like so:

String[] arr = str.split("(?x)   " + 
                     ",          " +   // Split on comma
                     "(?=        " +   // Followed by
                     "  (?:      " +   // Start a non-capture group
                     "    [^\"]* " +   // 0 or more non-quote characters
                     "    \"     " +   // 1 quote
                     "    [^\"]* " +   // 0 or more non-quote characters
                     "    \"     " +   // 1 quote
                     "  )*       " +   // 0 or more repetition of non-capture group (multiple of 2 quotes will be even)
                     "  [^\"]*   " +   // Finally 0 or more non-quotes
                     "  $        " +   // Till the end  (This is necessary, else every comma will satisfy the condition)
                     ")          "     // End look-ahead
                         );

More Related Contents:

  1. How to split a string if any chracter is found in java
  2. Split string to equal length substrings in Java
  3. Split string with dot as delimiter
  4. Java string split with “.” (dot) [duplicate]
  5. Splitting a string at every n-th character
  6. How to split String with some separator but without removing that separator in Java? [duplicate]
  7. Extracting pairs of words using String.split()
  8. Java String.split() Regex
  9. Split a string, at every nth position
  10. Java String.split() sometimes giving blank strings
  11. How to Split a mathematical expression on operators as delimiters, while keeping them in the result?
  12. Java split is eating my characters
  13. Split string into repeated characters
  14. Java replace all square brackets in a string
  15. Need some advice on split() method in Java [closed]
  16. Java: splitting a comma-separated string but ignoring commas in quotes
  17. Splitting a Java String by the pipe symbol using split(“|”)
  18. Why in Java 8 split sometimes removes empty strings at start of result array?
  19. Using Java to find substring of a bigger string using Regular Expression
  20. Compare one String with multiple values in one expression
  21. Replace the last part of a string
  22. How do I split a string in Java?
  23. Split regex to extract Strings of contiguous characters
  24. Java: How to split a string by a number of characters?
  25. Java split string to array [duplicate]
  26. Check if string ends with certain pattern
  27. Java String.replace/replaceAll not working
  28. split string only on first instance – java
  29. How can split a string which contains only delimiter?
  30. Java’s Scanner vs String.split() vs StringTokenizer; which should I use?

Leave a Comment