Escaping Quotes

[maliary]

Hi, I have values in my database that have quotes e.g Spanner 2",Tyre 12" I am working on escaping them so that the output to a CSV file is legible. Currently I have

data = data.Replace("\"","\\\"");

Which is not working because the \" is not there. Instead I have " without the slash. How can I escape them ?

Let's do this !

[dipak dipak]

Hello, You may replace the " char to any other char, like this data = data.Replace('"','\'); if you want to replace "(quote) to a string then you have to replace with a special character as above then u can replece that special char (as String) to any string. data = data.Replace('"','`'); // replacing old char to new char data = data.Replace("`","\\\"); // replaceing old String to new String It think u can solve your problem.. Best of Luck.

Dipak

[PIEBALDconsult]

That should work. I just tried:

string s = "12\" tire" ;

System.Console.WriteLine ( s ) ;

s = "\"" + s.Replace ( "\"" , "\\\"" ) + "\"" ;

System.Console.WriteLine ( s ) ;

And got

12" tire
"12\" tire"

as expected. It's possible that the " character is not actually a " character, it could be some other Unicode character. (It could be Double Prime ″ Unicode 2033 for example.)