Attempts to standardize the address putting the secondary designator ABOVE the street.
Normalized_US_Address2LineSuiteFirst(InputAddress)
Example: Normalized_US_Address2LineSuiteFirst({mailingstreet})
- Input: One North Main Street, Suite 100
- Result: Ste 100
1 N Main St
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.
