RegEx matcing numeric values with or without thousand separators

Question

I need a RegEx to match the following:

It should not match:

.123     (leading separator)
123..456 (two separators)

In other words, I need a RegEx to match long numeric values formatted with or without thousand separators.

Thanks!

Nope, it's not homework. I'm trying to ignore invalid user inputs from a TextBox in WPF. — Olav Haugen, Jun 06 '11 at 07:02

score 9 · Accepted Answer · answered Jun 06 '11 at 07:45

9

Here is a more restricted answer

^-?(?!0)(?:\d+|\d{1,3}(?:\.\d{3})+)$

See it online here at Regexr

(?!0) prevents from starting with 0

\d+ allows the numbers without separator

\d{1,3}(?:.\d{3})+ is the part for the separator. Start with 1 to 3 numbers, then a separator and 3 numbers. The dot for the separator followed by 3 numbers can be repeated.

answered Jun 06 '11 at 07:45

stema

80,307
18
92
121

Thanks! +1 for giving a more elaborate description. – Olav Haugen Jun 06 '11 at 08:55

score 2 · Answer 2 · answered Jun 06 '11 at 07:04

2

You could do something like

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

RegExr Demo

answered Jun 06 '11 at 07:04

kapa

72,859
20
152
173

Thanks! And a +1 for linking to demo with examples. – Olav Haugen Jun 06 '11 at 07:08
@Olav @bazmegakapa are you aware that this matches also `0.0.0`and `1.23.45` and `1.` ? – stema Jun 06 '11 at 07:50
@stema I am. For client-side validation, it suffices. Yours is nicer of course, but a bit overkill to me. – kapa Jun 06 '11 at 07:56
Went with @stema's answer as it covers more what I was looking for. – Olav Haugen Jun 06 '11 at 08:57

RegEx matcing numeric values with or without thousand separators

2 Answers2

Linked