Replace double quotes

[spud101]

I'm trying to replace all the double quotes in a string with 2 double quotes.
Ex.

this is a "string" with quotes

I want to change it to this:

this is a ""string"" with quotes

The replace function gives me an error when i use it like this:

replace(thestring,""","""&quot

i also tried:
replace( thestring,chr(34),"""&quot- no error but the output is the same with only 1 set of double quotes.

Any ideas?
Thanks

 

[tsuji]

Hello spud101,

You've got it already. Just use chr(34) more thoroughly.

    replace(thestring,chr(34),chr(34)&chr(34))

regards - tsuji

 

[spud101]

Great,

thanks for the help.

Tim