Displaying page
of
pages;
Items to
|
Title |
Test
Details
sql decimal sql
|
|
Expression |
\d{0,7}([\.|\,]\d{0,2})?
|
|
Description |
Currently decimal(9,2)
Just replace 7 and 2 in the formula
|
|
Matches |
1234567,12 | 1234567.12 | 12345
|
|
Non-Matches |
123456789 | asd | asd.asd
|
|
Author |
Rating:
Not yet rated.
Vincent Pilote
|
|
Title |
Test
Details
tailling zero(0)
|
|
Expression |
\d+([\.|\,][0]+?[1-9]+)?
|
|
Description |
remove the tailling zero (0)
awfully cannot resolve the .00000 problem
|
|
Matches |
129.29 | 129.000000029 | 129.000000
|
|
Non-Matches |
123.90 | 123.789878979879870 | asd...
|
|
Author |
Rating:
Not yet rated.
Vincent Pilote
|
Displaying page
of
pages;
Items to
