topic RE: Issues with Name fields where value has multiple spaces. in Product Forum

Issues with Name fields where value has multiple spaces.

Tejaskumar_Darji — Sat, 20 Nov 2021 15:35:00 GMT

Hi Team,

I have an invoice where various name fields are present.

After building DFD and adding sample headers Decipher is able to capture the field but not fully.

For e.g. if the value of the name is "Mr.A. B. XYZ" then it keeps picking value just as "Mr.A" Or "XYZ" Or "Mr.A. B." even after training it multiple times.

While I want to capture the full name always because the name can be even longer.

Any solution to this sort of issue with fields having multiple spaces in between.

------------------------------
Thanks & Regards,
Tejaskumar Darji
Sr. RPA Consultant-Automation Developer
------------------------------

RE: Issues with Name fields where value has multiple spaces.

Ben.Lyons1 — Mon, 22 Nov 2021 08:41:00 GMT

Hi Tejaskumar,

Would it be possible to use regex in the format expression field to help Decipher understand what to expect?

Thanks

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

RE: Issues with Name fields where value has multiple spaces.

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

Hi Tejaskumar.

Would it be possible to use a validation list?

jack

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

RE: Issues with Name fields where value has multiple spaces.

Tejaskumar_Darji — Tue, 23 Nov 2021 17:23:00 GMT

Yeah, I can use regex or bp logic downstream when I have full name data. But here Decipher region itself gets shortened so it is not capturing the entire name in the first place. So applying for regex help here?

------------------------------
Thanks & Regards,
Tejaskumar Darji
Sr. RPA Consultant-Automation Developer
------------------------------

RE: Issues with Name fields where value has multiple spaces.

Tejaskumar_Darji — Tue, 23 Nov 2021 17:27:00 GMT

Hello Jack,

But I don't have any DB where I can validate names because it is not from a static DB list. Name can be anything,

------------------------------
Thanks & Regards,
Tejaskumar Darji
Sr. RPA Consultant-Automation Developer
------------------------------

RE: Issues with Name fields where value has multiple spaces.

Ben.Lyons1 — Wed, 24 Nov 2021 08:10:00 GMT

Hi,

You can add the regex to the Format Expression field and this will help Decipher correctly identify the full region and add some validation to help prevent incorrect (or incomplete) data from being passed back to BP.

I would imagine you would start with something like (Mr|Ms|Miss|Mrs|Dr)?\s\w+\s\w+

But you would need to extensively test this against different names and update as needed.

Thanks

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