Extract Pdf Data into Excel

[fizzuraimi (Mohammad Hafiz Bin Zuraimi)]

Hi All, I have data from pdf file (Exchange Rate). I just need to extract the data from the column only and transfer the data to the excel file by row. I had tried using Screen Scraping to extract the data but when I run the UiPath in another time, it get wrong data. I’m new to this, please help me.

[oyahya (Os)]

Have you tried using the Read PDF Text and Read PDF With OCR activities?

You can find them by installing UiPath.PDF.Activities package

[fizzuraimi (Mohammad Hafiz Bin Zuraimi)]

yes. I already tried that activities. but still can’t capture the column of Bank Sell TT. and I also tried using data scraping. but it capture all things in that pdf file

[oyahya (Os)]

Which scraping engine are you using? (OCR, Full Text, or Native) If you’re using OCR I already see the problem. OCR is not accurate scrapper and it’s best to avoid it.

[VirajN (Viraj Nalawade)]

what is the format of your PDF? is it a scanned copy or a normal typed copy?

[fizzuraimi (Mohammad Hafiz Bin Zuraimi)]

It is normal typed pdf

[varunk (Varun Kumar)]

Hi @fizzuraimi,

Try with regular expressions