Playback starts YouTube’s embedded player (privacy-enhanced mode).
How to extract data from PDF's with RegEx in UiPath - Full Tutorial
ChannelAnders JensenDescription from the creator
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: iloveautomation.ai/community
You could also watch:
🔵 UiPath Document Understanding (Invoice) - youtu.be/cp1hbChzUQ4
🔵 UiPath +2 hour Beginners Tutorial - youtu.be/3ZKzTHdpsTs
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.
#uipath #rpa #automation
Join my community, 7-day free trial: iloveautomation.ai/community
You could also watch:
🔵 UiPath Document Understanding (Invoice) - youtu.be/cp1hbChzUQ4
🔵 UiPath +2 hour Beginners Tutorial - youtu.be/3ZKzTHdpsTs
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.
#uipath #rpa #automation
About this tutorial
Anders Jensen published this 17:30 video tutorial on April 26, 2020. It has been watched 55,060 times on YouTube.
- Channel
- Anders Jensen
- Category
- Education
- Duration
- 17:30
- Published
- April 26, 2020
- Views
- 55,060
- Likes
- 745
Tags
Share
Further reading
-
Extract data from pdf using Regex - Build - UiPath Community ...
forum.uipath.com
Extract data from pdf using Regex. Build. activities. Tereza_Steflova (Tereza) December 22, 2020, 9:10am #1. Hi, I am trying to use Regex, however I still did not find the right formula, the text looks like this: ...
-
Specific PDF Data Extraction using Regular Expression - Build ...
forum.uipath.com
Hey all, I need to extract specific PDF data from this PDF file. I need to extract Number, PNR, Flight No, From, To, Place of Supply and Grand Total from the PDF and write into an Excel file.
-
Extract Specific Data From PDF Automation Using UiPath Studio
c-sharpcorner.com
Reading this article, you can learn How to extract the specific data from the PDF document automation bot using GetText and Message Box activities in UiPath Studio Pro Community
This tutorial in other languages
- FRComment extraire des données du PDF de l'expression rationnelle dans UiPath - Full Tutorial
- ESCómo extraer los datos de PDF con expresiones regulares en UiPath - Tutorial completo
- PTComo extrair dados de PDF do com RegEx em UiPath - Tutorial completo
- ITCome estrarre i dati da PDF con RegEx in UiPath - tutorial completo
- DEWie Daten aus PDF-Dateien mit RegEx in UiPath extrahieren - Full Tutorial
- NLHoe om gegevens van PDF's met RegEx in UiPath uitpakken - Full Tutorial
- RUКак извлечь данные из PDF с RegEx в UiPath - полное руководство
- PLJak wyodrębnić dane z plików PDF z regex w UiPath - Pełny Tutorial
- JA完全なチュートリアル - PDFの正規表現とUiPath内からデータを抽出する方法
- ARكيفية استخراج البيانات من PDF مع التعابير المنطقية في UiPath - دروس كاملة
- HIपीडीएफ UiPath में रेगुलर एक्सप्रेशन से साथ से डेटा निकालने के लिए कैसे - पूर्ण ट्यूटोरियल
- IDBagaimana untuk mengambil data dari PDF dengan regex di UiPath - Full Tutorial