How to extract specific number from PDF to excel using OCR method

Help Studio
1

Hi, PLease help me understand “How to extract specific number from PDF to excel using OCR method”
i am trying to get the data to notepad and then i am trying to move to Excel, but i am struck.
image

2

Hi @naveenkumar.sathiyamoorth,

What’s the issue you are having?

3

I would like to extract the words (Ex:TOYOTA COROLLA 2012-ID:125) available in the PDF file to Excel file and by matching the details already available in the Vehicle sheet i need to separate the Vechicle ID (Ex: 125 from (TOYOTA COROLLA 2012-ID:125). and i need to match the vehicle ID in Codes sheet and get the price into Vehicle Sheet. Hope you can help me.

Auto Sales.pdf (205.0 KB) RPA.xlsx (17.0 KB)

4

Could you help me here please @Gabriele_Camilli

5

@ppr @Gabriele_Camilli @Srini84 Please could you help on this?

I completed till collecting information from PDF but when i try to pull the same to Excel, am getting the below error

image
image1920×1080 263 KB

1 Like
6

Just lets merge/link the different stages so we can avoid redundant efforts

Stage 1: PDF to DataTable Extraction:

7

@ppr I tried that but the task is to do the below activity by using OCR option.

I am very sorry for the continuous questions, but this is my first task couldnt able to complete. Please advise

extract the words (Ex:TOYOTA COROLLA 2012-ID:125) available in the PDF file to Excel file and by matching the details already available in the Vehicle sheet i need to separate the Vechicle ID (Ex: 125 from (TOYOTA COROLLA 2012-ID:125). and i need to match the vehicle ID in Codes sheet and get the price into Vehicle Sheet. Hope you can help me.

Auto Sales.pdf (205.0 KB) RPA.xlsx (17.0 KB)

8

@naveenkumar.sathiyamoorth
as the pdf is allowing to grab the text, we could process as described in the other thread:
grafik

the select marks are showing that it is containing text

Anything else / other data you are trying as OCR is mentioned?

9

screen1.xaml (8.5 KB)

@ppr
THis is the workflow i created till now, Added a column in Excel as “Price” then Collected text from PDF using OCR… and trying to access Excel and paste the information collected from PDF… that is where am geting the error

10

Hi @naveenkumar.sathiyamoorth,

It seems you are trying to write a String in an Excel Range.

If it is just a single value use the Write Cell Activity instead