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. Join my community, 7-day free trial: https://iloveautomation.ai/community 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. Which will learn you all the code you need for UiPath. 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... #uipath #rpa #automation