Delete the comma from the string when comma and parenthesis exists in field without considering comma within the parenthesis

Question

I'm trying to use a regular expression in C# csv that can contain: code as

a,a,(a,b,(a)).

I have tried the following:

var result = (from Match m in Regex.Matches(input, @"([^,()]+(\([^()]*\))?") select m.Value).ToArray();
string result1 = ConvertStringArrayToString(result);
textBox2.Text = result1;

but i get output like this:

a
a
a
b(a)

possible duplicate of [How to parse a comma delimited string when comma and parenthesis exists in field](http://stackoverflow.com/questions/5477767/how-to-parse-a-comma-delimited-string-when-comma-and-parenthesis-exists-in-field) — David Arno, Sep 18 '15 at 08:17
Also see http://stackoverflow.com/questions/732029/how-to-split-string-by-unless-is-within-brackets-using-regex for an alternative solution. — David Arno, Sep 18 '15 at 08:18

score 0 · Answer 1 · edited May 23 '17 at 10:27

0

You need balancing group definitions to make it work:

[^,()]*(?:\(([^()]*|(?<open>\()|(?<-open>\)))*(?(open)(?!))\))*[^,()]*

DEMO

A good introduction into BGD is here and here

edited May 23 '17 at 10:27

Community

1
1

answered Sep 21 '15 at 08:17

Sebastian Schumann

3,204
19
37

Delete the comma from the string when comma and parenthesis exists in field without considering comma within the parenthesis

1 Answers1