Extracting invoice file to excel

Help
, , , , ,
1

Hi,
I am working on extracting data from Invoice Pdf to Excel Kindly i used this expression for Extracting data Element (System.Text.RegularExpressions.Regex.Match(txt,“(?<=From:).+”).ToString.Trim) Now i got issue in From and To Address in Invoice pdf while extracting data it was taking only the row wise (instead of address it was extracting Invoice number) but i need to extract whole the address . Kindly check the pdf i have attached file give below

Invoice1
Invoice11045×542 27.7 KB

2

Hi
Did we try with Screen scrapping method from design tab
Cheers @gokul_t

3

Sorry I didnt get, you can you elobarate the issue@Palaniyappan

1 Like
4

In design tab of studio we got an option called SCREEN SCRAPPING method with which we can scrape this table region and get them as a string output variable

Then this string variable variable can be passed as input to GENERATE DATATABLE ACTIVITY and get the output with a variable of type datatable

And that datatable variable can be used for your validation

Cheers @gokul_t

5

Is it possible to for multiple format of invoices i.e:position of address vary from invoice to invoice, for example if we have 5 Invoice pdf files of same format and 5 are of different formats.@ Palaniyappan

6

Usually while automating the inputs must be set standard, else it would be complex
@gokul_t

7

Extracting value are stored in argument not in string,so how to convert in to string

a6088be1bbfc7821cc044c174b12fbe41e3a1810bd5ed342f97ebd33185a48cc
a6088be1bbfc7821cc044c174b12fbe41e3a1810bd5ed342f97ebd33185a48cc762×491 27.6 KB
@Palaniyappan

8

thats fine, with just .ToString along with the variable it will become a string value
now pass that as input to GENERATE DATATABLE activity
as mentioned

Cheers @gokul_t