How to Reomve "\" from a String

[DilipKS]

Hi

string t10 = "xftag Source=\"L\">500671";
I want to remove "\" from above string and resultant string shld be "xftag Source="L">500671"

I have tried many ways but I am not getting the desired output . One of the ways I tried , pls see below

string t10 = "xftag Source=\"L\">500671";
string r10 = t10.Replace("\"", "*");
r10 = r10.Replace('*','"');

Still I am getting same output i.e. "xftag Source=\"L\">500671

 

[chiph]

In your call to Replace, double up the backslash character.

Like C & C++, C# uses the backslash character to escape newlines, carriage-returns, tabs, etc., so to actually get one, you have to double it up.

From the C# language specification:

A character that follows a backslash character (\) in a regular-string-literal-character must be one of the following characters: ', ", \, 0, a, b, f, n, r, t, u, U, x, v. Otherwise, a compile-time error occurs.

Chip H.




If you want to get the best response to a question, please check out FAQ222-2244 first

 

[chiph]

You don't seem to be getting the answers you want.

How about rephrasing the question?

Chip H.


If you want to get the best response to a question, please check out FAQ222-2244 first

 

[obislavu]

chiph is right and I don't see a reason for you to remove that chars. The following string doesn't contains the backslah character!
string t10 = "xftag Source=\"L\">500671";
If you display it using this line, you will see the right string:
MessageBox.Show(t10);
If you like to store it anywhere then in the destination you will be stored the following chars : xftag Source="L">500671
-obislavu-

 

[DilipKS]

I agree when you display it , it doesnt show "\" but when I try to update into DB using below its giving error
Original Msg contains string which has "\" wherever double quotes are there .
-

string strCmdText = "UPDATE system_exceptions SET OriginalMessage = '" + strOriginalMsg + "' WHERE ExcpMsgID="+myChildDataSet.Tables[0].Rows[0]["ExcpMsgID"].ToString();
OdbcCommand updDBCommand = new OdbcCommand(strCmdText,myConnection2);
updDBCommand.ExecuteNonQuery();

 

[chiph]

That's a different question that what you asked.

The question should be: "Why do double-quotes cause problems when writing to the database".

And the answer is that the double-quote is a reserved character in SQL. You should use ADO Parameters to pass string values to your database (but sadly, most people are too lazy to use them). The other way would be to use the .Replace method to double-up the quote characters:

  MyStringVar = MyStringVar.Replace("""", """""");

For a good reason to use parameter objects, do a Google on "SQL Injection".

Chip H.


If you want to get the best response to a question, please check out FAQ222-2244 first