Scott Ill post it again cause I think it got lost in all the replies
<cfoutput>#REReplaceNoCase(string, "[^[:digit:]-\.]", "", "ALL")#</cfoutput> Steve -----Original Message----- From: [email protected] [mailto:[EMAIL PROTECTED] On Behalf Of Scott Thornton Sent: Wednesday, 9 July 2008 3:31 PM To: [email protected] Subject: [cfaussie] ReReplaceNoCase - return only a decimal number Hi, Thanks for your email. No I haven't tried that.. because it doesn't fix typos eg #LSParseCurrency('$a1234,56.50')# returns a Cf error. >>> "Zac Spitzer" <[EMAIL PROTECTED]> 09/07/2008 2:21 pm >>> did you try using LSParseCurrency ? On Wed, Jul 9, 2008 at 2:16 PM, Scott Thornton <[EMAIL PROTECTED]> wrote: > > Hi, > > I would like to create an expression to remove all text and special characters from a string, returning only a decimal-like looking number.. > > eg > > $12,345.00 -> 12345.00 > $+10.65 -> 10.65 > $-5.65 = -5.65 > > etc > > I suck at regular expressions.... > > Cheers, > > > > Scott Thornton, Programmer > Billing Unit > Hunter-New England Area Health Service > ext: 51762 p: +61 02 491 51762 m: 0413 800 242 > > > > > > -- Zac Spitzer - http://zacster.blogspot.com (My Blog) +61 405 847 168 --~--~---------~--~----~------------~-------~--~----~ You received this message because you are subscribed to the Google Groups "cfaussie" group. To post to this group, send email to [email protected] To unsubscribe from this group, send email to [EMAIL PROTECTED] For more options, visit this group at http://groups.google.com/group/cfaussie?hl=en -~----------~----~----~----~------~----~------~--~---
