Regex expression to extract data

Help Studio
1

Hi All, I am using regex extractor to extract data from pdf, I am extracting data of field “Amount”, it is working fine but it is extracting the value twice as the field Amount” exists twice in pdf. Could you please suggest what we can do to not extract it twice?
Thanks!

2

Hi @Shivi

Modify the regular expression used in the Regex Based Extractor. If the current regular expression extracts both values, adjust it to extract only one of the amounts. Then it will extract only one amount

Hope it helps!!

3

I have set it to extract only once, however it’s still extracting the value twice.

4

Can you share the input data, then I’ll try to write the Regular expression… @Shivi

5

This is the input file-

IMG_3646
IMG_36462169×2313 1.75 MB

6

Okay @Shivi

Can you try giving the below regular expression in Regex based extractor,

(?<=Invoice Number\s*Amount Due \(INR\)\s*Rs.)[\d\.\,]+

The image shows a regular expression being used to extract monetary amounts from text labeled 'Invoice Number' and 'Amount Due (INR)', highlighting the matched amount 'Rs.00,000.000'. (Captioned by AI)
The image shows a regular expression being used to extract monetary amounts from text labeled 'Invoice Number' and 'Amount Due (INR)', highlighting the matched amount 'Rs.00,000.000'. (Captioned by AI)892×448 24.2 KB

Hope it helps!!

7

I tried it, but It’s not working.

8

Can you try the below one… @Shivi

(?<=Invoice Number\s*Amount Due \(INR\)\s*.*\s*Rs.)[\d\.\,]+
9

Hi @Shivi,
First, extract the text between two “Amount Due (INR):”, then use string manipulation or regex to get the needed text.

Regex: “(?<=Amount Due (INR):)([\S\s]*)(?=Amount Due (INR):)”

The image shows a regular expression being tested to match and highlight currency amounts formatted as "Rs. 00,000.000" in the context of invoice details, specifically focusing on the "Amount Due (INR)" field. (Captioned by AI)
The image shows a regular expression being tested to match and highlight currency amounts formatted as "Rs. 00,000.000" in the context of invoice details, specifically focusing on the "Amount Due (INR)" field. (Captioned by AI)856×238 13.8 KB

10

Hi @Shivi ,

Could you show us the output representation of the value getting extracted twice ?