Scrape Data from PDF and Save in Excel file

Help
1

I have to scrape the data from PDF file and put it Excel file.
I have attached sample PDF file and image of the PDF file.
PDF will always have 4 columns Pay Unit, CU Description, Attr. Description and Quantity.
Every PDF column should go in separate Excel column.

image
image1387×465 52.9 KB
j_2_12_52_34.pdf (190.1 KB)

2

Hi @deepak99
use read pdf text with ocr and use microsoft ocr
p@ss the stringvar and do the string manipulations

Thanks
ashwin.S

3

Hi @AshwinS2,
I thought of it but not getting any idea for String manipulation.
Can you please elaborate more on this

4

Hi @deepak99

use string split like

test.ToString.Trim.Split({environment.NewLine.ToArray},StringSplitOptions.None)

Check this

or use substring

Th@nks
@shwin S

5

Hi @AshwinS2,
Can you please send me Sample workflow?