From: Josselin <josselin@...>
Date: 2006-10-12T00:00:12+09:00
Subject: Re: help with regex

On 2006-10-11 15:37:03 +0200, "Tim Becker" <a2800276@gmail.com> said:

>> I would like also to accept the european way (comma before decimal part)
>>  "99.999,99" or "99999,99'  should also be substitued to "99999.99'
> 
> "European" would be difficult without having context. How can you tell if
> 999.999 is one short of a million or one thousanth short of a thousand?
> 
> Apart from that, do you want to verify that the seperator is correctly placed:
> 
> 66'000.95 is ok, but what about 650'00.95 or ,0001.95 ?
> 
>    -tim
> 
> 
>> 
>> 
>> so any  input should be susbstitued to   "99999.99' takng in account
>> the decimal part if any
>> 
>> joss

thanks for raising these cases,
all system amounts are purely informative ..  (normal case is below 9999.99)
and my concern is being flexible w validation

in this 3 cases the only thing the system cares is the decimal part :
> 66'000.95  will be normalized to 66000.95
> 650'00.95  will be normalized to 65000.95
> ,0001.95  will ne normalized to 0001.95 =>  1.95
being accepted by the system, the use will see on display that they are 
not as they should be
and the user will correct them later on....