Fix email addresses imported into the website field
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, email@example.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."
- The current email is in standard email format
- The desired out come is www.domain.com
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.
Sr. Customer Success Manager