How do I separate by comma this string?

Question

I need to separate the following string by comma and get the chunks down below. What's the most elegant solution in C#? String.Split() detects also internal commas, of course.

"'_82X5_00_11 (2,RAL 7035)', '_82X5_00_11 (2,RAL 7035)', #349, #1 "

The result should be:

'_82X5_00_11 (2,RAL 7035)'
'_82X5_00_11 (2,RAL 7035)'
#349
#1

Thanks.

is there always a whitespace character after the comma you want to split on? — user1666620, Jul 15 '15 at 15:11
treat it as csv data, and tell the csv parser that the fields are enclosed-by `'`. — Marc B, Jul 15 '15 at 15:13

Leandro Soares · Answer 1 · 2015-07-16T08:45:30.347

0

Try this:

string aux = "'_82X5_00_11 (2,RAL 7035)', '_82X5_00_11 (2,RAL 7035)', #349, #1 ";
var result = Regex.Split(aux, ("(?!\\B'[^']*),(?![^']*'\\B)"));

EDIT

This was not getting the " '', '' " because '' doesn't contain anything.

Solution:

string pattern = "('[^']+'|[^',^\\s]+|['']+)";
string str1 = "'_82X5_00_11 (2,RAL 7035)', '_82X5_00_11 (2,RAL 7035)', #349, #1 ";
string str2 = "'', '', #344, #334";
var result1 = Regex.Matches(str1, pattern).Cast<Match>().Select(x => x.Value).ToArray();
var result2 = Regex.Matches(str2, pattern).Cast<Match>().Select(x => x.Value).ToArray();

edited Jul 16 '15 at 08:45

answered Jul 15 '15 at 15:25

Leandro Soares

2,902
2
27
39

It does not work for the following string: `" '', '', #344, #334 "`. It returns 3 chunks instead of 4. Do you know why? – abenci Jul 16 '15 at 06:58
Wow that's tricky because of the '', '' without anything between the ' char – Leandro Soares Jul 16 '15 at 08:27
@Alberto Added solution – Leandro Soares Jul 16 '15 at 09:02
What about this? `"'TS8 8245.500 (2)', 'TS8 8245.500 (2)', 'PART-TS8 8245.500 (2)-DESC', ( #596 )"` It should return only 4 elements, not 6. – abenci Jul 16 '15 at 11:47

How do I separate by comma this string?

1 Answers1