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