I have limit about scaping data form PDF File doesn't work

Help Community
1

Hi friend My RPA is error because of website for file that I download change some layout. When I review in details I try to adjust some of my code to fit user requirement but when I want to do data scraping in pdf it can’t.

Attchment is: PDF File that I wish to do data scraping, and youtube that I watch to be my sample.

Can someone guide me how to do???
28May2023_BOT_ExchangeRate.pdf (20.7 KB)

You tube Example that I check but doesn’t work.

2

@Thanakorn_Kanjiropas

Welcome to the community

Doing data scrapping on pdf is not very good…

you can try using read pdf text and then d string manipulations or use regex to get the required data

cheers

3

Hi @Thanakorn_Kanjiropas

You can’t do data scraping in the given sample PDF since its not an structured data. If you still want to write all the data into excel you can follow the below steps:

  1. Use “Read PDF Text” activity to read the given PDF.
    output: str_text
  2. Use “Generate Data Table From Text” activity and give
    input: str_text
    output: Data(datatable)
  3. Use “Write Range Workbook” activity to write the data into excel.

Hope it helps!!
Regards,

1 Like
4

Very thanks for all and special thanks for @Parvathy .

I try to follow your comment but I still had an error for a step

err_1
err_11450×778 55 KB

err_2
err_2703×223 12.4 KB

please advise.
Thanakorn

5

@Thanakorn_Kanjiropas
Data is the variable and its variable type is of datatable. Remove (datatable) give create an variable Data.
Regards,

1 Like
6

Oh thank you.