How to extract data from PDF's with RegEx in UiPath - Full Tutorial
Автор: Anders Jensen
Загружено: 2020-04-08
Просмотров: 52563
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
Доступные форматы для скачивания:
Скачать видео mp4
-
Информация по загрузке:
