How to find specific text with it's correspondence value from a text input using Regex and Python?

user_2651916 0
Viewed 37

I have some text input and I want to extract few information from the text. For that, I am trying to use Regular Expression and am able to do that except for two fields- rent and transfer.

The input text is as below-

my_str = "19 Aug standing order rent Apolo Housing Assoc. 500.00 50.00
20 Aug transfer from John wick saving a/c 200.00 130.90"

Now I want to extract rent like- rent 500.00 and transfer as transfer 200.00 but somehow only 'rent' and 'transfer' keywords are extracting only.

Below is my code in Python for the same-

import re
find_rent = re.search(r"(rent)+([0-9,.]*)", my_str)
found = find_rent.group()
print(found)

With the above code, only 'rent' is extracted not 'rent 500.00'. Similar code I am using for transfer also.

Please guide me on what I am doing wrong here.

python regex
1 Answers

You can use

\b(transfer|rent)\D+(\d+(?:[,.]\d+)*)

See the regex demo. Details:

  • \b - a word boundary
  • (transfer|rent) - Group 1: a transfer or rent word
  • \D+ - one or more non-digits
  • (\d+(?:[,.]\d+)*) - Group 2: one or more digits, and then zero or more occurrences of a comma/period and one or more digits

See the Python demo:

import re
s = '19 Aug standing order rent Apolo Housing Assoc. 500.00 50.00\n20 Aug transfer from John wick saving a/c 200.00 130.90'
rx = r'\b(transfer|rent)\D+(\d+(?:[,.]\d+)*)'
for m in re.finditer(rx, s):
    print(f'{m.group(1)} {m.group(2)}')

Output:

rent 500.00
transfer 200.00

For a single term search, you can use

import re
s = '19 Aug standing order rent Apolo Housing Assoc. 500.00 50.00\n20 Aug transfer from John wick saving a/c 200.00 130.90'
w = 'rent'
rx = fr'\b{w}\D+(\d+(?:[,.]\d+)*)'
m = re.search(rx, s)
if m:
    print(f'{w} {m.group(1)}')

See this Python demo.

user_38329700
Related