C# replace characters

14y2.7kVisual Basic .NET

In a C# 2008 application, I am creating directory paths like the following in code:
C:\\temp\\testt1\\customer.

I need to be able to save this value in columns in a sql server 2008 r2 database. I
want the above directory to be saved as:

C:\temp\testt1\customer.

I have tried to replace \\ with \ using the replace string function but I am getting escape character errors.

Thus can you tell me how to resolve this problem?

5 Replies

Know the answer? Post it — somebody with the same question will find it here.

Vulpes14y ago
Accepted answer
You'd need to replace "\\" with @"\" :

ConfigurationSettings.AppSettings["Location"] + @"\" + Format_Date + @"\" + custName + "(" + pId + ")" + @"\";

Not really worth doing.
0
dc14y ago
How would a verbatim work for the following: ConfigurationSettings.AppSettings["Location"] + "\\" + Format_Date + "\\" + custName + "(" + pId + ")" + "\\";
0
Vulpes14y ago
No. I'm saying to pass this C# string:

"C:\\temp\\testt1\\customer"

to the database i.e. with doubled backslashes.

You could also use a 'verbatim' string (preceded by @) with single backslashes:

@"C:\temp\testt1\customer"

Both of these represent the same string in C#.

0
dc14y ago
You are saying to have the value as: C:\ntemp\ntestt1\ncustomer? This will cause my value to

be C:\temp\testt1\customer in the database?
0
Vulpes14y ago
Just save the string inclusive of the doubled backslashes which are needed in C# to distinguish the use of the backslash in escape sequences (such as \n, \t etc).

It should then save in the database as a path with single backslashes
0