This awesome as I was experiencing the same problem and found that Steve's regular expression worked out nicely. Thanks!
-----Original Message----- From: [email protected] [mailto:[EMAIL PROTECTED] On Behalf Of Scott Thornton Sent: Thursday, 10 July 2008 9:37 AM To: [email protected] Subject: [cfaussie] ReReplaceNoCase - return only a decimal number Hi, Thanks, that does the trick. Odd, this solution arrived at 4:43AM this morning, well out of synch with the other replies. Thanks all, >>> "Steve Onnis" <[EMAIL PROTECTED]> 09/07/2008 2:28 pm >>> This should do the trick REReplaceNoCase(string, "[^[:digit:]-\.]", "", "ALL") -----Original Message----- From: [email protected] [mailto:[EMAIL PROTECTED] On Behalf Of Scott Thornton Sent: Wednesday, 9 July 2008 2:17 PM To: [email protected] Subject: [cfaussie] ReReplaceNoCase - return only a decimal number 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 --~--~---------~--~----~------------~-------~--~----~ 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 -~----------~----~----~----~------~----~------~--~---
