StateMatchLongName(StateValue, UseFuzzy)
Updates all US states & Canadian provinces to the long form
Ability to customize the state formulas to accommodate international states.
Note: "Usefuzzy" when set to true will perform a phonetic match on the long name of a state in an attempt to catch spelling errors. When set to false, it will look for an exact match ONLY.
The 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: StateMatchLongName({billingstate}, true)
- Input: CT
- Result: Connecticut
Example: StateMatchLongName({billingstate}, true)
- Input: Conecticut
- Result: Connecticut
Example: StateMatchLongName({billingstate}, false)
- Input: OH
- Result: Ohio
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.
More Information on Fuzzy can be found HERE.
Click HERE to return to the full list of MassImpact Formulas.
