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]