Regex number with digits calculation

Question

I would like a salary field that only takes numbers and also numbers with maximum 2 digits after the dot. Spaces and commas are not allowed.

My RegEx below is not working it allows spaces and commas and it allows more than 2 digits after the comma

("^[+-]?[0-9]{1,3}(?:[0-9]*(?:[.'][0-9]{2})?|(?:'[0-9]{3})*(?:\.[0-9]{2})?|(?:\.[0-9]{3})*(?:'[0-9]{2})?)$");

The following is what should be accepted

10000
10000.00

The following should not be accepted

Should be accepted `#` or `#.#` ? Why is that ? An input field should accept `#`, `#.#`, `#.`, `.#`. What is a user to think if he can't enter `10.` but can enter `10.0` ? He's gonna think the programmer is lame. — , Jun 25 '17 at 18:08

score 0 · Answer 1 · answered Jun 25 '17 at 17:10

0

This was already answered here: Regex currency validation Solution is for JavaScript, but a regex can be generally used in every language

answered Jun 25 '17 at 17:10

Schlumpf

Correct but wrong. OP said `10,000` should not be accepted. – Priyesh Kumar Jun 25 '17 at 17:13

score 0 · Answer 2 · answered Jun 25 '17 at 17:14

0

Try the following:

^\d+(?:\.\d{1,2}){0,1}$

Explanation:

\d+ - one or more digits

(?:\.\d{1,2}){0,1} - optional (happening once or not at all) dot followed by one or two digits

answered Jun 25 '17 at 17:14

score 0 · Answer 3 · answered Jun 25 '17 at 17:25

0

This should do the trick:

^\d+(?:\.\d{1,2})?$

answered Jun 25 '17 at 17:25

Pruthvi Raj

3 Answers3