CRMfusion Forums

Using the Mid_2 formula in MassImpact to standardize Social Security Numbers in Salesforce.  


Kelly Jenkins
Data Sidekick Admin
Joined:2 years  ago
Posts: 58
June 29, 2017 4:05 pm  

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:

Step 1:

Step 2:

Step 3:


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

Kelly Jenkins
Sr. Customer Success Manager
Validitiy, Inc.