Regular Expression for Whole Number (Thousands comma, No decimal)

Question

I need to validate an input filter on a form because I cannot format the output due to the template I am using. This is a price field and I need the output to be uniform. I am able to use a regular expression to validate the input.

I would like regex to be a whole number with thousands separated with a comma. No decimal. No $.

Valid:

* 0 (just zero) 
* 100
* 1,000 
* 10,000

Not Valid:

01 (leading zero)
100.50
1000
$10,000
-10,000 (no negative number)

Does anyone know how to do this? I cannot find this and thought it should be a common regex.

what have you tried? Can you share with us your failed regex patterns? — Forty3, Apr 04 '17 at 15:30
Start [here](http://stackoverflow.com/questions/22937618/reference-what-does-this-regex-mean) and come back to us once you have a decent attempt to show. — Jean-François Corbett, Apr 04 '17 at 15:30

score 0 · Answer 1 · answered Apr 04 '17 at 15:53

0

You could use this regex: ^(0|[1-9][0-9]{0,2})(,[0-9]{3})*$

Below is a python implementation:

import re
regex = r"^(0|[1-9][0-9]{0,2})(,[0-9]{3})*$"
num = "10,000"
if re.search(regex, num):
  print(True)
else:
  print(False)

answered Apr 04 '17 at 15:53

shadan

28
3

Ahmed Bakhsh Memon · Accepted Answer · 2017-04-04T16:31:16.193

0

I believe you need something similar to,

Using javascript

^(0|[1-9][0-9]{0,2})(,[0-9]{3})*$

edited Apr 04 '17 at 16:31

answered Apr 04 '17 at 15:54

Ahmed Bakhsh Memon

97
5

Regular Expression for Whole Number (Thousands comma, No decimal)

2 Answers2