C # line - creating an unbound backslash

Question

I am using .NET code (C #) to write to a database that interacts with a Perl application. When a single quote appears in a string, I need to "escape" from it. IOW, the name O'Bannon must be converted to O\'Bannon for the UPDATE database. However, all string manipulation efforts (like Replace) generate an escape character for the backslash, and I end up O\\'Bannon .

I know that it actually generates a second backslash, because I can read the resulting value of the database field (i.e. this is not just an IDE debug value for the string).

How can I get only one backslash in the output string?

R

Answer 1

Well i did

 "O'Bannon".Replace("'","\\'") 

and result

 "O\'Bannon" 

Is this what you want?

Answer 2

You can use "\\" , which is an escape char followed by a backslash.

See the Escape Sequences list here: http://msdn.microsoft.com/en-us/library/h21280bw.aspx

Answer 3

it's even better to assign a var variable so you can check it if necessary

 var RepName = "O'Bannon"; var Repstr = RepName.Replace("'","\\'"); 

Answer 4

You can also use the shorthand line

 s = s.Replace("'", @"\'");