In this tutorial video, we are using UiPath to read the data from a PDF invoice and store it in an excel sheet. After Extracting data from a PDF file into a text file, we are using Regular Expressions in order to find out the specific data.
To learn more about Regular Expression, We would recommend you to check the following URL:
In case you wanted to use the same PDF file follow the steps. You can download a PDF file from the following link:
If you wanted to know more about Robotic Process Automation and how it can help you to automated your business process, please visit our website:
#RPA #UiPath #regexp…(read more)
Convert Word 2 PDF: Word to PDF Converter
Convert PowerPoint 2 PDF: PPT to PDF Converter
Convert Excel 2 PDF: Excel to PDF Converter
Convert an Image 2 PDF: Image to PDF Converter
Convert HTML 2 PDF: HTML to PDF Converter
More Tools: PDF Converter
Thanks for detail, it's very useful,and now i have case to run this in multiple file PDF in on folder, what should i do? thanks.
What is should type in datarow
Hi, thanks for the clear explanation. Can u explain how to extract multiple words for a single field. For eg, the address here contains 3 words(seperated by 2 spaces) using w will bring up the first part alone.
I have a scenario where sometimes PDF Invoice do not carry any value for some fields, in that case i am getting an error message 'object reference not set to an instance'. I would like to have a solution from your end on how to mitigate this error either by getting output value as blank (In case of empty field) or output value (if value exist on the invoice).
Example: If Purchase Order number field is blank on the invoice, then output should be blank in Excel
Instead of required output I'm getting as (System.Linq.Enumerable+<CastIterator>d__97`1[System.Text.RegularExpressions.Match]).. How to rectify it?
how to extract multiple pdf and read the multiple text file into 1 excel .. kindly need your help thank you
How to go next row in excel.. If we have more than one invoice??