Replace Function

[Steven Burn]

Replace(Data, Chr(34), Chr(34) & Chr(34))

--
Regards

Steven Burn
Ur I.T. Mate Group
www.it-mate.co.uk

Keeping it FREE!

Disclaimer:
I know I'm probably wrong, I just like taking part ;o)

 

[Ray at]

YourString = Replace(YourString, "'", """")
'or
theNewString = Replace(YourString, "'", """")

To "escape" a " character in a string, you put it twice, "".

Mind if I ask why you're replacing ' with " though?

Ray at work

 

[JT]

how can i replace all single quotes in a string to double quotes:

Replace(strLog_text, "'", """)

however, this doesn't work, as you might expect.

any ideas??

 

[Steven Burn]

Woops.. sorry, just realised you meant ' and not ", lol

Replace(data, Chr(39), Chr(34) & Chr(34))

--
Regards

Steven Burn
Ur I.T. Mate Group
www.it-mate.co.uk

Keeping it FREE!

Disclaimer:
I know I'm probably wrong, I just like taking part ;o)

 

[Aaron Bertrand - MVP]

how can i replace all single quotes in a string to double quotes:

Why would you want to do that? Does O'Brien want to change his name to
O"Brien?

strLog_text = Replace(strLog_text, "'", CHR(34))
or
strLog_text = Replace(strLog_text, "'", """")

 

[Steven Burn]

I've done it again........ there's only meant to be one Chr(34)...... not
two \

--
Regards

Steven Burn
Ur I.T. Mate Group
www.it-mate.co.uk

Keeping it FREE!

Disclaimer:
I know I'm probably wrong, I just like taking part ;o)

 

[jon]

Replace(strLog_text, "'", """")

**********************************************************************
Sent via Fuzzy Software @ http://www.fuzzysoftware.com/
Comprehensive, categorised, searchable collection of links to ASP & ASP.NET resources...