PDF extraction using Regex exp

Help Activities
, ,
1

Hi Community,

I have a pdf document image below.

Trying to extract fields
OMKUMAR TOLANI, DOC.NO, Policy / Cert. No. ,Being policy premium, VALUE ADDED TAX 5%, TOTAL

Please help me with this.

Thanks,
Praveena.

2

@praveena.nadi

Try sharing the text file so that it would be easy for writing Regex expressions.

Regards,

3

Hi @praveena.nadi
Can you Provide pdf if possible

Thanks

4

@Parvathy

Here is the text file for your reference, thanks.

5

Hello Praveena,

–Install PDF Activities

  1. Use Read PDF activity
  2. Use Regex to extract the info
6

Hi @praveena.nadi

Try using the below expressions

Omkumar Tolani ------------ (?<=\n)[A-Z]+\s*[A-Z]+(?=\s*[A-Z]+.[A-Z]+\s*: )

DOC.No ----------------- (?<=[A-Z]+.?[A-Z]+\s*:\s*)[A-Z]+\d+-?\d+(?=\s*[A-Z]+[a-z]+\s*: )

Policy/Cert No ----------------------- (?<=[A-Z]+[a-z]+.\s*:\s*)[A-Z]+-\d+-?\d+-?\d+-?\d+(?=\s*[A-Z]+\s*[A-Z]+)

Being Policy Premium ----------------------------- (?<=[A-Z]+-\s*)\d+,?\d+.?\d+(?=\s)

Tax -------------------------- (?<=TAX\s*)\d+%?(?=\s*\d+.?\d+)

Total ----------------------------- (?<=[A-Z]+\s*)\d+,\s*\d+.?\d+()

Hope all the works!!

Regards

1 Like
7

@vrdabberu

Thank you very much, I will try above and get back to you.

8

@praveena.nadi

If you find the correct solution for your query please, mark it as solution to close the loop

Regards

9

Hi,

except first one, nothing is working out.
please check once,
thanks

10

@Parvathy @pravallikapaluri

I have added pdf text file

can you try making regex expressions and share it with me

thanks

11

Hi @praveena.nadi

Please remove the ignore case in the properties panel for matches activity and give a try. I am able to extract all values.

image
image1452×702 37.2 KB

12

@praveena.nadi

Try the above regex expressions in either UiPath Studio or else RegExr website.

13

@praveena.nadi

Did it worked?

14

@vrdabberu

Yes all expressions are working well with UiPath studio.

thank you.

15

@praveena.nadi

Thank You

16

@vrdabberu

Hi, I have other 2 pdf files where I have to extract same fields but these regex expressions are not working with them.
I have attached pdf text files for other two as well, Please check

Thank you

17

@praveena.nadi

All the expreesions are working fine except 3 so I have given the new regex expression for those

Name ------------------------

(?<=[A-Z]+\s[A-Z]+[a-z]*\s?[A-Z]+[a-z]*\.?\s*[A-Z]+[a-z]*\-?\s+)\d+,?\d+.?\d+(?=\s)

Being Policy Premium -------------------------

(?<=TAX INVOICE\s+).*(?=\s+DOC)

DOC.No ---------------------------------------

(?<=[A-Z]+.?[A-Z]+\s*:\s*)[A-Z]+\d+-?\d+(?=\s+[A-Z]+[a-z]*\s*[A-Z]*[a-z]*\s*: )

Hope it works !!

18

@vrdabberu

Ill check and let you know
Thank you

19

@vrdabberu

You are awesome
its working for all the 3pdf files, will let you know If i get more files to be tested.
thank you very much for your help.

Regards,
praveena.

20

@praveena.nadi

Thank You

Happy Automation!!

1 Like