<cf_bighappysmile>
Thanks for the tip, you've just helped me speed the processing time of the
query up by about 40%!!!!
</cf_bighappysmile>
;o)
-= Ed
> -----Original Message-----
> From: Dick Applebaum [mailto:[EMAIL PROTECTED]]
> Sent: 5 January 2001 12:48 PM
> To: CF-Talk
> Subject: Re: OT: Regular Expression Gurus Please Help!
>
>
> Ed
>
> By changing the problem specification, slightly, to:
>
> "Remove all all non (numeric or space) characters"
>
> you get the simplified (faster and easier to understand) regexp:
>
> <cfoutput>
> #REReplace("+44 (0) 7799 657093", "[^0-9 ]", "", "ALL")#
> </cfoutput>
>
> The "[^0-9 ]" term means
>
> [.....] the class of characters within the bracket
>
> [^.....] the Negated class of characters within the bracket
>
> [^0-9] the Negated class of characters in the range 0-9 (numeric)
>
> [^0-9 ] the Negated class of characters in the range 0-9
> (numeric) or space
>
> thus: any character that is not digit or a space
>
> HTH
>
> Dich
>
>
> At 10:47 AM +0000 1/5/01, Edward Chanter wrote:
> >I'm really bad at these so maybe one of you has some ideas, basically I'm
> >trying to create a reg ex to run against a list of cell phone numbers. I
> >need to strip out + signs as well as brackets () and spaces " " the
> >expression I'm using is:
> >
> ><cfoutput>
> >#REReplace("+44 (0) 7799 657093","+| |(|)","","ALL")#
> ></cfoutput>
> >
> >It only takes out the spaces when I run it :-(
> >
> >I bet the answer is really simple but I just can't figure it out...
> >
> >Thanks in advance,
> >
> > - =Ed
>
>
~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~
Structure your ColdFusion code with Fusebox. Get the official book at
http://www.fusionauthority.com/bkinfo.cfm
Archives: http://www.mail-archive.com/cf-talk@houseoffusion.com/
Unsubscribe: http://www.houseoffusion.com/index.cfm?sidebar=lists