Replace " (double quotes)

[timtom]

I started a new thread because my problem had changed slightly

I need to Replace or Remove all the " (double quotes) in a string. If I do

mystring = Replace(mystring,""", "&quot

then I get an undetermined string constant error.
Does anyone know of another way? I can't find anything in my books.

Thanks again
Sarah

p.s. To clarify, the string is a long string comprising lots of HTML - I can live without any of the double quotes contained therein.

_{WASN'T FIT ENOUGH FOR THE POLICE FORCE}​

 

[durug]

mystring = Replace(mystring,"""", "&quot

Hope it will work!
Durug

 

[timtom]

Yes it does! Thanks Durug, much appreciated.

_{WASN'T FIT ENOUGH FOR THE POLICE FORCE}​

 

[BBirkett]

Hey timtom...

If you find you are working with lots and lots of double quotes, the """" way can get quite messy.

An alternative is to use:
mystring = Replace(mystring, Chr(34), "&quot

But like I said, its only really a benefit for cases involving lots and lots of double quotes! Brett Birkett B.Comp
Systems Analyst