cancel
Showing results for 
Search instead for 
Did you mean: 

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

JanVandekerckho
Level 3
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
------------------------------
1 REPLY 1

HarpreetKaur
Level 7
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
------------------------------