How to Retrive the Date from Invoice?

Help
,
1

Hello Everyone,
I want to enter the date from invoice Pdf to Excel.After Scraping the date it enters into excel like Invoice Date as 28/03/2019 and Due Date as 01-04-2019.I want enter both in same format and what is the possible way to retrive?

Thanks in Advance
KrishnaReddy

2

Hi @krishnareddy,

Use regex pattern to get the date from the scrapped text.

Pattern : \d{2}[\|-]\d{2}[\|-]\d{4}

Regards,
Arivu

3

Where Can i Use this Pattern?

4

When I Scrape the Date Sometimes the date coming like This any solution for this?

image
image1366×768 75 KB

Thanks in Advance
KrishnaReddy

5

@krishnareddy

Use Read Pdf Actvity to read the pdf. It will return the strinfg variable. Then use Regex pattern given by @arivu96 in Matches Activity.

Regards,
Mahesh

6

Hi @krishnareddy,

You can check if the date contains ‘-’ or ‘/’
If it contains ‘-’, create a sequence that will convert the date to your desired format
Else, create a different sequence or code to convert it again to your desired format.

Thanks,
Despi

1 Like