CRMfusion Forums

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


Kelly Jenkins
Data Sidekick Admin
Joined:1 year  ago
Posts: 56
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:

SS screenshot 1

Step 2:

SS screenshot 2

SS screenshot 3

Step 3:

SS screenshot 4


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.


Please Login or Register