remove quotes 1

[Andy6666uk]

How can I remove quote marks from text coming from either the page or the database?

Thanks Andy

 

[Geee]

Use the replace command to strip characters from strings. The syntax is:
replace(string1,chartofind,chartoreplace)
where:
string1 is the string you wish to serach in
chartofind is the character you wish to find
chartoreplace is the character you wish to replace it with

So for you particular example you would use...

replace(mystring,""","&quot

Hope that helps...

G -GTM Solutions, Home of USITE-
-=

http://www.gtmsolutions.com=-

 

[Andy6666uk]

I'm afraid I,ve tried these already:

strBlah = Replace(strBlah, ", "ANDquot;&quot (AND=&)
strBlah = Replace(strBlah, """, "ANDquot;&quot

But I get an error, the " in either case is seen as an end or beginning.

I was hoping there might be something like ANDquot; I could use to tell asp there is a quote mark there.

Thanks again Andrew

 

[Geee]

have you tried using char codes? I think " is 22. Try
replace(string,char(22),"&quot

G -GTM Solutions, Home of USITE-
-=

http://www.gtmsolutions.com=-

 

[shaddow]

u should put chr(22) not char(22) for "
Replace(strBlah, chr(22),"&quot

 

[vasah20]

if you're going to use replace, you need to pass in the actual " mark. By doing """, you'll get an error. instead, it needs to be """". ("" evaluates to a single quotation mark)

ex:
strBlah = replace(strblah, """","&quot

that should work
good luck
leo