Extract Data from PDF's

Hi everyone,

I have 3 Pdf’s in this format

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?


Can you send the pdf file ?


1 Like

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

1 Like

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

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

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

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

This is what I got

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

Same thing happend

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