replace word using Regex, but not in Quotes in C#

Asked Jul 26 '11 at 08:45

Active Jul 26 '11 at 09:16

Viewed 163 times

Possible Duplicate:
Alternative to regex: match all instances not inside quotes

I need to be able to replace all occurrence of a word other than those present in single quotes. for example, input string is

insert into Tbale(spname,id,date)values('sp_List ','Date','01/01/2011')
exec sp_List

Replacement string for sp_list is DBobject, output should look like

insert into Tbale(spname,id,date)values('sp_List ','Date','01/01/2011')
exec DBobject

what regex expression should i use?

edited May 23 '17 at 12:11

Community

asked Jul 26 '11 at 08:45

rsapru

@Jens, i had see that but for some reason that doesn't work for me – rsapru Jul 26 '11 at 09:11
Sorry, i should have mentioned that, i am using C# – rsapru Jul 26 '11 at 09:15
Got my answer from post http://stackoverflow.com/questions/632475/regex-to-pick-commas-outside-of-quotes – rsapru Jul 26 '11 at 12:20

0 Answers0