From: Josselin <josselin@...>
Date: 2006-10-11T22:00:07+09:00
Subject: help with regex

regex is not my cup of tea , i've been using them few times, only 
matching, no substitution..

I need to check a string before saving it into a decimal (5,2) column 
in DB and I actually don't know how to start substitution :

the user is free to enter a value in any format, I must check if there 
is any decimal (if any , then 2 digits are mandatory.. it's none or 2 !)

the user can enter any string like  "99'999.99"  or "99,999.99" or 
"99999.99" or "99999"
should be substitued to  "99999.99'

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'


so any  input should be susbstitued to   "99999.99' takng in account 
the decimal part if any

joss