Regex Python extract digits between two strings in a single expression

Question

I want only digits existing between two characters in order to get an integer dollar value, e.g. from string:

"Advance [Extra Value of $1,730,555] in packages 2,3, and 5."

we want to obtain "1730555".

We can use \$(.*)\] to get "1,730,555", but how do we remove the commas in the same expression, while retaining the possibility of arbitrary many commas, ideally getting the number in a single capturing group?

one option don't use regex to remove the commas, use replace(',','') — depperm
– depperm, Commented Nov 17, 2017 at 13:27
Just chain the .replace(',',''). A regex engine cannot perform a replacement while extracting at the same time. — Wiktor Stribiżew
– Wiktor Stribiżew, Commented Nov 17, 2017 at 13:28
Maybe you could shed some light on the reason you need this to be done in a single regex match operation - as this most likely is not possible. You can't match non-continuous content into a single group. — Sebastian Proske
– Sebastian Proske, Commented Nov 17, 2017 at 13:31

Kishore Devaraj · Accepted Answer · 2017-11-17 13:40:07Z

2

You can try like this

import re
text = "Advance [Extra Value of $1,730,555] in packages 2,3, and 5."
match = re.findall(r'\$(.*)]',text)[0].replace(',','')
print match

answered Nov 17, 2017 at 13:40

Kishore Devaraj

1569 bronze badges

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

Comments

mrCarnivore · Accepted Answer · 2017-11-17 13:31:02Z

2

You could use split and join:

import re

s = "Advance [Extra Value of $1,730,555] in packages 2,3, and 5."

match = re.findall(r'\$([\d,]+)', s)
number = ''.join(match[0].split(','))
print(number)

answered Nov 17, 2017 at 13:31

mrCarnivore

5,1282 gold badges14 silver badges29 bronze badges

2 Comments

Eric Duminil Over a year ago

You don't use the fact that the number needs to be inside [], right?

mrCarnivore Over a year ago

For this example my provided solution works. I am just using the fact that there is a $ in front of the number. If there are other numbers with leading $ that must not be returned but only the ones additionally encased in [] then just extend the regex to: '[.*\$([\d,]+)]'

Collectives™ on Stack Overflow

Regex Python extract digits between two strings in a single expression

2 Answers 2

Comments

2 Comments

Your Answer

Hot Network Questions

Collectives™ on Stack Overflow

2 Answers 2

Comments

2 Comments

Your Answer

Sign up or log in

Post as a guest

Related