Regex string replace in c#

Question

I have one string like

var input =  "data1, data2, 1233456,  \"\"\" test, data, here \"\"\", 08976, test data"

I want to replace \"\"\" test, data, here \"\"\" part of this string with test; data; here

In simple words replace comma ',' with semincolon ';' any string inside \"\"\" block only.

I am trying to do this with a Regular expression.

I am trying to use following regex - \[\\\\\"](.+)[\\\\\"]

Go ahead and add your abortive code attempts to your question. It won't make the question more clear, but it may allow people to point out a small misconception you may have...and it also makes people much more likely to answer the question (odd, but true.) — Beska
– Beska, Commented Oct 4, 2013 at 12:38
As @Beska says ... people are more likely to help if they know you have tried. Posting your code shows that — Rob
– Rob, Commented Oct 4, 2013 at 12:41

Øyvind Bråthen · Accepted Answer · 2013-10-04 12:44:40Z

2

Just for reference, if you want a non-regex solution to compare, you can do this with LINQ as well:

input= string.Join("\"\"\"", 
         input.Split(new []{"\"\"\""}, StringSplitOptions.None)
         .Select( (s,i) => i % 2 == 1 ? s.Replace (',', ';') : s)
       );

answered Oct 4, 2013 at 12:44

Øyvind Bråthen

60.9k28 gold badges128 silver badges154 bronze badges

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

Comments

Community · Accepted Answer · 2017-05-23 12:13:05Z

1

Thanks guy for help,

Your answers were useful.

Finally managed to do this with following code with help of this link

//My input string
var input  = Regex.Replace(input  , "[\\\"](.+)[\\\"]", ReplaceMethod);


//Method used to replace 
public static string ReplaceMethod(Match m)
    {
        string newValue = m.Value;
        return newValue.Replace("\"", "").Replace(",", ";");
    }

edited May 23, 2017 at 12:13

CommunityBot

11 silver badge

answered Oct 4, 2013 at 13:08

Nikhil Chavan

1,7152 gold badges20 silver badges39 bronze badges

Comments

oobe · Accepted Answer · 2013-10-04 12:56:09Z

0

I don't think it is possible to do this with regex for this string:
data1, 1233456, """ test, data, here """, 08976, test, """ second, data """, aso

It is possible for:
data1, 1233456, < test, data, here >, 08976, test, < second, data >, aso

but not "xxx"

pattern: \"{3}.*\"{3}
foreach regex matching this pattern string.replace(',', ';')

but i'm trying to make regex...
and I give up :/

edited Oct 4, 2013 at 12:56

answered Oct 4, 2013 at 12:48

oobe

4683 silver badges7 bronze badges

1 Comment

Nikhil Chavan Over a year ago

Please check my answer, it's possible

gpmurthy · Accepted Answer · 2013-10-04 13:11:28Z

0

The following code is might satisfy the requirement...

var output = Regex.Replace(input , "(?<=\"\"\".+),(?=.+\"\"\")", ";");

answered Oct 4, 2013 at 13:11

gpmurthy

2,42721 silver badges21 bronze badges

4 Comments

oobe Over a year ago

I don't think it is possible to do this with regex for this string: data1, 1233456, """ test, data, here """, 08976, test, """ second, data """, aso

gpmurthy Over a year ago

Can you confirm that the input is data1, data2, 1233456, """ test, data, here """, 08976, test data (without the escape characters)?

gpmurthy Over a year ago

When you run above Regex.Replace you should get...data1, data2, 1233456, """ test; data; here """, 08976, test data (without the escape). Let me know if that is/isn's what you are looking for.

oobe Over a year ago

you can test here: fiddle.re/5mawn but even if you fix this it will be correct for data after """ and before begining of the next """

Collectives™ on Stack Overflow

Regex string replace in c#

4 Answers 4

Comments

Comments

1 Comment

4 Comments

Your Answer

Linked

Hot Network Questions

Collectives™ on Stack Overflow

4 Answers 4

Comments

Comments

1 Comment

4 Comments

Your Answer

Sign up or log in

Post as a guest

Linked

Related