Replace character in string

[Tim Kelley]

I am reading a text file with a streamreader. I parse out path and need to
use that path in a sql statement. The path is in the file as
\\servername\share\folder\filename.txt. When the line is read, it is in the
format of \\\\servername\\share\\folder\\filename.txt. When I try to use
this in my sql statement it fails because the field in the database in in
the previous format. I have tried using Replace, but I have not gotten it
to work. Any other suggestions?

Thanks,

[Carl Daniel [VC++ MVP]]

"Tim Kelley" <tk*****@company.comwrote in message
news:OI**************@TK2MSFTNGP04.phx.gbl...

>I am reading a text file with a streamreader. I parse out path and need to
use that path in a sql statement. The path is in the file as
\\servername\share\folder\filename.txt. When the line is read, it is in
the format of \\\\servername\\share\\folder\\filename.txt. When I try to
use this in my sql statement it fails because the field in the database in
in the previous format. I have tried using Replace, but I have not gotten
it to work. Any other suggestions?

String.Replace doesn't modify the string you call it on - it returns a new
string with the replacements made.

path = path.Replace(@"\\",@"\");

-cd

[Tim Kelley]

I tried this and the results were:
\\servername\\share\\folder\\filename.txt.

Thanks,

"Carl Daniel [VC++ MVP]" <cp*****************************@mvps.org.nospam >
wrote in message news:O2*************@TK2MSFTNGP02.phx.gbl...

"Tim Kelley" <tk*****@company.comwrote in message
news:OI**************@TK2MSFTNGP04.phx.gbl...

>>I am reading a text file with a streamreader. I parse out path and need
to use that path in a sql statement. The path is in the file as
\\servername\share\folder\filename.txt. When the line is read, it is in
the format of \\\\servername\\share\\folder\\filename.txt. When I try to
use this in my sql statement it fails because the field in the database in
in the previous format. I have tried using Replace, but I have not gotten
it to work. Any other suggestions?

String.Replace doesn't modify the string you call it on - it returns a new
string with the replacements made.

path = path.Replace(@"\\",@"\");

-cd

[Jon Skeet [C# MVP]]

Tim Kelley <tk*****@company.comwrote:

I tried this and the results were:
\\servername\\share\\folder\\filename.txt.

How are you determining that? My guess is that you're actually looking
in the debugger.

See http://www.pobox.com/~skeet/csharp/s....html#debugger

--
Jon Skeet - <sk***@pobox.com>
http://www.pobox.com/~skeet Blog: http://www.msmvps.com/jon.skeet
If replying to the group, please do not mail me too

[ssamuel]

Tim,

Of course... try this:

string strIntermediate = path.Replace(@"\\",
"??intermediate-replacement??");
strIntermediate = strIntermediate.Replace(@"\\", @"\");
return strIntermediate.Replace("??intermediate-replacement??", @"\\");

Your path starts with two directory delimiters to indicate a UNC
location. You have to escape that. You could do this in one step with a
regexp, but that may just be overkill. Of course, the solution above
won't work if your string contains the escape sequence, although the
question marks would be an illegal filename. The only way to do this
without regexp and that possibility is stateful recursion.

Also keep in mind that the debugger shows the inputtable C#
representation of the string. If your string containts "A\B," the
debugger will always show you "A\\B," with the backslash escaped.
Stephan

Tim Kelley wrote:

I tried this and the results were:
\\servername\\share\\folder\\filename.txt.

Thanks,

"Carl Daniel [VC++ MVP]" <cp*****************************@mvps.org.nospam >
wrote in message news:O2*************@TK2MSFTNGP02.phx.gbl...

"Tim Kelley" <tk*****@company.comwrote in message
news:OI**************@TK2MSFTNGP04.phx.gbl...

>I am reading a text file with a streamreader. I parse out path and need
to use that path in a sql statement. The path is in the file as
\\servername\share\folder\filename.txt. When the line is read, it is in
the format of \\\\servername\\share\\folder\\filename.txt. When I try to
use this in my sql statement it fails because the field in the database in
in the previous format. I have tried using Replace, but I have not gotten
it to work. Any other suggestions?

String.Replace doesn't modify the string you call it on - it returns a new
string with the replacements made.

path = path.Replace(@"\\",@"\");

-cd