DFD Format expression needed to extract the desired value of a field

JanVandekerckho — Wed, 01 Sep 2021 14:25:00 GMT

Hi,

I have a field value in a PDF I want to extract a part of.
This field value always has the format : "[First Name] [Last Name] [Phone number]"
Example : "John Smith 32 2 123 45 67"
The line in the PDF says :
Admin Contact = John Smith 32 2 123 45 67

I need to extract the phone number.

In the DFD the field is set up as Text with sample header value 'Admin Contact =' and I have tried with different format expressions however no luck so far.
Preview is working fine - but extraction via Decipher not with these format expressions :

([0-9]){2}( [0-9]+)*
OR
([0-9]){2}( [0-9]+)*$

Tried also these but there not working in preview even :

\d{2}(?: ?\d+)*$

(?<=[A-Za-z] )(([0-9]){2}( [0-9]+)*$)

Any ideas on this would be appreciated !

Thanks in advance,

Jan

------------------------------
Jan Vandekerckhove
QA Engineer
Proximus
Europe/Brussels
------------------------------

RE: DFD Format expression needed to extract the desired value of a field

HarpreetKaur — Wed, 01 Sep 2021 23:45:00 GMT

Hello Jan,

Can you try using formulas for this field please? I believe what you want can easily be achieved through a STRRIGHT or SPLIT string function.
For your reference - https://bpdocs.blueprism.com/decipher-1-2/en-us/user-guide/formula-language.htm

Regards
Harpreet

------------------------------
Harpreet Kaur Product Consultant
------------------------------

topic RE: DFD Format expression needed to extract the desired value of a field in Product Forum

DFD Format expression needed to extract the desired value of a field

RE: DFD Format expression needed to extract the desired value of a field