Extract data from a pdf and fill a form

Hi !

I need some help with a process that I am trying to develop.

These are the steps I am trying to define:

  1. read pdf and extract specific data( for example : name, adress, amount paid for the service …
  2. ask to the robot to find the field “name” for example and find it to fill the form.
  3. Repeat the same process with other words( I mean the adress, amount paid…)

The goal of this is to take data from invoices to complete the forms inside a management tool used by an insurer.

I thank you in advaced for your help

PS: please find herewith attached the process I used to do it(as you can imagine, it didn’t work)

Could you give me some ideas or even share the specific process?

This form is an example : https://docs.google.com/forms/d/e/1FAIpQLSfESRBTIhVoF9B5kYEEiMLuJvfLJXYe8mw_WmkrY5jNxY1QDg/viewform?usp=sf_link

I would like the robot to look for field “Name” and then fill it with the data from the pdf “name”

It would help me a lotDatascraping_forum.xaml (19.4 KB)

@dalilasencha Hi is the pdf format same everytime??

can you please upload the sample copy of the pdf

1 Like

Yes exactly, the same format , and the category of data is located always in the same place

The picture I’ve downloaded above is a screenshoot of the pdf.

You will find herewith attached the pdf.
documenttestdatascraping_forum.pdf (414.0 KB)

fetch like name = splitdata(4)
Address = splitdata(—)

pass name, address variables in management tool

Main.xaml (5.1 KB)

1 Like

Then you can read pdf and do string manipulation to get the required data add them to a list or datatable and iterate over to fill in the form.

Thank you for sharing, but still facing this problem :

declare that variable as array of string it should like …

string

Thank you hari it worked.

Do you know how could I copy the information obtained to reuse it and fill the form?? image

can you share that form,

you can pass that variable(name) in that form

Can you share the workflow to see the specific steps?

Main.xaml (6.9 KB)

chk with this

there is an example of form https://docs.google.com/forms/d/e/1FAIpQLSfESRBTIhVoF9B5kYEEiMLuJvfLJXYe8mw_WmkrY5jNxY1QDg/viewform

give this Url in open browser with double quotes

It works thankyou , only one more thing:


I want to ask the robot to look for “Nom” and type into “Nom” in the right field.

Instead of clicking it in my own

Thanks