GetCountryFromCountryCode ( CountryCode )

Get full country name from country code

Average rating: 3.8 (49 votes) Log in to vote

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

Sample input:

GetCountryFromCountryCode ( "YE" )

Sample output:

Yemen

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

/*

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

Convert ISO country code to full country name

Comments

		HOnza, Prague Apr 26, 2011
Great idea, faster and easier to use than related table (unless you need the country names in multiple languages). Why are all country names in all upper case? We can always use Upper if we want it this way, but if we want the country name with correct case, this custom function will fail. I would also suggest adding last update date in the function as a comment because this kind of function can be obsoleted by political changes.

		john renfrew, attitude May 24, 2011
The ISO 3166-1 lists all have the names a UPPERcase interestingly, but this list is not correct to it. http://www.iso.org/iso/country_codes/iso_3166_code_lists/iso-3166-1_decoding_table.htm

		Andy May 24, 2011
ISO lists the country names in uppercase. Just posted updated list with modified date and comments in script with country names in proper case, you can now convert on your own to uppercase. While the ISO list is helpful, we work with the ship carriers and have had to create our own conversion tables from ISO to carrier names for compliance in our certified shipping solutions for USPS, UPS and FedEx.

		Ward, Massachusetts, USA Nov 30, 2012
FileMaker Pro 11 Advanced chokes on this line: CountryCode = "ST" ; "Sâ€žo TomÃˆ and PrÃŒncipe" ; 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

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

GetCountryFromCountryCode ( CountryCode )

Comments

Support this website.

Support this website.