I need to extract data from pdf and need to write it in to excel, for that 1.I read that pdf using read pdf text activity and write it in to a txt file. 2.Then after I provided regular expression and created a variable OpVar, then i created an if condition OpVar. Any().and pass that variable to fo…

Find the attached screenshots… Process screenshot… [GenerateDt2] Output screenshot… [GenerateDt] Then use write range and pass the Generate data table output Regards, NaNi

Hi @Chippy_Kolot It would be convenient for us to provide the solution if you could share sample input and output.

Hey! Could you please paste the text file here? And also mention which data you’re trying to extract? we can extract the specific data using RegEx… Regards, NaNi

Sample_data.txt (312 Bytes) This is the sample data,. I’m sorry that I cant post exact data here. Similar txt file i got after reading the pdf using read pdf text activity, and write in to txt file. DataNo, DataSummary,Number,Records,Expanded,Sum These are the fields available in the pdf . for …

Hey! @Chippy_Kolot , Could you please show us the expected output? If you’re trying to push this data to data table… we can use Generate DataTable activity… The separator is Space… Will generate the data as it is… Regards, NaNi

In excel it should be written as DATANO DATADESCRIPTION NO RECORD EXPANDED SUM 123456 FDFGHYHJJKKKKLLLLLLC 1 1, 1,234.05 2345.3 2345.34 798541 GFGFGHJKJHFVHHGFHJHK 2 1,…

Yes… We can do that by using Generate data table… Try this and let me know… Regards, NaNi

Not able to extract data after performing regular expression

Help Studio

THIRU_NANI (NaNi) July 18, 2022, 12:41pm 8

Find the attached screenshots…

Process screenshot…

Output screenshot…

Then use write range and pass the Generate data table output

Regards,
NaNi

Topic		Replies	Views
EXtract Data from PDF and write to excel Activities pdf , activities , question	4	561	March 7, 2023
PDF content in to in to excel table Studio uiautomation	7	2114	April 29, 2021
Extract multiple PDF data and store into Excel using String operations Studio activities , question	1	827	March 16, 2020
Extract PDF regex to table Studio studio , question , activities_panel	21	730	June 19, 2023
How to Extract the fields from pdf using Regex Academy Courses studio , regex , question , data_manipulation , activities_panel , linq	8	2805	January 20, 2023

Not able to extract data after performing regular expression

Related topics