Converts country to ISO 3 character name.
CountryMatchReturn3CharacterName(CountryValue, UseFuzzy)
Note: "Usefuzzy" when set to true will perform a phonetic match on the long name of the country name in an attempt to catch spelling errors. When set to false will look for an exact match ONLY.
- Should be replaced with true or false (Do not use True or False)
- If not specified will default to false
- If the correct country 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: CountryMatchReturn3CharacterName({billingcountry}, true)
Input: United State
Result: USA
Example: CountryMatchReturn3CharacterName({billingcountry}, false)
Input: France
Result: FRA
Note: United Kingdom or UK will be changed to GB or GBR, respective to the formula in use as this is the ISO format. The list of ISO codes used can be found in the following link: ISO 3166 Country Codes.
Click HERE to return to the full list of MassImpact Formulas