How to extract specific data like invoice no, supplier code from multiple invoice pdf with same layout?

[sheldon_Chin]

Hello All,

Anyone can share their workflow with me on how to extract specific data from pdf to excel? Could someone can assist me? I need to extract invoice no, invoice date etc … from the pdf and put it into excel file. Thanks.

[vishal.kp (vishal)]

you can extract by applying the regex to the file after converting pdf to text.

[Jersey_Practical_Sho (Jersey Practical Shooter “X X Sonic Loss Xx”)]

Have a read here

Best Approach for Invoice Processing

I have a set of invoices that I want to extract data from. All having the same format. They are in pdf formats (made using images). Can someone please suggest me the most suitable way of automating this process? Tried using read pdf using OCR activity, but the result wasnt correct for all the pdfs. Using Relative Screen Scrapping didnt gave the correct result for all PDFs. Images were NOT same in all the PDFs. Pls guide.! I am using the Community version. Looking for a stable solution (NOT …

[Pankit]

Thanks @Jersey_Practical_Sho … I am NOT getting the desired text after using the OCR. Using regex and getting specific data would be the next step

[sheldon_Chin]

Hello Pankit , how to apply regex?

[sheldon_Chin]

hi vishal, how to apply regex?

[Jersey_Practical_Sho (Jersey Practical Shooter “X X Sonic Loss Xx”)]

best way is to learn it, I think personally it will be quite time consuming but possible in regards to extracting the information.

RegExr: Learn, Build, & Test RegEx

[sheldon_Chin]

hi @Jersey_Practical_Sho

Any simpler solution available other than using regex to extract data ?

[Jersey_Practical_Sho (Jersey Practical Shooter “X X Sonic Loss Xx”)]

If you used something like this Extract Semi Structured Document from the UiPathTeam.MLModel.Activities, you can out put to a file in the form of a list

Name…
Invoice Number…
Address…
Etc.