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 -~----------~----~----~----~------~----~------~--~---
