Attempts to reformat US zip codes adding a leading zero if needed. The primary purpose is to fix zip codes where the leading zero was truncated on import.
ZipCodeClean(StringValue)
Example: ZipCodeClean({billingpostalcode})
Input: 2043
Result: 02043
This is JUST for US zip codes and specifically those in states that typically have a leading zero. May cause unwanted results with non US zip codes. Conditions can be added in MassImpact to only find records in those specific states where the zip code does not currently start with "0".
Click HERE to return to the full list of MassImpact Formulas
