How we can scan the pdf file and retrive the specific data into excel?

Help Studio
, ,
1

how we can scan the pdf file and retrive the specific data into excel?

2

@Sudha_Jha,

Can you attach PDF or paste screenshot of content?
we could understand what data would you like to fetch…

Cheers,
Pankaj

3

Hello @Sudha_Jha ,

Is this a native PDF file or a scan file?

if its native pdf:
Read PDF Text activity

If is a scan:
Read PDF with OCR

After this, extract the info from the resulted file with Regex or Substring.

I hope it helps.

Vasile.

4

BDA_Bulletin_20210425.pdf (9.3 MB)
from this file i have to take cpv code and write in excel

image
image1354×608 133 KB

5

@Sudha_Jha - Please try as shown below…

image
image1819×513 29.6 KB 

(?<=CPV-code.*)\d{8}

Hope this helps…

6

@Sudha_Jha,

Possible,…
You can use sub string and index method.
They can fetch data for you.

Cheers,
Pankaj

7

image
image1366×768 86.5 KB

I am getting this error @prasath17

8

@Sudha_Jha - set the preserve format to true in the Read PDF text activity.

If thats not working …I will share my xaml after sometime.

9

Hi @prasath17,
I have set the preserve format to true in the Read PDF text activity. but still same issue m getting.

10

@Sudha_Jha - Here you go…Regex_SJ.zip (8.5 MB)

Run this workflow, you will see CPV code # “72212322” extracted in the output.