Extract number from string using regular expressions [multiple formatting options]

Question

I'm scratching my head trying to come up with a regex that extracts numbers from strings that are differently formatted. For example:

'1', '1.1', '1,1', '1,000,000.20', '1.00000020', '1.000.000,20', '10.20001'

I currently use the regex [-+]?[0-9]*[.,]?[0-9]+(?:[eE][-+]?[0-9]+)? and it works well in the majority of the cases except from 1,000,000.20 and 1.000.000,20.

Do you have any idea how can I tweak the previous regex to work with those examples?

In your case, you may just capture what is inside single quotes, '([^']+)'. — Wiktor Stribiżew
– Wiktor Stribiżew, Commented Jan 29, 2018 at 10:56
stackoverflow.com/questions/5917082/… might be useful. In particular you can use "Commas optional as long as they're consistent" twice (with ',' and '.' exchanged). — Micha Wiedenmann
– Micha Wiedenmann, Commented Jan 29, 2018 at 10:58
@joanfihu Note that if your texts are clean and numbers are not following each other (after a comma or dot), you might try something like \d[\d.,]*(?:[eE][-+]?\d+)?. Enclose with word boundaries if necessary. — Wiktor Stribiżew
– Wiktor Stribiżew, Commented Jan 29, 2018 at 11:14

kfairns · Accepted Answer · 2018-01-29 12:16:15Z

1

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

Perhaps something like this?

This will match all of the ones you stated, plus numbers written in the format 1e10 and 1e-9.

It will also not match numbers where there are inconsistencies in the comma dot format, i.e 10.234245,214,10.234,245.214 or 10,234.245,214

Also will allow for + or - at the beginning of these numbers

Check it out on Regex101

edited Jan 29, 2018 at 12:16

answered Jan 29, 2018 at 11:36

kfairns

3,0811 gold badge17 silver badges37 bronze badges

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

Collectives™ on Stack Overflow

Extract number from string using regular expressions [multiple formatting options]

1 Answer 1

Comments

Your Answer

Linked

Hot Network Questions

Collectives™ on Stack Overflow

1 Answer 1

Comments

Your Answer

Sign up or log in

Post as a guest

Linked

Related