Saving the Extracted Values to Excel

Hi Everyone,

Can somebody please help me, how we can get the field values that have been extracted from each invoice and then pass them to other application like SAP and also to Excel

Much appreciated for your kind help in advance.

Regards
Vishnu

Hi @winningvish
The invoice is in pdf format ah

Thanks
Ashwin .S

Hi @AshwinS2,

Yes it is in PDF.

Regards
Vishnu

Hi @winningvish

Use Read PDF text with ocr activity

and based on matches activitty you can fill the data in excel and application

Thanks
Ashwin S

Would you please more elaborate on the Matches Activity.

Regards
Vishnu

hi @winningvish

you do get the text based on read pdf text with ocr text

For example if we get invoice number:1520361

(?<=invoice number:).* give this in pattern and pass the text into Input

Thanks
Ashwin S

Hi Ashwin,

I would like to know how to get the results by using the Receipt Invoice AI workflow.

In that workflow without using Read PDF Text activity we are achieving more than 60% accurate results.

Regards
Vishnu

Hi @winningvish

and use for each item

print the item

based on results

Thanks
Ashwin S

Yeah I have done that.

But the problem is I am unable to get the values, where we have manually edited.

Regards
Vishnu

show the screenshot

Thanks
Ashwin S

Sure
Robot Extracted


ManuallyEdited
Edited
ExtractedResults

Regards
Vishnu

Hi @winningvish

u can do one thing

use for each item in matches for ienumerable type

take this pattern

[0-9]+(.[0-9][0-9]?)?

Thanks
Ashwin S