Regex help needed to match numbers

Question

I am an absolute noob at regex and need to help to match numbers in this format:

1,234,567

or

123,456

Including the commas! So I would like to match for example:

980,232  905,903  889,614  881,145  2,343,435  3,435,123

Extra note: I am using python re module

Clarification question: what are the minimum and maximum number of digits that you want to match? In general do you want to match any number composed of groups of 1-3 digits separated by commas with only the leading group having fewer than 3 digits? Or do you only care about numbers that are 1-9 digits long? — Engineero, Jul 09 '15 at 15:22

Andris Leduskrasts · Answer 1 · 2015-07-09T15:36:29.750

\d{1,3}(?:,\d{3})* to match correctly placed commas (4,43,424 won't match)

https://regex101.com/r/kQ6fC9/3

There can be 1-3 digits before the first comma, and then (,xyz) can repeat however times it wants, -,123,456, ,123,456,789 and also no times - just a number 13.

This works perfectly for whole (integer) numbers that may be divided by commas for readability. If you need to add also decimals to it, it means that the number after the last comma has no limitations. (?<=^|\s)\d{1,3}(?:,\d{3})*(?:,\d+)?(?=\s|$) should work for any number, including decimals, while avoiding faulty ones, https://regex101.com/r/kQ6fC9/4

score 1 · Answer 2 · answered Jul 09 '15 at 15:19

1

Well, conditions you've stated are little bit vague. If you want to match any combinations of digits separated by commas you can use following pattern (yes, it is kinda broad): [\d,]+

See demo

answered Jul 09 '15 at 15:19

Andrey Korneyev

26,353
15
70
71

This is how I read OP's request also. The question is extremely vague. – Jason L. Jul 09 '15 at 15:43

score 1 · Accepted Answer · answered Jul 09 '15 at 15:19

1

You can use following regex :

^(?:\d,)?\d{3},\d{3}$

See the demo https://regex101.com/r/yY3xR6/1

And read more about regex repetition http://www.regular-expressions.info/repeat.html

answered Jul 09 '15 at 15:19

Mazdak

105,000
18
159
188

Thank you so much, exactly what I needed – alexcons Jul 09 '15 at 15:22
1

This doesn't match, for example, `84,325`, `32` etc – Andris Leduskrasts Jul 09 '15 at 15:25
@AndrisLeduskrasts OP doesn't match such numbers! – Mazdak Jul 09 '15 at 15:29
@alexcons welcome, so if it works pls tell this to community by accepting the answer! – Mazdak Jul 09 '15 at 15:30
Quite sure he does, if there's `3,435,123` and `333,435,123`, why wouldn't there be `33,435,123` (which your solution doesn't match)?. He wrote the numbers only as an example. – Andris Leduskrasts Jul 09 '15 at 15:38

Regex help needed to match numbers

3 Answers3

Linked