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

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

@Sudha_Jha,

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

Cheers,
Pankaj

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.

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

@Sudha_Jha - Please try as shown below…

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

Hope this helps…

@Sudha_Jha,

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

Cheers,
Pankaj

I am getting this error @prasath17

@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.

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

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

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