On 4/7/06, Barry Beattie <[EMAIL PROTECTED]> wrote:
> LSParseCurrency (yes, you don't have currency but it would work here too)
Bingo! This is what I was thinking there must be. A built in function
that does it by design.
Thanks Barry! (well, thanks everyone else too, but I think this is the
bes
LSParseCurrency (yes, you don't have currency but it would work here too)
gets rid of pound signs, euro, $, commas, etc and turns the number
into a decimal to four places.
..IIRC
HTH
barry.b
On 4/7/06, Adam Chapman <[EMAIL PROTECTED]> wrote:
>
> Hi Kay,
>
> I like a regular expression for
Hi Kay,
I like a regular expression for this sort of thing.. but it's just
personal preference as I am often turning $10,000 into 1. I will
also turn $10,000.00 into 1.00
reReplace(string,"[^0-9.]","","all")
This will remove anything that isn't a number or a "." (leaving decimal
points
Regards
Dale Fraser
> -Original Message-
> From: cfaussie@googlegroups.com [mailto:[EMAIL PROTECTED] On
> Behalf Of Kay Smoljak
> Sent: Friday, 7 April 2006 11:35 AM
> To: cfaussie@googlegroups.com
> Subject: [cfaussie] what's the 'proper way' to remove comma formatting
> from numbers
>
It would have to be replace(string, substring1, substring2, scope)
B)
Kay Smoljak wrote:
> Hey guys,
>
> I can think of all sorts of ways to actually do it, but what's the
> most correct/bulletproof way to turn 10,000 into 1?
>
> --
> Kay Smoljak
> http://kay.zombiecoder.com/
>
> >
>
