Using the Mid_2 formula in MassImpact to standardize Social Security Numbers in Salesforce.
We are often asked how to standardize Social Security Numbers using DemandTools. This is a great use case for the Mid_2 formula.
The Mid_2 formula is formally defined as "Returns the characters from the middle of a text string, given a starting position and length (number of characters to return)"
- Current format of the Social Security field is a string of 9 digits
- The API name of the field used in this scenario is social_security_number__c
Scenario walk though:
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