Want to protect your cyber security and still get fast solutions? Ask a secure question today.Go Premium

x
  • Status: Solved
  • Priority: Medium
  • Security: Public
  • Views: 102
  • Last Modified:

What is a valid regex expression for currency?

Hi:

I'm trying to quickly figure out a regex for the following numeric value.

Essentially so it look like a valid currency
  - without commas (,)
  - or dollar signs ($)
  - greater than 0.00

We have uncovered something like this, but it doesn't seem to work:
([1-9]{1}[0-9]{0,2}(\,[0-9]{3})*(\.[0-9]{0,2})?|[1-9]{1}[0-9]{0,}(\.[0-9]{0,2})?|0(\.[0-9]{0,2})?|(\.[0-9]{1,2})?)

Open in new window


Thanks,
JohnB
0
jxbma
Asked:
jxbma
  • 2
  • 2
1 Solution
 
QlemoC++ DeveloperCommented:
If we can assume to always have two decimal digits (and hence a decimal point): '^[1-9]\d*\.\d\d|^0.([1-9][0-9]|0[1-9])'
0
 
jxbmaSoftware ConsultantAuthor Commented:
I would like the two (2) decimal digits to be optional.

Thanks,
JB
0
 
QlemoC++ DeveloperCommented:
This will allow no decimal digits and exact two (I don't think 190.1 makes sense):
'^[1-9]\d*(\.\d\d)?|^0.([1-9][0-9]|0[1-9])'
0
 
jxbmaSoftware ConsultantAuthor Commented:
Terrific!

I just extended it to be:    ^[1-9]\d*\.\d\d|^0.([1-9][0-9]|0[1-9])|^[1-9]\d*

Thanks,
JB
0

Featured Post

Hire Technology Freelancers with Gigs

Work with freelancers specializing in everything from database administration to programming, who have proven themselves as experts in their field. Hire the best, collaborate easily, pay securely, and get projects done right.

  • 2
  • 2
Tackle projects and never again get stuck behind a technical roadblock.
Join Now