Read PDF and Extract Text to Excel using Regex

[cclemon (Student)]

I would like to extract specific information to Excel from pdf using reg ex.

However, how can I insert the regex formula in UiPath Studio? And how can I set the output to Excel?

I tried to use the activity Regex builder but it doesn’t work. Can anyone screenshot the workflow activity? Thank you very much.

[singh_sumit (Sumit Singh Tariyal)]

Hie @cclemon for this process you have to use these activities
1- if you are working with single pdf you can directly use read pdf activity and if you are working with multiple pdf in a specific folder you can use get file from the folder activity and inside that pass the read pdf activity after that you can use assign activity and do some RegEx or string manipulation to extract specific data from the pdf. and to write that data into the excel you can use build data table for storing the data into the table format and use add row activity and pass the string variable and the datatable variable to that activity and finally use the write range .
cheers Happy Automation

[ali.koundi1 (Ali Koundi)]

Hi @cclemon welcome to UiPath community ,

To insert/use regex expressions you can use assign activity like that :

variable=System.Text.RegularExpressions.Regex.Match(“inputString",“Regex”).Value

and to write results to excel file you can use “UiPath.Excel.Activities”. For the case you mentioned, you can review this process
ExtractPdfToExcel.zip (185.1 KB)

These are some useful topics that can you review :

Using regular expressions in the development of UiPath

Using regular expressions in the development of UiPath This article describes how to use regular expression when developing processes. Regular expression (regex) is a pattern (sequence of characters and metasymbols) which corresponds (or not) to the sequence of characters in the text. As a rule, regular expressions are used to specify the rule of searching for a sequence in the text. The service was used to check the regular visions https://regex101.com/ Places of use Regular expressions ca…

Activities - Workbook Activities

Regards.

[lakshmi.mp]

Hi @cclemon ,
Refer this link you’ll get some idea.

UiPath PDF Extraction | How to EXTRACT data from invoice PDF using ReGex in UiPath? - Use Case

[cclemon (Student)]

Hi, I have successfully output the numbers by the write-line activities.

However, how can I input it to Excel row by row for different files in a folder?

[Anil_G (Anil Gorthi)]

@cclemon

Please check

PDF Regex into Excel

@cclemon create a datatable using required columns you need using build datatable then use add data row activity and add the rows to the datatable after extraction at the end use write range/append range if you want to write to excel directly then use write cells and keep the counter or create a datatble with single row and use append range in loop cheers

cheers