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 - \[\\\\\"](.+)[\\\\\"]

Answer 1

The following code is might satisfy the requirement...

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

Answer 2

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(",", ";");
    }

Answer 3

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 :/

Answer 4

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)
       );