Replacing " in ASP

Devil's Angel · 03-25-2004, 11:50 AM

Hi guys!

I hope someone can help me with this....I have an online form with textareas. If someone enters double quotes " everything after doesn't enter into the database. If there are quotes around something like "something" that word does not enter into the database but everything else does (before and after).

Does anyone know how to replace this. I can replace the ' quote but I'm having a hard time replacing the double.

alpha3m · 03-25-2004, 03:57 PM

just use the asp function for instr

do a find, and replace. check and see if the " character is in the string, if it is, replace it with the '

Distorted · 03-25-2004, 09:35 PM

Or just use & quot; without the space.

You may also be able to use /" instead of "

I'm pretty sure that you can do that in PHP, but not sure with ASP.

**LazyJim** · 03-26-2004, 04:53 AM

\" = " in text output from scripts
" = " in HTML

Devil's Angel · 03-26-2004, 07:10 AM

Thanks guys!

I was on the right track just the wrong syntax. This code works:

Dim strCoverLetter
strCoverLetter = Trim(Request.Form("CoverLetter"))
strCoverLetter = Replace(strCoverLetter, CHR(34), "& quot;")
CoverLetter = strCoverLetter

I had to use CHR(34)