GetCountryCodeFromCountry ( Country )

Get Country Code from Full Country Name

Average rating: 2.4 (195 votes) Log in to vote

Andy Knasinski - Show more from this author
nrg software, llc.
http://www.nrgsoft.com

Sample input:

GetCountryCodeFromCountry ( "Yemen" )

Sample output:

Function definition: (Copy & paste into FileMaker's Edit Custom Function window)

/*

GetCountryCodeFromCountry ( Country )
Last Updated 5/24/2011 ajk

CountryCode is ISO2 value from the ISO 3166 document which lists each 
country with associated alpha and numeric codes. 

Data provided by GeoWorldMap v2.0.12.88
http://www.geobytes.com/freeservices.htm

More info on ISO standards at
http://www.iso.org/iso/en/prods-services/iso3166ma/02iso-3166-code-lists/list-en1.html

*/


Case (
Country = "Afghanistan" ; "AF" ;
Country = "Albania" ; "AL" ;
Country = "Algeria" ; "DZ" ;
Country = "American Samoa" ; "AS" ;
Country = "Andorra" ; "AD" ;
Country = "Angola" ; "AO" ;
Country = "Anguilla" ; "AI" ;
Country = "Antarctica" ; "AQ" ;
Country = "Antigua and Barbuda" ; "AG" ;
Country = "Argentina" ; "AR" ;
Country = "Armenia" ; "AM" ;
Country = "Aruba" ; "AW" ;
Country = "Australia" ; "AU" ;
Country = "Austria" ; "AT" ;
Country = "Azerbaijan" ; "AZ" ;
Country = "The Bahamas" ; "BS" ;
Country = "Bahrain" ; "BH" ;
Country = "Bangladesh" ; "BD" ;
Country = "Barbados" ; "BB" ;
Country = "Belarus" ; "BY" ;
Country = "Belgium" ; "BE" ;
Country = "Belize" ; "BZ" ;
Country = "Benin" ; "BJ" ;
Country = "Bermuda" ; "BM" ;
Country = "Bhutan" ; "BT" ;
Country = "Bolivia" ; "BO" ;
Country = "Bosnia and Herzegovina" ; "BA" ;
Country = "Botswana" ; "BW" ;
Country = "Bouvet Island" ; "BV" ;
Country = "Brazil" ; "BR" ;
Country = "British Indian Ocean Territory" ; "IO" ;
Country = "British Virgin Islands" ; "VG" ;
Country = "Brunei Darussalam" ; "BN" ;
Country = "Bulgaria" ; "BG" ;
Country = "Burkina Faso" ; "BF" ;
Country = "Burma" ; "MM" ;
Country = "Burundi" ; "BI" ;
Country = "Cambodia" ; "KH" ;
Country = "Cameroon" ; "CM" ;
Country = "Canada" ; "CA" ;
Country = "Cape Verde" ; "CV" ;
Country = "Cayman Islands" ; "KY" ;
Country = "Central African Republic" ; "CF" ;
Country = "Chad" ; "TD" ;
Country = "Chile" ; "CL" ;
Country = "China" ; "CN" ;
Country = "Christmas Island" ; "CX" ;
Country = "Cocos (Keeling) Islands" ; "CC" ;
Country = "Colombia" ; "CO" ;
Country = "Comoros" ; "KM" ;
Country = "Congo, Democratic Republic of the" ; "CD" ;
Country = "Congo, Republic of the" ; "CG" ;
Country = "Cook Islands" ; "CK" ;
Country = "Costa Rica" ; "CR" ;
Country = "Cote d'Ivoire" ; "CI" ;
Country = "Croatia" ; "HR" ;
Country = "Cuba" ; "CU" ;
Country = "Cyprus" ; "CY" ;
Country = "Czech Republic" ; "CZ" ;
Country = "Denmark" ; "DK" ;
Country = "Djibouti" ; "DJ" ;
Country = "Dominica" ; "DM" ;
Country = "Dominican Republic" ; "DO" ;
Country = "East Timor" ; "TL" ;
Country = "Ecuador" ; "EC" ;
Country = "Egypt" ; "EG" ;
Country = "El Salvador" ; "SV" ;
Country = "Equatorial Guinea" ; "GQ" ;
Country = "Eritrea" ; "ER" ;
Country = "Estonia" ; "EE" ;
Country = "Ethiopia" ; "ET" ;
Country = "Falkland Islands (Islas Malvinas)" ; "FK" ;
Country = "Faroe Islands" ; "FO" ;
Country = "Fiji" ; "FJ" ;
Country = "Finland" ; "FI" ;
Country = "France" ; "FR" ;
Country = "French Guiana" ; "GF" ;
Country = "French Polynesia" ; "PF" ;
Country = "French Southern and Antarctic Lands" ; "TF" ;
Country = "Gabon" ; "GA" ;
Country = "The Gambia" ; "GM" ;
Country = "Georgia" ; "GE" ;
Country = "Germany" ; "DE" ;
Country = "Ghana" ; "GH" ;
Country = "Gibraltar" ; "GI" ;
Country = "Greece" ; "GR" ;
Country = "Greenland" ; "GL" ;
Country = "Grenada" ; "GD" ;
Country = "Guadeloupe" ; "GP" ;
Country = "Guam" ; "GU" ;
Country = "Guatemala" ; "GT" ;
Country = "Guinea" ; "GN" ;
Country = "Guinea-Bissau" ; "GW" ;
Country = "Guyana" ; "GY" ;
Country = "Haiti" ; "HT" ;
Country = "Heard Island and McDonald Islands" ; "HM" ;
Country = "Holy See (Vatican City)" ; "VA" ;
Country = "Honduras" ; "HN" ;
Country = "Hong Kong (SAR)" ; "HK" ;
Country = "Hungary" ; "HU" ;
Country = "Iceland" ; "IS" ;
Country = "India" ; "IN" ;
Country = "Indonesia" ; "ID" ;
Country = "Iran" ; "IR" ;
Country = "Iraq" ; "IQ" ;
Country = "Ireland" ; "IE" ;
Country = "Israel" ; "IL" ;
Country = "Italy" ; "IT" ;
Country = "Jamaica" ; "JM" ;
Country = "Japan" ; "JP" ;
Country = "Jordan" ; "JO" ;
Country = "Kazakhstan" ; "KZ" ;
Country = "Kenya" ; "KE" ;
Country = "Kiribati" ; "KI" ;
Country = "Korea, North" ; "KP" ;
Country = "Korea, South" ; "KR" ;
Country = "Kuwait" ; "KW" ;
Country = "Kyrgyzstan" ; "KG" ;
Country = "Laos" ; "LA" ;
Country = "Latvia" ; "LV" ;
Country = "Lebanon" ; "LB" ;
Country = "Lesotho" ; "LS" ;
Country = "Liberia" ; "LR" ;
Country = "Libya" ; "LY" ;
Country = "Liechtenstein" ; "LI" ;
Country = "Lithuania" ; "LT" ;
Country = "Luxembourg" ; "LU" ;
Country = "Macao" ; "MO" ;
Country = "Macedonia, The Former Yugoslav Republic of" ; "MK" ;
Country = "Madagascar" ; "MG" ;
Country = "Malawi" ; "MW" ;
Country = "Malaysia" ; "MY" ;
Country = "Maldives" ; "MV" ;
Country = "Mali" ; "ML" ;
Country = "Malta" ; "MT" ;
Country = "Marshall Islands" ; "MH" ;
Country = "Martinique" ; "MQ" ;
Country = "Mauritania" ; "MR" ;
Country = "Mauritius" ; "MU" ;
Country = "Mayotte" ; "YT" ;
Country = "Mexico" ; "MX" ;
Country = "Micronesia, Federated States of" ; "FM" ;
Country = "Moldova" ; "MD" ;
Country = "Monaco" ; "MC" ;
Country = "Mongolia" ; "MN" ;
Country = "Montserrat" ; "MS" ;
Country = "Morocco" ; "MA" ;
Country = "Mozambique" ; "MZ" ;
Country = "Namibia" ; "NA" ;
Country = "Nauru" ; "NR" ;
Country = "Nepal" ; "NP" ;
Country = "Netherlands" ; "NL" ;
Country = "Netherlands Antilles" ; "AN" ;
Country = "New Caledonia" ; "NC" ;
Country = "New Zealand" ; "NZ" ;
Country = "Nicaragua" ; "NI" ;
Country = "Niger" ; "NE" ;
Country = "Nigeria" ; "NG" ;
Country = "Niue" ; "NU" ;
Country = "Norfolk Island" ; "NF" ;
Country = "Northern Mariana Islands" ; "MP" ;
Country = "Norway" ; "NO" ;
Country = "Oman" ; "OM" ;
Country = "Pakistan" ; "PK" ;
Country = "Palau" ; "PW" ;
Country = "Panama" ; "PA" ;
Country = "Papua New Guinea" ; "PG" ;
Country = "Paraguay" ; "PY" ;
Country = "Peru" ; "PE" ;
Country = "Philippines" ; "PH" ;
Country = "Pitcairn Islands" ; "PN" ;
Country = "Poland" ; "PL" ;
Country = "Portugal" ; "PT" ;
Country = "Puerto Rico" ; "PR" ;
Country = "Qatar" ; "QA" ;
Country = "RÈunion" ; "RE" ;
Country = "Romania" ; "RO" ;
Country = "Russia" ; "RU" ;
Country = "Rwanda" ; "RW" ;
Country = "Saint Helena" ; "SH" ;
Country = "Saint Kitts and Nevis" ; "KN" ;
Country = "Saint Lucia" ; "LC" ;
Country = "Saint Pierre and Miquelon" ; "PM" ;
Country = "Saint Vincent and the Grenadines" ; "VC" ;
Country = "Samoa" ; "WS" ;
Country = "San Marino" ; "SM" ;
Country = "S„o TomÈ and PrÌncipe" ; "ST" ;
Country = "Saudi Arabia" ; "SA" ;
Country = "Senegal" ; "SN" ;
Country = "Seychelles" ; "SC" ;
Country = "Sierra Leone" ; "SL" ;
Country = "Singapore" ; "SG" ;
Country = "Slovakia" ; "SK" ;
Country = "Slovenia" ; "SI" ;
Country = "Solomon Islands" ; "SB" ;
Country = "Somalia" ; "SO" ;
Country = "South Africa" ; "ZA" ;
Country = "South Georgia and the South Sandwich Islands" ; "GS" ;
Country = "Spain" ; "ES" ;
Country = "Sri Lanka" ; "LK" ;
Country = "Sudan" ; "SD" ;
Country = "Suriname" ; "SR" ;
Country = "Svalbard" ; "SJ" ;
Country = "Swaziland" ; "SZ" ;
Country = "Sweden" ; "SE" ;
Country = "Switzerland" ; "CH" ;
Country = "Syria" ; "SY" ;
Country = "Taiwan" ; "TW" ;
Country = "Tajikistan" ; "TJ" ;
Country = "Tanzania" ; "TZ" ;
Country = "Thailand" ; "TH" ;
Country = "Togo" ; "TG" ;
Country = "Tokelau" ; "TK" ;
Country = "Tonga" ; "TO" ;
Country = "Trinidad and Tobago" ; "TT" ;
Country = "Tunisia" ; "TN" ;
Country = "Turkey" ; "TR" ;
Country = "Turkmenistan" ; "TM" ;
Country = "Turks and Caicos Islands" ; "TC" ;
Country = "Tuvalu" ; "TV" ;
Country = "Uganda" ; "UG" ;
Country = "Ukraine" ; "UA" ;
Country = "United Arab Emirates" ; "AE" ;
Country = "United Kingdom" ; "GB" ;
Country = "United States" ; "US" ;
Country = "United States Minor Outlying Islands" ; "UM" ;
Country = "Uruguay" ; "UY" ;
Country = "Uzbekistan" ; "UZ" ;
Country = "Vanuatu" ; "VU" ;
Country = "Venezuela" ; "VE" ;
Country = "Vietnam" ; "VN" ;
Country = "Virgin Islands" ; "VI" ;
Country = "Wallis and Futuna" ; "WF" ;
Country = "Western Sahara" ; "EH" ;
Country = "Yemen" ; "YE" ;
Country = "Yugoslavia" ; "YU" ;
Country = "Zambia" ; "ZM" ;
Country = "Zimbabwe" ; "ZW" ;
Country = "Palestinian Territory, Occupied" ; "PS" 
)

Convert country names to ISO country codes

Comments

		Jack, London Aug 30, 2011
No case checking? Yikes!

		Andy Aug 30, 2011
?? FMP is is not case sensitive for these comparisons.

		Ward, Massachusetts, USA Nov 30, 2012
FileMaker Pro 11 Advanced chokes on this line: Country = "Sâ€žo TomÃˆ and PrÃŒncipe" ; "ST" ; I replaced the accented name with "Sao Tome and Principe" from Wikipedia's ISO 31166-1 alpha-2 page: http://en.wikipedia.org/wiki/ISO_3166-1_alpha-2

		Robert Woodhead, Wilmington, NC Jul 2, 2014
Handy function, but needs some updates to handle variants. Here are the edits. GetCountryCodeFromCountry ( CountryName ) Let(Country= Substitute( Substitute( Substitute( Substitute( if(Left(CountryName,4)="The ",Right(CountryName,Length(CountryName)-4),CountryName) ;" & ";" and ") ;"&";" and ") ;" ";" ") ;" ";" "); Case ( ... case list ... "" )) And add the following case variants Country = "Palestine" ; "PS" ; Country = "Russian Federation" ; "RU" ; Country = "Great Britain" ; "GB" ; Country = "Great Britain and Northern Ireland" ; "GB" ; Country = "United States" ; "US" ; Country = "USA" ; "US" ; Country = "Sao Tome and Principe" ; "ST" ; Country = "Cocos Islands" ; "CC" ; Country = "Keeling Islands" ; "CC" ; Country = "Democratic Republic of the Congo" ; "CD" ; Country = "Republic of the Congo" ; "CG" ; Country = "Falkland Islands (Malvinas)" ; "FK" ; Country = "Falkland Islands" ; "FK" ; Country = "Malvinas" ; "FK" ; Country = "Vatican City" ; "VA" ; Country = "The Vatican" ; "VA" ; Country = "The Former Yugoslav Republic of Macedonia" ; "MK" ; Country = "Macedonia" ; "MK" ; Country = "Micronesia, Federated States of" ; "FM" ; Country = "Federated States of Micronesia&qu

Note: these functions are not guaranteed or supported by BrianDunning.com. Please contact the individual developer with any questions or problems.

GetCountryCodeFromCountry ( Country )

Comments

Support this website.

Support this website.