How to extract data from PDF's with RegEx in UiPath - Full Tutorial

This video tutorial will show, how to extract data from one or more PDF's using RegEx with UiPath. It shows how to get the data, we want, out of a single invoice PDF and afterwards how to get data out of all invoices in a folder.

You could also watch:
🔵 UiPath Document Understanding (Invoice) -    • UiPath Document Understanding - Invoi...  
🔵 UiPath +2 hour Beginners Tutorial -    • UiPath RPA Beginners Tutorial [2020]  

0:17 Inspecting our data
We have pdf invoices in a folder, which we want to extract data from automatically with UiPath.

1:24 Install PDF package
In the Manage Packages we find the PDF activites and install it.

2:22 Read PDF Text
Read the PDF into a string we can work with in Uipath. Copy the extracted text from the PDF, so we can work with it in an online RegEx editor.

3:28 RegExr - Online RegEx editor
Use an online RegEx editor to easily test your RegEx pattern and check, what data is to be extracted.

5:17 How to use the Matches activity in UiPath
Specify input, pattern and output. The output is an IEnumerable, which you can see as a list, where the data from the invoice will be stored.

6:47 Creating Data Tables
We create one Data Table with our RegEx patterns and one for the outputs.

11:29 Writing our extraced data to a Data Table
Using simple VB.NET code and Add Data Row we can assign our extraced values to a Data Table and afterwards easily to Excel. Do you want to learn VB.NET (the language used in UiPath), check this book: https://geni.us/v6ffI, which will learn you all the code you need for UiPath. Do note that I get affiliate, when you click, but I will recommend it anyway.

13:42 Write Range
Use a Write Range to write the Data Table to Excel.

15:21 Loop through our invoices in the folder
Use a For Each to loop through our invoice files in the folder.

Connect with me:
🔔 Subscribe - http://www.youtube.com/user/klogeande...
💼 LinkedIn -   / andersjensens  
👥 Facebook -   / andersjensenorg  
💌 Email Newsletter - https://andersjensen.org/email-newsle...

#uipath #rpa #automation