Cheers Paul and Duncan!

I ended up with this that does the job loverly:
<cfset Email=REReplace(Email, "[""''*&^%$/\\|\]\[{}?()]", '', 'ALL')>

-----Original Message-----
From: Paul Johnston [mailto:[EMAIL PROTECTED]]
Sent: 20 February 2003 19:12
To: [EMAIL PROTECTED]
Subject: RE: [ cf-dev ] regex help


In any string in CF if you want to put in a single or double quote
character, you have to escape it like this:

<cfset myquote = "''">
<cfset mydoubleQuote = """">

Ie put two quotes in (like SQL escaping single quotes) where you need the
one.

Paul

> heres the code:
> 
> <cfset nDescription=REReplace(nDescription, 
> "[*\/[]{}&^%$&"']", '', 'ALL')>
> 
> I think the ' in theh replacement strig is causing the crash. 
> How do I esacape it?
> 
> Cheers,
> Douglas McKenzie
> 
> ----------------------------------------
> Internet Developer / Designer
> [EMAIL PROTECTED]
> 020 7267 6718
> ----------------------------------------
> 
> 
> -- 
> ** Archive: http://www.mail-archive.com/dev%40lists.cfdeveloper.co.uk/
> 
> To unsubscribe, e-mail: [EMAIL PROTECTED]
> For additional commands, e-mail: 
> [EMAIL PROTECTED] For human help, e-mail: 
> [EMAIL PROTECTED]
> 



-- 
** Archive: http://www.mail-archive.com/dev%40lists.cfdeveloper.co.uk/

To unsubscribe, e-mail: [EMAIL PROTECTED]
For additional commands, e-mail: [EMAIL PROTECTED]
For human help, e-mail: [EMAIL PROTECTED]



-- 
** Archive: http://www.mail-archive.com/dev%40lists.cfdeveloper.co.uk/

To unsubscribe, e-mail: [EMAIL PROTECTED]
For additional commands, e-mail: [EMAIL PROTECTED]
For human help, e-mail: [EMAIL PROTECTED]

Reply via email to