You are viewing limited content. For full access, please sign in.

Question

Question

Pattern Matching to Create an Email Address

asked on December 28, 2015

Hi, I would like to define a pattern matching using first and last names to create an email address.

The Metadata field containing this value displays names as ; "John, Doe" and I want that value to be translated into john.doe@company.com.

Thanks in advance for your help.

0 0

Answer

SELECTED ANSWER
replied on December 28, 2015 Show version history

Keep in mind that this is for "Firstname, Lastname" setup.  If there is a middle initial, then you will need to modify the pattern.

Try this:

 

change RetrieveFieldValues_Name token to the activity name that you are using to retrieve the name, and update the @company.com to the proper domain.

 

%(RetrieveFieldValues_Name#<(\w*)>#).%(RetrieveFieldValues_Name#<, (\w*)>#)@company.com

 

Capturing Firstname:

 

Capturing Last Name:

 

 

3 0

Replies

replied on December 28, 2015

This should get you started:

^(.+?),\s?(.+)$

 

0 0
You are not allowed to follow up in this post.

Sign in to reply to this post.