Displaying page
of
pages;
Items to
Title |
Test
Details
Pattern Title
|
Expression |
^(\$|)([1-9]+\d{0,2}(\,\d{3})*|([1-9]+\d*))(\.\d{2})?$
|
Description |
By combining the contributions from Bri Gipson and Michael Ash in this site. I have come up with this RE to exclude the zero dollar amounts such as $0.00, 0.00, 0, etc.
|
Matches |
$1,234,567.00 | $1234567.00 | 1234567.00
|
Non-Matches |
$1,2345,67.00 | $0 | $0.00
|
Author |
Rating:
Joe Lynwood
|
Title |
Test
Details
Pattern Title
|
Expression |
^(\$|)([1-9]\d{0,2}(\,\d{3})*|([1-9]\d*))(\.\d{2})?$
|
Description |
Combine Michael Ash's US Dollar amount and Bri Gipson's eliminating zero input to create this RE to accept Optional leading dollar sign, optional well-formed comma separator dollar amount with no zero amount allowed.
*** Correction: Remove the "+" otherwise it will incorrectly matches 4 leading digits like 1234,345,678.00 03-03-2005
|
Matches |
$1,234,567.89 | 1234567.89 | $9.99
|
Non-Matches |
$1,2345,67.89 | $1234,345,678.0 | 0
|
Author |
Rating:
Joe Lynwood
|
Displaying page
of
pages;
Items to