Regex to extract particular information from Pdf

Help Studio
, ,
1

Hi All,

Any help on the below

I want to extract particular text between two sections of pdf using Regex. What will be the regex expression?

I want to extract between "Performance and Milestone section and before “Payment” section.

I want to extract the Tabular data between “Performance and Milestone” section and “Payment section”

The image is a document detailing a performance and milestone schedule for services, specifying tasks, amounts, hours, and due dates, with a total cost of USD 200,000 to be completed by January 26, 2024. (Captioned by AI)
The image is a document detailing a performance and milestone schedule for services, specifying tasks, amounts, hours, and due dates, with a total cost of USD 200,000 to be completed by January 26, 2024. (Captioned by AI)605×788 106 KB

2

Hi @dutta.marina

Try this way,

But it will give only string output value.

(?<=Performance and Milestone section)(?s).*(?=Section 4 Payment)

image

Regards,
Gowtham K

3

@Gowtham_K115

Its not working

4

@dutta.marina in case if you want to extract the tabular data I would strongly recommend you to use any other method or services in UiPath like DU or some other integration services as Regex for this kind of scenario are not commendable or not reliable.

5

@dutta.marina Slightly modified format from @Gowtham_K115:

(?<=SECTION\s+3\s+Performance\s+and\s+milestone\s+Schedule).*(?=SECTION\s+4\s+Payment)

image
image1161×477 29.2 KB

When you extract text from PDF enable formatted text option. After the first regex, you’ll have to do a lot more work to create something useful. Regex approach may not be the best here

6

@sppal.c

Trying with DU but form extractor is unable to extract the table. any help on this?