Javascript: Splitting a string by comma but ignoring commas in quotes

by 
> str.match(/('[^']+'|[^,]+)/g)
["A", "B", "C", "E", "'F,G,bb'", "H", "'I9,I8'", "J", "K"]

Though you requested this, you may not accounted for corner-cases where for example:

  • 'bob\'s' is a string where ' is escaped
  • a,',c
  • a,,b
  • a,b,
  • ,a,b
  • a,b,'
  • ',a,b
  • ',a,b,c,'

Some of the above are handled correctly by this; others are not. I highly recommend that people use a library that has thought this through, to avoid things such as security vulnerabilities or subtle bugs, now or in the future (if you expand your code, or if other people use it).

Explanation of the RegEx:

  • ('[^']+'|[^,]+) – means match either '[^']+' or [^,]+
  • '[^']+' means quote…one-or-more non-quotes…quote.
  • [^,]+ means one-or-more non-commas

Note: by consuming the quoted string before the unquoted string, we make the parsing of the unquoted string case easier.

More Related Contents:

  1. Javascript Array – Split string at numbers [closed]
  2. How do I split a string with multiple separators in JavaScript?
  3. Is there a built in way to convert a comma-separated string to an array?
  4. How can I parse a CSV string with JavaScript, which contains comma in data?
  5. Split large string in n-size chunks in JavaScript
  6. javascript regex split produces too many items
  7. Javascript split string on space or on quotes to array
  8. Javascript split regex question
  9. Split a string based on multiple delimiters
  10. javascript split string by space, but ignore space in quotes (notice not to split by the colon too)
  11. Split by Caps in Javascript
  12. How do you split a javascript string by spaces and punctuation?
  13. Negative lookbehind equivalent in JavaScript
  14. Remove not alphanumeric characters from string
  15. Regular Expression | Leap Years and More
  16. How to write regex to validate dates?
  17. Javascript – Regex to validate date format [duplicate]
  18. Replacing the nth instance of a regex match in Javascript
  19. Split string on commas but ignore commas within double-quotes?
  20. JavaScript Regex Global Match Groups
  21. How can I put [] (square brackets) in RegExp javascript?
  22. RegEx to match stuff between parentheses
  23. Javascript to csv export encoding issue
  24. Regex eError when using {1}+ possessive quantifier in JavaScript regex
  25. Check if string contains only letters in javascript
  26. regular expression to validate datetime format (MM/DD/YYYY) [duplicate]
  27. Extract keyword from Google search in Javascript
  28. Regex matching emoticons
  29. Regex: only alphanumeric but not if this is pure numeric
  30. How to count the number of lines of a string in javascript

Leave a Comment