topic RE: How to Fetch different Date Format from PDFs in Product Forum

How to Fetch different Date Format from PDFs

Pradeep_KumarKa — Mon, 22 Nov 2021 11:49:00 GMT

I have multiple files and they have different Date Formats like DD.MM.YYYY , MM.DD.YYYY, MM/DD/YYYY ,
12 JAN 2021, . For few documents with date formats with dd.mm.yyyy Decipher is giving the soft validations errors.
Is there any way to fetch the date with multiple date formats?

------------------------------
Pradeep Kaushik
Senior Analyst
Accenture
Gurugram,India
------------------------------

RE: How to Fetch different Date Format from PDFs

lookman — Mon, 22 Nov 2021 16:26:00 GMT

Hi Pradeep.

So are you using a single DFD but the different documents have different date formats for a specific field? In other words, say you have invoice date and it has different formats per vendor. Is that what you are talking about?

jack

------------------------------
Jack Look
Sr Product Consultant
Blue Prism
------------------------------

RE: How to Fetch different Date Format from PDFs

Pradeep_KumarKa — Tue, 23 Nov 2021 19:00:00 GMT

Hi Jack

Yes, I am using purchase order documents for different vendors with different order date formats

For all these vendors i am using the single DFD.

------------------------------
Pradeep Kumar Kaushik
Senior Analyst
Accenture
Asia/Kolkata
------------------------------

RE: How to Fetch different Date Format from PDFs

Pradeep_KumarKa — Thu, 25 Nov 2021 16:54:00 GMT

Hi Team ,

Any solution for the query ?

------------------------------
Pradeep Kumar Kaushik
Senior Analyst
Accenture
Asia/Kolkata
------------------------------

RE: How to Fetch different Date Format from PDFs

Ben.Lyons1 — Fri, 26 Nov 2021 08:53:00 GMT

Hi Pradeep,

The configuration to manage this is the region local. So if you select English-US, Decipher will look for mm/dd/yyyy. You will then find it difficult to use this for other regions, especially where these contradict one another e.g. English-UK, dd/mm/yyyy. This would be difficult to know for many dates which is the month and which is the day.

This may need to be managed via separate Document Types. And if all the documents are quite similar (e.g. all documents are invoices), a classification model may find it difficult to separate them. As such you would then need to split them into different Batch Types prior to uploading them.

Is it possible to determine the region prior to uploading the document to Decipher?

Thanks

------------------------------
Ben Lyons
Product Consultant
Blue Prism
UK
------------------------------