Select Page

A new knowledge base article has been published on our support portal.

Scenario Overview

In this scenario we will show you how to create an email address from a contact’s name and their parent account’swebsite URL using regular expressions.

We have a batch of records that contain only the first name and the surname of the contact but they have a parent accountWe will extract the domain name for the email addresses from the parent account’s website field and then add them to the first name and last name.

Processing Steps

In this example we are using website URL.

  1. First we remove ‘www.’ from the website URL if it exists using Replace() function
  2. Next we remove the http:// or https:// if they are on the URL using RegexReplace()
  3. Finally we remove any trailing forward slashes etc. again using RegexReplace()

Start: After the Replace() function: After the first RegexReplace() function: After the second RegexReplace() function:

N52 Formula Manager Solution

The Formula Manager solution works like this,

  • Formula of type ’Save – To Current Record’ is created on the Contact entity
  • Source Property is set to ‘Firstname, Lastname’ and ‘Account Name’
  • The Target Property is set to ‘Email

View this article in full on our support portal