Getting different formats of numbers from string using regex

Question

I need to get these number formats from a string

Strings can be

some text 20000
20000 some text

So far I have this

/((\d){1,}[ .,]{1}[0-9]{1,}[ .,]{1}[0-9]{1,})/g

Thank you.

In 2000,000 (not 2,000,000) does the comma translate as a period in English? — Cary Swoveland
– Cary Swoveland, Commented Apr 2, 2020 at 5:55

Tim Biegeleisen · Accepted Answer · 2020-04-02 06:15:49Z

3

I would use this regex:

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

Demo

Here is an explanation of the regex:

^                from the start of the string
[1-9][0-9]{0,2}  match 1 to 3 leading digits (first digit not zero)
(?:[ ,]?\d{3})*  then match an optional thousands separator followed by 3 digits,
                 the entire quantity zero or more times
(?:[,.]\d+)?     match an optional decimal component, using either , or . as the separator
$                end of the string

edited Apr 2, 2020 at 6:15

answered Apr 2, 2020 at 5:56

Tim Biegeleisen

526k32 gold badges324 silver badges399 bronze badges

Sign up to request clarification or add additional context in comments.

3 Comments

Mirau Over a year ago

@ Tim Biegeleisen How can I use it on string like this 20 000 some text. Looks like it matches only numbers. Thank you.

Tim Biegeleisen Over a year ago

Replace the ^ and $ anchors with word boundaries, i.e. use \b[1-9][0-9]{0,2}(?:[ ,]?\d{3})*(?:[,.]\d+)?\b

Mirau Over a year ago

@ Tim Biegeleisen Thank you very much.

Collectives™ on Stack Overflow

Getting different formats of numbers from string using regex

1 Answer 1

Demo

3 Comments

Your Answer

Hot Network Questions

Collectives™ on Stack Overflow

1 Answer 1

3 Comments

Your Answer

Sign up or log in

Post as a guest

Related