StateMatchShortName(StateValue, UseFuzzy)
Updates all US states & Canadian provinces to the ISO two character abbreviation.
Ability to customize the state formulas to accommodate international states. Click HERE for more details.
Note: "Usefuzzy" when set to true will perform a phonetic match on the long name of a state name in an attempt to catch spelling errors, When set to false will look for an exact match ONLY.
Use Fuzzy Option:
- Should be replaced with true or false (Do not use True or False)
- If not specified will default to false
- If the correct state CANNOT be determined with fuzzy set to true, then the original data will be returned
- If wanting to turn on the fuzzy option (true) it is recommended that a pass FIRST be run with fuzzy set to false so that the subsequent pass only shows changed data that DID NOT match exactly
Example: StateMatchShortName({billingstate}, true)
Input: Masachusets
Result: MA
Example: StateMatchShortName({billingstate}, false)
Input: Florida
Result: FL
Note: The State formulas will also convert common abbreviations for states to the appropriate long or short form (e.g. Conn -> Connecticut, CT, Mass -> Massachusetts, MA, Cal -> California, CA, Miss -> Mississippi, MS). This happens with fuzzy set to either true or false.
Click HERE to return to the full list of MassImpact Formulas.
