I'm sorting through a CSV file splitting (using .match()) on commas outside of quotes, and what I have so far is working:
/"[^"]*"|[^,]+/g
The only problem is that there are several areas where the string might be something like:
...,xxx,,xxx,...
and what I want to have happen is that I get a an array from that of:
[...,xxx, ,xxx,...]
but instead I get
[...,xxx,xxx,...]
changing it to
/"[^"]*"|[^,]*/g
doesn't work out so well. Any thoughts?
You can use replace function like this:
var str = yourString.replace(/,,/g,', ,')
And after that you will get what You need with your regex, hope it helps. Cheers.
I tried to change your original regexp to also add empty elements if you have sequences of ,,. It doesn't add an empty element for "a",, but i assume that's not what you want
The regexp is:
/"[^"]*"|[^,]+|(?=,,)/g
Example usage:
var input = 'ACP,Something,,"Some long, sentence, with commas",other things';
var matches = input.match(/"[^"]*"|[^,]+|(?=,,)/g);
console.log(matches); // ["ACP", "Something", "", "\"Some long, sentence, with commas\"", "other things"]
,,, but does not consume them! So this matches any empty string that is followed by two commas. regular-expressions.info/lookaround.htmlSilly question: Why are you using a regexp here?
console.log("aaa,xxx,,xxx,,yyy,zzz".split(","));
> ["aaa", "xxx", "", "xxx", "", "yyy", "zzz"]
Don't use replace. Instead split on a regexp values.split(/super awesome regexp/) However, you probably want better control. See this answer for a better solution.
