Pdf text to excel data extraction using string operation

Navya1 · July 9, 2019, 5:20am

hi all,
how to extract text from pdf using string operation and store it in excel in this format the pdf is,

KarthikByggari · July 9, 2019, 5:23am

You can use Get Text activity to read the pdf text and then use Excel activities to write it to Excel.

Regards,
Karthik Byggari

NiranjanKN · July 9, 2019, 7:09am

PDF1.pdf (307.9 KB) PDF
Extracted PDF.xlsx (8.6 KB) Excel File

Navya1 · July 9, 2019, 7:10am

@KarthikByggari please find the above sample pdf and excel

Topic		Replies	Views
Extract data from PDF and store into Excel using String Operations Help datatable , activities , studio	5	1624	July 18, 2019
Extraction of pdf text into excel using string operations Help activities , studio	4	810	July 9, 2019
How to extract may data from pdf to excel? Activities pdf , activities , question	1	732	April 27, 2021
Text pdf automation Help pdf , activities , question	19	1361	December 31, 2019
Using read PDF Text Activity to extract the data from the group of pdf and have to use string manipulation to extract the relevant text into excel Help activities	2	837	October 8, 2019