Regex for number with decimals and thousand separator

Question

I need regex to validate a number that could contain thousand separators or decimals using javascript. Max value being 9,999,999.99 Min value 0.01 Other valid values: 11,111 11.1 1,111.11

INVALID values: 1111 1111,11 ,111 111,

I've searched all over with no joy.

Loamhoof · Accepted Answer · 2013-04-22T15:16:56.997

35

/^\d{1,3}(,\d{3})*(\.\d+)?$/

About the minimum and maximum values... Well, I wouldn't do it with a regex, but you can add lookaheads at the beginning:

/^(?!0+\.00)(?=.{1,9}(\.|$))\d{1,3}(,\d{3})*(\.\d+)?$/

Note: this allows 0,999.00, so you may want to change it to:

/^(?!0+\.00)(?=.{1,9}(\.|$))(?!0(?!\.))\d{1,3}(,\d{3})*(\.\d+)?$/

which would not allow a leading 0.

Edit:
Tests: http://jsfiddle.net/pKsYq/2/

edited Apr 22 '13 at 15:16

answered Apr 22 '13 at 13:24

Loamhoof

8,293
27
30

Thanks for the quick reply Loamhoof No joy though. I'm calling it like this and it fails: var re = new RegExp("/(?!0+\.00)(?!.{10,}\.)(?!0,?\d)\d{1,3}(,\d{3})*\.\d+/"); if (!min.match(re)) { alert('No match'); } – Swifty Apr 22 '13 at 13:26
@Swifty could you give me an example of what fails? – Loamhoof Apr 22 '13 at 13:44
I'm using this page to test it: [Regular Expression Tester](http://www.regular-expressions.info/javascriptexample.html) If I enter '1' it fails. – Swifty Apr 22 '13 at 13:56
@Swifty my bad, I thought the decimals were required. I'm changing it. – Loamhoof Apr 22 '13 at 13:58
which one did you change? the bottom one in your main post stil fails, '1' should also match – Swifty Apr 22 '13 at 14:48
It does for me. I'll add an example. – Loamhoof Apr 22 '13 at 14:50
Do you use the same test page as I do? – Swifty Apr 22 '13 at 14:55
http://jsfiddle.net/pKsYq/ though it seems there's a problem with `0` values. Fixing that. – Loamhoof Apr 22 '13 at 14:56
Where do I see the output? – Swifty Apr 22 '13 at 15:00
Sorry, I thought it would log to the results window. Didn't think of checking the dev console. Thanks – Swifty Apr 22 '13 at 15:02
Seems to very close to what I need, yet these ones are failing that should pass: '9,999,999.99', '0,01' – Swifty Apr 22 '13 at 15:07
`0,01` should not, `0.01` works. I've found the origin of the problem for `9,999,999.99`, working on it. – Loamhoof Apr 22 '13 at 15:13
@Swifty that should do it. – Loamhoof Apr 22 '13 at 15:17
Typo, my bad. I found another one that doesn't work that should: '777,777.00' – Swifty Apr 22 '13 at 15:17
@Swifty same problem as before, check the last version. – Loamhoof Apr 22 '13 at 15:18
1

@RyanDaulton the question specified a max value of `9,999,999.99`, which is lower than `10,029,589.84`. – Loamhoof Sep 20 '19 at 13:31
@Loamhoof The expression fails for value 99,999,999. Please fix it – Syed Irfan Ahmad Jan 28 '23 at 16:18

munch1324 · Answer 2 · 2013-04-22T13:40:31.550

4

((\d){1,3})+([,][\d]{3})*([.](\d)*)?

It worked on a few, but I'm still learning regex as well.

The logic should be 1-3 digits 0-1 times, 1 comma followed by 3 digits any number of times, and a single . followed by any number of digits 0-1 times

edited Apr 22 '13 at 13:40

answered Apr 22 '13 at 13:31

munch1324

1,148
5
10

No joy there either Munch. – Swifty Apr 22 '13 at 13:37
can you give the fail cases? – munch1324 Apr 22 '13 at 13:37
edited, should have been a + instead of ? for first subexpression. – munch1324 Apr 22 '13 at 13:41
somehow that returns everything as valid? – Swifty Apr 22 '13 at 13:41
@Swifty * and ? equate to optional, and \d{1,3}+ equates to at least 1 digit. Without surrounding this in ^ and $, it is equivalent to "contains at least 1 digit" – Tezra Nov 09 '18 at 15:25

score 3 · Answer 3 · answered Nov 09 '18 at 15:19

First, I want to point out that if you own the form the data is coming from, the best way to restrict the input is to use the proper form elements (aka, number field)

<input type="number" name="size" min="0.01" max="9,999,999.99" step="0.01">

Whether "," can be entered will be based on the browser, but the browser will always give you the value as an actual number. (Remember that all form data must be validated/sanitized server side as well. Never trust the client)

Second, I'd like to expand on the other answers to a more robust (platform independent)/modifiable regex.

You should surround the regex with ^ and $ to make sure you are matching against the whole number, not just a subset of it. ex ^<my_regex>$
The right side of the decimal is optional, so we can put it in an optional group (<regex>)?
Matching a literal period and than any chain of numbers is simply \.\d+
- If you want to insist the last number after the decimal isn't a 0, you can use [1-9] for "a non-zero number" so \.\d+[1-9]
For the left side of the decimal, the leading number will be non-zero, or the number is zero. So ([1-9]<rest-of-number-regex>|0)
The first group of numbers will be 1-3 digits so [1-9]\d{0,2}
After that, we have to add digits in 3s so (,\d{3})*
- Remember ? means optional, so to make the , optional is just (,?\d{3})*

Putting it all together

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

This is still very relevant in 2022. It helped fixing my problem with thousand separator. Thanks. — priyamtheone, Mar 19 '22 at 10:31

score 2 · Answer 4 · answered Nov 09 '18 at 14:04

In a recent project we needed to alter this version in order to meet international requirements. This is what we used: ^-?(\d{1,3}(?<tt>\.|\,| ))((\d{3}\k<tt>)*(\d{3}(?!\k<tt>)[\.|\,]))?\d*$

Creating a named group (?<tt>\.|\,| ) allowed us to use the negative look ahead (?!\k<tt>)[\.|\,]) later to ensure the thousands separator and the decimal point are in fact different.

score 2 · Answer 5 · answered Dec 07 '18 at 16:46

2

Tezra's formula fails for '1.' or '1.0'. For my purposes, I allow leading and trailing zeros, as well as a leading + or - sign, like so:

^[-+]?((\d{1,3}(,\d{3})*)|(\d*))(\.|\.\d*)?$

answered Dec 07 '18 at 16:46

r4r4

75
5

score 0 · Answer 6 · answered May 24 '17 at 06:05

0

I have used below regrex for following retrictions -

^(?!0|\.00)[0-9]+(,\d{3})*(.[0-9]{0,2})$

Not allow 0 and .00.
','(thousand seperator) after 3 digits.
'.' (decimal upto 2 decimal places).

answered May 24 '17 at 06:05

Sanchi Girotra

1,232
13
13

Regex for number with decimals and thousand separator

6 Answers6

Linked

Related