C# string replace in outer string only

Question

Is there a way to do a replace in a string like this? (this is simplified example)

string input = "INSERT INTO blah VALUES \" blah blah \r\n \" \r\n (here can be anything like several new lines and \t tabs) INSERT INTO blah VALUES \" blah blah \r\n \" \r\n";

input.Replace("\r\n", "\n"); // this is just example, it doesn't work the way I need it

// and the output would look like this:
string output= "INSERT INTO blah VALUES \" blah blah \r\n \" \n INSERT INTO blah VALUES \" blah blah \r\n \" \n";

So it would replace new lines only outside the SQL commands? Can this be safely achieved using regular expressions?

EDIT: the replace must be probably realised with \r\n to \n there could be more of them between the SQL commands. The commands are not precisely separated.

EDIT: so the basic problem is - how do I replace in the outer string only?

string = "outer string \"inner string\" outer string \"inner string\" outer string"

If you are using it for SQL statements I strongly recommend SqlParameters: dotnetperls.com/sqlparameter — RvdK
– RvdK, Commented Aug 29, 2012 at 8:09
Replace returns new string so code should look like input = input.Replace("\r\n", "\n"); — Renatas M.
– Renatas M., Commented Aug 29, 2012 at 8:09

Bob Vale · Accepted Answer · 2012-08-29 09:02:43Z

Do you want something like this....

/// <summary>
///  Regular expression built for C# on: Wed, Aug 29, 2012, 09:56:25 AM
///  Using Expresso Version: 3.0.4334, http://www.ultrapico.com
///  
///  A description of the regular expression:
///  
///  [1]: A numbered capture group. [(?<counter>").*?(?<-counter>").*?(?(counter)(?!))]
///      (?<counter>").*?(?<-counter>").*?(?(counter)(?!))
///          [counter]: A named capture group. ["]
///              "
///          Any character, any number of repetitions, as few as possible
///          Balancing group. Remove the most recent [counter] capture from the stack. ["]
///              "
///          Any character, any number of repetitions, as few as possible
///          Conditional Expression with "Yes" clause only
///              Did the capture named [counter] match?
///              If yes, search for [(?!)]
///                  Match if suffix is absent. []
///                      NULL
///  \r\n
///      Carriage return
///      New line
///  
///
/// </summary>
Regex regex = new Regex(
      "((?<counter>\").*?(?<-counter>\").*?(?(counter)(?!)))\\r\\n",
    RegexOptions.CultureInvariant
    | RegexOptions.Compiled
    | RegexOptions.Singleline
    );

string input = "INSERT INTO blah VALUES \" blah blah \r\n \" \r\n (here can be anything like several new lines and \t tabs) INSERT INTO blah VALUES \" blah blah \r\n \" \r\n";

string output output=regex.Replace(input,"$1\n");

The effect of (?<counter>").*?(?<-counter>").*?(?(counter)(?!)) is to match only balancing " characters so to only find the \r\n outside the quotes

Chibueze Opata · Accepted Answer · 2012-08-29 08:16:28Z

0

You sound like you want to replace \r\n \" \r\n with \r\n \" \n

input = input.Replace("\r\n \" \r\n", "\r\n \" \n");

answered Aug 29, 2012 at 8:16

Chibueze Opata

10.1k8 gold badges47 silver badges71 bronze badges

1 Comment

Jan Matousek Over a year ago

the amount of new lines between the sql commands are iregular and the commands can be different

Collectives™ on Stack Overflow

C# string replace in outer string only

2 Answers 2

Comments

1 Comment

Your Answer

Hot Network Questions

Collectives™ on Stack Overflow

2 Answers 2

Comments

1 Comment

Your Answer

Sign up or log in

Post as a guest

Related