topic RE: Mapping data in Data Verification in Product Forum

Mapping data in Data Verification

NebiePaulos — Thu, 18 Nov 2021 00:20:00 GMT

Hey all,
So im on data verification working with invoices however I cant seem to get Decipher to identify the Invoice Date because its respective box doesn't only include the date but also other sections. As of right now, when i hover over the invoice date it is highlighting a large box that includes different sections (acct#, tax#, and the date) all in one box. I would have to crop the box to only capture the date and then do that for all the documents. I tried doing this over and over to train decipher to locate the correct data but it doesn't seem to fix this.
Is there a way to fix this mapping situation? Maybe the problem is somewhere in the DFD...

Thanks in advance

------------------------------
Nebie Paulos
------------------------------

RE: Mapping data in Data Verification

Ben.Lyons1 — Thu, 18 Nov 2021 10:37:00 GMT

Hi Nebie,

Are the dates in a consistent format? If so you could use the Format Expression to help better define the data you need to read. This is done via Regex, are you familiar with this?

Thanks

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

RE: Mapping data in Data Verification

NebiePaulos — Fri, 19 Nov 2021 07:03:00 GMT

Hey Ben thanks for getting back. Yes the dates are in a constant format on the invoices however i am not familiar with Regex. How would i use this ?

------------------------------
Nebie Paulos
------------------------------

RE: Mapping data in Data Verification

Ben.Lyons1 — Fri, 19 Nov 2021 08:13:00 GMT

Hi Nebie,

No problem.

Regex is short for Regular Expression and it's kind of a "short hand" for representing characters in a specific format. Here's a couple of websites which can help you learn more about it/test your ideas.

Training
Tester

But for a date in the format dd/mm/yyyy, you would use something like

^(0?[1-9]|[12][0-9]|3[01])[\/\-](0?[1-9]|1[012])[\/\-]\d{4}$

Examples like this can be found via Google, but it's quite generic and may find strange examples like 31/02/4200. In most cases that shouldn't be a problem, but you'll find out when testing.

You would copy and paste the value above into the Format Expression field for your date and this would raise an error when a value is selected that isn't in this format.

Thanks

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