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 - Invoice Da...  
🔵 UiPath +2 hour Beginners Tutorial -    • UiPath RPA Beginners Tutorial  

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