Converts country to ISO 3 digit number.
CountryMatchReturnISONumber(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: CountryMatchReturnISONumber({billingcountry}, true)
Input value: Can ada
Result: 124
Example: CountryMatchReturnISONumber({billingcountry}, false)
Input value: Canada
Result 124
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.
