Can't select elements on PDF

Help Studio
, , , ,
1

Hello everyone,
I am trying to create a process that gets data from PDF files creates a new excel file and pastes them there.So far nothing worked.Currently I am trying to use achors but I can’t select the elements I want.I have tried a banch of different settings from various topics with no result.Here is a sample with the fields highlighted and a sample excel with the desired outcome.
Thanks in advance for your time
sample.pdf (215.3 KB)
sampleExcel.xlsx (8.5 KB)

2

Hi @DimiG,

Selectors won’t work here.

Try below approach and let me know if it works for you.

  • Convert pdf to text and use string manipulation(substring, split etc) to extract those data.
  • Use build datatable and update it with extracted data.
  • Once all the data is extracted, Then you can write it to excel.
3

Hello @Ashutosh.Gupta ,
I tried this before using online guides and didn’t work.Not sure if I am doing something wrong as I am very new to this.So far I have tried converting it to .doc,.xls and .txt formats

4

@DimiG

Have you tried with below link?

Hope this may help you

Thanks,
Srini

5

@DimiG

Also, you can try with Document Understanding, as you can train the documents which you need to extract from the PDF

Hope this may help you

Thanks,
Srini

6

Hi @Srini84 ,
Yes I tried with the settings in your link.
Thanks for replying.

7

I was able to resolve this through the Intelligent Form Extractor in the Data Extraction Scope.I manage to create a custom template in the "Manage Templates " menu.Thanks everyone for taking the time to reply

8

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