Pdf Data extraction by copying data to Notepad

Help Studio
1

Deat Friends,

Could you please help me with the below scenario:

  1. I have read the pdf(readable pdf) data to notepad
  2. now I need the data highlighted to be extrcted and written to excel in the below format.

Attached the screenshot for referene
pdf:

image
image995×924 121 KB

notepad:

image
image1331×1053 36 KB

image
image1329×861 29.8 KB

Expected Excel output:

image
image1727×372 32.4 KB

2

Hi @KavithaManohar

Please try using below activity. if data is getting save as excel. you can read the excel and use output data table activity to covert datatable to a text. then use write text file to save as .txt file

Please mark as solution if found helpful :slight_smile:
Regards
Roshan

3

Hi Roshan,

I tried using this activity, but the output in the excel is not clear as shown below

image
image1102×694 26.4 KB

4

Hi @KavithaManohar

Can you please share pdf

5

Also, I can’t use this activity, if my pdf is more than 3 pages

image
image639×582 40.4 KB

6

This topic was automatically closed 3 days after the last reply. New replies are no longer allowed.