CRMfusion Forums

Fix email addresses imported into the website field  


Kelly Jenkins
Data Sidekick Admin
Joined:2 years  ago
Posts: 58
July 31, 2017 2:15 pm  

We all know bad data makes its way into Salesforce.  We were recently asked how to use MassImpact formulas to fix the data when email addresses were inadvertently imported to the website field.

For Example, was imported to the website field, and it needs to be

This is a great use case for the AllTextAfterChar formula.  It is defined as "Allows the return of text only if it is after a specific character in the string."


  • The current email is in standard email format
  • The desired out come is

Scenario walk through:



Here is more information on MassImpact Formulas.

If you have any uses cases you would like to see presented here, or if you have any questions/comments, please comment below.


Edited: 11 months  ago

Kelly Jenkins
Sr. Customer Success Manager
Validitiy, Inc.