Split commas on string with regular expression in JavaScript

Question

I'm beginner at regular expression. I need your advice on it.

I want to split a string by commas which are outside a couple of single quote with regular expression.

Regex pattern: ,(?=([^']*'[^']*')*[^']*$)

String input: "'2017-10-16 10:44:43.0000000', 'Abc,'', de', '0', None"

Expected output: ["'2017-10-16 10:44:43.0000000'", " 'Abc,'', de'", " '0'", " None"] there is an array with 4 elements.

Currently, I'm using split method with regex and It's working well on JAVA. Now I have to handle it by JavaScript but I have got an unexpected result!

Could you please give me an advice?

Thanks for your help!

?? using .split(',') should work! what unexpected result are you getting? — Fallenhero
– Fallenhero, Commented Oct 16, 2017 at 14:26
@Fallenhero: He doesn't want to split 'Abc,' in that input. That comma is part of the string, it's not a separator. — Cerbrus
– Cerbrus, Commented Oct 16, 2017 at 14:30
no, it's not! As you can see my input, there is some cases one of them has comma inside. 'Abc,'', de' is one element. — Chuong Tran
– Chuong Tran, Commented Oct 16, 2017 at 14:31

Wiktor Stribiżew · Accepted Answer · 2017-10-16 19:10:21Z

2

Your regex contains a capturing group, ([^']*'[^']*').

When you use a capturing group in a regex that you pass to String#split() in Java, the capturing groups are not added to the resulting split array of strings. In JavaScript, String#split() adds all captured substrings into the resulting array.

To make the pattern compatible between the two engines, just turn the capturing group with a non-capturing one,

,(?=(?:[^']*'[^']*')*[^']*$)
    ^^^            ^

See the regex demo.

JS demo:

var rx = /,(?=(?:[^']*'[^']*')*[^']*$)/;
var s = "'2017-10-16 10:44:43.0000000', 'Abc,'', de', '0', None";
console.log(s.split(rx));

answered Oct 16, 2017 at 19:10

Wiktor Stribiżew

631k41 gold badges502 silver badges632 bronze badges

Sign up to request clarification or add additional context in comments.

Collectives™ on Stack Overflow

Split commas on string with regular expression in JavaScript

1 Answer 1

Comments

Your Answer

Hot Network Questions

Collectives™ on Stack Overflow

1 Answer 1

Comments

Your Answer

Sign up or log in

Post as a guest

Related