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