Extract Data from PDF's

Learn
, ,
1

Hi everyone,

I have 3 Pdf’s in this format

Annotation 2020-04-16 111712
Annotation 2020-04-16 111712655×813 23 KB

I need to find the name of the company (ex:ABCompany) and the Total TVA Incluse, take them out and put them in an excel

Can anyone help?

Thanks

2

Can you send the pdf file ?
@Gabriel2

Thanks

1 Like
3

@Gabriel2 Have your tried using Read PDF Text Activity and checked if all the Text is extracted properly ?

1 Like
4

Yes, but I can’t manage to extract the total, and how can I do this for 3 pdfs with 3 different companies?

5

@Gabriel2 Is it possible to provide the PDF or the Text file after extraction using Read PDF Text Activity ?

6

Yes :slight_smile:Annotation 2020-04-16 111712.pdf-converted.pdf (59.5 KB)

7

@Gabriel2 Can you check the workflow if this regex works well with all the pdf files that you have :
RegexFind.xaml (6.0 KB)

8

image
image1466×493 29.7 KB

This is what I got

9

@Gabriel2 Can you use Write line Activity instead of Message Box and Check ? That’s unusual behaviour :sweat_smile:

10

Same thing happend

11

@Gabriel2 Just Check with some Random String in a Message Box if it can display it after Read Pdf Text Actvivity