Multiple Invoices(Different Vendors)

[Rohith_Shastri]

Dear all,

Good day,

I have a multiple pdf invoices(different Vendor) placed in the folder. example: Here, BOT must read the invoice number and Date from the pdf’s and enter it into the Excel.
attached different invoices screenshot FYI

Please any one guide me how to design the flow or please share the flow

Kindly assist.

Thank you

[Gokul001 (Gokul Balaji)]

Hi @Rohith_Shastri

Can you share the sample PDF

Check out this XAML file

ExtractDatafromPDFRegex.xaml (11.0 KB)

Regards
Gokul

[Rohith_Shastri]

Please find the Attached invoices

Invoice 1.pdf (28.8 KB)
wordpress.pdf (42.6 KB)

Kindly Assist

[Rohith_Shastri]

Kindly Assist

[Gokul001 (Gokul Balaji)]

Hi @Rohith_Shastri

Check out this XAML file

ExtractDatafromPDFRegex.xaml (14.4 KB)

Output

PdfFile1.xlsx (7.2 KB)

Regards
Gokul

[Rohith_Shastri]

Shared file is not opening can you share the folder please

[Gokul001 (Gokul Balaji)]

Why it not opening ? What was the error? @Rohith_Shastri

I will share the image check it out

Directory.GetFiles(Environment.CurrentDirectory+"\WordPdf")

StrInput = System.Text.RegularExpressions.Regex.Match(Sample, "(?<=@)(\S+\s+)(\d{4})|(?<=Invoice\sNumber\s)(\s+)(\S+)").Value.Trim

Invoice Num = System.Text.RegularExpressions.Regex.Match(StrInput, "\d+|\S+\d+").Value

StrInputdate = System.Text.RegularExpressions.Regex.Match(Sample, "(?<=Invoice Date)(\s+\S.+)").Value

Regards
Gokul

[Rohith_Shastri]

Thank you so much for quick response & it’s Working