| Title |
Test
Find
Currency - Money
|
| Expression |
^(-?\$?([1-9]\d{0,2}(,\d{3})*|[1-9]\d*|0|)(.\d{1,2})?|\(\$?([1-9]\d{0,2}(,\d{3})*|[1-9]\d*|0|)(.\d{1,2})?\))$ |
| Description |
Handles any kind of money entry. With $ sign or not, with commas or not. With bracket, negative sign or none. Max of 2 decimal points. It's perfect :) |
| Matches |
112.12 $1,112.15 (15555.5) $.12 0.1 |
| Non-Matches |
$111,1.15 52.121 (123.12 s123 |
| Author |
Rating:
Salam Abbas
|
| Source |
|
| Your Rating |
|
Title: Whoops
Name: Michael Jordan
Date: 5/26/2020 4:50:49 AM
Comment:
(12 parses as a valid value. I don't believe that's a valid entry.