How to split string on comma, except when comma is parameter separator or part of string

Asked Apr 18 '17 at 12:31

Active Apr 18 '17 at 12:46

Viewed 43 times

How to split string on comma, except when comma is parameter separator or part of string?

for example:

one,"two","three[r,6]",four[6,5],"five,sex"

should be:

one

"two"

"three[r,6]"

four[6,5]

"five,sex"

,(?!\d+])

But this still not working when comma is part of string ("five,six" in my example).

Thank you for your help.

asked Apr 18 '17 at 12:31

Raskolnikov

1

Try matching with [`"[^"]*"|\w+(?:\[[^][]*])*`](https://regex101.com/r/eQBNFd/1). – Wiktor Stribiżew Apr 18 '17 at 12:33
@Wiktor This is very close to what I need, but not working in case like this https://regex101.com/r/eQBNFd/2 – Raskolnikov Apr 18 '17 at 13:00
@Wiktor Should split on comma , but should not split on dot. – Raskolnikov Apr 18 '17 at 13:01
You say you are using C#, why bother with regex? Use [this solution](http://stackoverflow.com/questions/6542996/how-to-split-csv-whose-columns-may-contain/6543418#6543418). – Wiktor Stribiżew Apr 18 '17 at 13:06
@Wiktor This will not work in case when comma is in parameter "param[1,2]". With regex I will have more elegant solution. – Raskolnikov Apr 18 '17 at 13:13
1

It is much easier to replace the comma inside `[...]` (with `Regex.Replace(s, @"\[[^][]+]", m => m.Value.Replace(",", "TMP_COMMA"))`, use the method I link to, and then restore the commas inside the square brackets than trying to obtain an elegant regex. – Wiktor Stribiżew Apr 18 '17 at 13:15
Ok this could be solution. How to replace comma inside ". . ." ? – Raskolnikov Apr 18 '17 at 13:25
1

Same way as above - just use `"\"[^\"]+\""` regex. – Wiktor Stribiżew Apr 18 '17 at 13:27
Thank you. You can post answer so that I can accept. – Raskolnikov Apr 18 '17 at 13:55
Or use an axe... – Casimir et Hippolyte Apr 18 '17 at 16:21

0 Answers0