Attempts to standardize a Street Address to match the USPS preferred format. Address line 1 and address line 2 are returned on one line (this is the USPS preferred format).
Normalized_US_Address(InputAddress)
Example: Normalized_US_Address({mailingstreet})
- Input: 7th Floor, 162 Washington St.
- Result: 162 Washington St Fl 7
Example: Normalized_US_Address({mailingstreet})
- Input: One North Main Street, Suite 100
- Result: 1 N Main St Ste 100
We highly recommend that address normalization formulas NOT BE SCHEDULED as the results will vary based on the validity of the supplied address. For example, street addresses that contain building names (i.e. 123 Main St Suite 100 One Prudential Tower) WILL RETURN UNWANTED RESULTS. All results should be manually reviewed and unwanted results unchecked before processing.
Users who choose to schedule this formula in lieu of this warning, may want to create a "do not include" flag on their records to filter out records with street addresses that cause unwanted results so that they will not be included in future scheduled runs.
The formula uses the guidelines in the following document published by the USPS when attempting to normalize the address: http://pe.usps.gov/cpim/ftp/pubs/pub28/pub28.pdf.
The formula DOES NOT verify the street address, it just attempts to normalize the data to the USPS standards. Results are returned in proper case vs. upper case.
To return in upper case, nest within the UCase formula:
- UCase(Normalized_US_Address({mailingstreet}))
Click HERE to return to the full list of MassImpact Formulas.
