Regular Expressions in Transformations

Learn how to use regular expressions in transformation.

In the following example, a rep's e-mail address (e.g. john.doe@example.com) is imported and the name of the rep is extracted from the e-mail address:



Regular expressions for the transformation:

Field

External value

Duplicate previous field

Example results

First Name

s,[a-z]+

N

john

Last Name

s,[a-z]+,,,,2

Y

doe

Name

t,([a-z]+)\.([a-z]+),'$1 $2',,,1,

Y

john doe

E-mail

  

Y

john.doe@example.com