How to get table from pdf

Help
,
1

How to get the highlighted text in a table format from pdf document.

image
image991×223 65.5 KB

Things I have tried-
1-Data Scraping from Adobe Acrobat- Is not taking the Whole table.
2-Epsilon AI- Taking too much time,
Not taking the desired table
Not getting Table
3- Feat System(Pdf to Excel)- Not giving the structured Info.

And I don’t want to apply document understanding.

2

which part you want to extract from table?

3

Whole highlighted text in a tabular format.

4

can you share that pdf file if possible ?

5

It’s Confidential Bro. Can please suggest some solution here?

6

I don’t have such like pdf so if possible then share demo pdf on my mail.
sg2070156@gmail.com

7

@shobhit.sachan…couple of options…

  1. Cv extract table
  2. Document understanding…
1 Like
8

Can you name the nuget package for 1 option?

9

@shobhit.sachan - i dont think there is a special package…

image

Try updating your automation package and check…
image

10

@shobhit.sachan - This was my sample workflow…

image
image448×583 42 KB
and output

image
image996×174 8.4 KB

11

@shobhit.sachan If it is not a scanned PDF, then can you try and use the Read PDF Text Activity and check if the Data that you want to extract appears in a table manner, then maybe we can use regex to group the columns of the tables according to the pattern it resembles. But we would need to have a sample pdf of the same format to be sure if it’s possible using regex.

1 Like
13

read pdf text is not giving the data in table format.

14

Can you share this workflow to shbt2312@gmail.com ?

15

@shobhit.sachan Just to confirm Can you show us the Screenshot of the extracted text from PDF ?

16

image
image1177×341 17.4 KB

Here it is, I have tried regex, but for the same format I’m getting different text before the table starts as shown below

17

@supermanPunch

second text

image
image734×180 5.67 KB

19

It worked for one file and giving the proper output, But how can I apply this in loop. means how can I apply it to multiple files?

20

@shobhit.sachan …good to know…

Say if you have multiple files in the folder …
1.use directory.getfiles(path) to get all the file names
2. For each loop of file name
3. Use CV scope and CV extract table inside the loop
4. Write Range to write the output (if you output in different excel then in the write range just use your filename.xlsx …

21

I already faced a similar challenge… A good OCR and Regex together, can do the work :))

22

But Cv socpe will open the document from where I have generated the Selector for Cv Screen Scope, Have you tried the For each?