I have the following group of numbers:

SalesCost% Margin
2,836,433.182,201,355.6422.39

Expected Result:

I want to separate this and extract the numbers such that I get the result as shown below:

2,836,433.18
2,201,355.64
22.39

Attempt

I tried the (\d )(?:\.(\d{1,2}))? regex but this only extracts the number until the first decimal, i.e. I only get 2,836,433.18.

Question

Is there a way I can extract the numbers using Regex (or alternatively someway through Python) to get the results shown above?

CodePudding user response：

You can use

re.findall(r'\d{1,3}(?:,\d{3})*(?:\.\d{1,2})?', text)
re.findall(r'(?:\d{1,3}(?:,\d{3})*|\d )(?:\.\d{1,2})?', text)

See the regex demo #1 and regex demo #2.

Details:

• \d{1,3} - one, two or three digits
• (?:,\d{3})* - zero or more occurrences of a comma and three digits
• (?:\.\d{1,2})? - an optional sequence of . and one or two digits.

The (?:\d{1,3}(?:,\d{3})*|\d )(?:\.\d{1,2})? variation supports numbers like 123456.12, i.e. no digit grouping symbol containing integer parts.