CRMfusion Forums

Fix email addresses imported into the website field  

  RSS

Kelly Jenkins
Data Sidekick Admin
Joined:1 year  ago
Posts: 54
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, test@abc.com was imported to the website field, and it needs to be www.abc.com

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."

Assumptions:

  • The current email is in standard email format
  • The desired out come is www.domain.com

Scenario walk through:

 

Conclusion:

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: 4 months  ago

Kelly Jenkins
Sr. Customer Success Manager
CRMfusion, Inc.


ReplyQuote
  
Working

Please Login or Register