PDF tabular data extraction

Help Studio
1

Hi Team,
I wanted to extract PDF table into excel with same format. Please find the attacheInterview Exercise_2.pdf (209.0 KB) d PDF file help me here.

2

Hi @Shaik.Yezdani,

you getting a digitally generated one or Scanned one ?
if it’s digitally generated one you can use Regex. Otherwise you need to use OCR extraction.

3

@Shaik.Yezdani uploaded pdf is a scanned image though it can not be done using PDF Integration activities. You have to perform OCR which is not recommended solution.

4

Hello Yezdani,
In this video, I extract tables from PDF and write data in Excel:

0:25 Install PDF Activities
1:10 READ PDF text, Get PDF page count, Extract PDF
5:40 Read PDF with OCR
6:55 Join PDF and Manage PDF passwords
9:30 Extract Images From PDF and Export PDF as Image
12:00 Extract table from PDF use-cases 1 replace some spaces with | (one column has multiple words)
24:00 Run the robot to see the result
25:40 Extract Table from other PDF use-cases 2 delimiter is 2*spaces " " easy split
31:50 Extract Table from complex PDF use-cases 3 unstructured data the logic will be based on IsUpper and IsLower
40:25 Extract the price value from PDF

Thanks,
Cristian Negulescu