Newest functions Upload a function Leave a tip My account

There are 2,572 functions in this library.

_cf_Country_Letter_Code ( _Country )

If you ever need a country letter code...

  Average rating: 4.4 (36 votes) Log in to vote

Edward Souza Duana A. S. Designs None

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

Case ( _Country= "Afghanistan" ; " AF" ; _Country= "Albania" ; " AL" ; _Country= "Algeria" ; " DZ" ; _Country= "Andorra" ; " AD" ; _Country= "Angola" ; " AO" ; _Country= "Anguilla" ; " AI" ; _Country= "Antarctica" ; " AQ" ; _Country= "Antigua e Barbuda" ; " AG" ; _Country= "Arabian Emirates" ; " AE" ; _Country= "Argentina" ; " AR" ; _Country= "Armenia" ; " AM" ; _Country= "Aruba" ; " AW" ; _Country= "Australia" ; " AU" ; _Country= "Austria" ; " AT" ; _Country= "Azerbaijan" ; " AZ" ; _Country= "Bahamas" ; " BS" ; _Country= "Bahrain" ; " BH" ; _Country= "Bangladesh" ; " BD" ; _Country= "Barbados" ; " BB" ; _Country= "Belarus" ; " BY" ; _Country= "Belgium" ; " BE" ; _Country= "Belize" ; " BZ" ; _Country= "Benin" ; " BJ" ; _Country= "Bermudas" ; " BM" ; _Country= "Bolivia" ; " BO" ; _Country= "Bosnia Herzegovina" ; " BA" ; _Country= "Botswana" ; " BW" ; _Country= "Brazil" ; " BR" ; _Country= "Brunei" ; " BN" ; _Country= "Bulgaria" ; " BG" ; _Country= "Burkina Faso" ; " BF" ; _Country= "Burundi" ; " BI" ; _Country= "Bhutan" ; " BT" ; _Country= "Bouvet Island (Norwegian Territory)" ; " BV" ; _Country= "Cameroon" ; " CM" ; _Country= "Cambodia" ; " KH" ; _Country= "Canada" ; " CA" ; _Country= "Cape Verde" ; " CV" ; _Country= "Cayman Islands" ; " KY" ; _Country= "Centre-African Republic" ; " CF" ; _Country= "Chad" ; " TD" ; _Country= "Chile" ; " CL" ; _Country= "China" ; " CN" ; _Country= "Cocoas Islands" ; " CC" ; _Country= "Colombia" ; " CO" ; _Country= "Comoros Islands" ; " KM" ; _Country= "Congo" ; " CG" ; _Country= "Cook Islands" ; " CK" ; _Country= "Costa Rica" ; " CR" ; _Country= "Croatia (Hrvatska)" ; " 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= "Dutch Antilleans" ; " AN" ; _Country= "East Timor" ; " TP" ; _Country= "Egypt" ; " EG" ; _Country= "El Salvador" ; " SV" ; _Country= "Ecuador" ; " EC" ; _Country= "Equatorial Guinea" ; " GQ" ; _Country= "Eritrea" ; " ER" ; _Country= "Estonia" ; " EE" ; _Country= "Ethiopia" ; " ET" ; _Country= "Faeroes Islands" ; " FO" ; _Country= "Falkland Islands (Malvinas)" ; " FK" ; _Country= "Fiji" ; " FJ" ; _Country= "Finland" ; " FI" ; _Country= "France" ; " FR" ; _Country= "Metropolitan France" ; " FX" ; //sorted under France _Country= "Southern French Territories" ; " TF" ; //sorted under France _Country= "French Guiana" ; " GF" ; _Country= "French Polynesia" ; " PF" ; _Country= "Gabon" ; " GA" ; _Country= "Gambia" ; " GM" ; _Country= "Ghana" ; " GH" ; _Country= "Georgia" ; " GE" ; _Country= "Germany" ; " DE" ; _Country= "Gibraltar" ; " GI" ; _Country= "Great Britain" ; " GB" ; //also United Kingdom _Country= "Granados" ; " GD" ; _Country= "Greece" ; " GR" ; _Country= "Greenland" ; " GL" ; _Country= "Guadalupe" ; " GP" ; _Country= "Guam (US Territory)" ; " GU" ; _Country= "Guatemala" ; " GT" ; _Country= "Guiana" ; " GY" ; _Country= "Guinea" ; " GN" ; _Country= "Guinea-Bissau" ; " GW" ; _Country= "Haiti" ; " HT" ; _Country= "Heard e McDonald Islands (Australian Territory)" ; " HM" ; _Country= "Holland" ; " NL" ; _Country= "Honduras" ; " HN" ; _Country= "Hong Kong" ; " HK" ; _Country= "Hungary" ; " HU" ; _Country= "India" ; " IN" ; _Country= "Indic Ocean British Territory" ; " IO" ; _Country= "Indonesia" ; " ID" ; _Country= "Iran" ; " IR" ; _Country= "Iraq" ; " IQ" ; _Country= "Ireland" ; " IE" ; _Country= "Iceland" ; " IS" ; _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= "Kuwait" ; " KW" ; _Country= "Kyrgyzstan" ; " KG" ; _Country= "Laos" ; " LA" ; _Country= "Latvia" ; " LV" ; _Country= "Lesotho" ; " LS" ; _Country= "Lebanon" ; " LB" ; _Country= "Liberia" ; " LR" ; _Country= "Libya" ; " LY" ; _Country= "Liechtenstein" ; " LI" ; _Country= "Lithuania" ; " LT" ; _Country= "Luxembourg" ; " LU" ; _Country= "Macau" ; " MO" ; _Country= "Macedonia" ; " MK" ; _Country= "Madagascar" ; " MG" ; _Country= "Malaysia" ; " MY" ; _Country= "Malawi" ; " MW" ; _Country= "Maldives" ; " MV" ; _Country= "Mali" ; " ML" ; _Country= "Malta" ; " MT" ; _Country= "Marshall Islands" ; " MH" ; _Country= "Morocco" ; " MA" ; _Country= "Martinique" ; " MQ" ; _Country= "Mauricio" ; " MU" ; _Country= "Mauritania" ; " MR" ; _Country= "Mayetta" ; " YT" ; _Country= "México" ; " MX" ; _Country= "Micronesia" ; " FM" ; _Country= "Mozambique" ; " MZ" ; _Country= "Moldova" ; " MD" ; _Country= "Monaco" ; " MC" ; _Country= "Mongolia" ; " MN" ; _Country= "Montserrat" ; " MS" ; _Country= "Myanmar" ; " MM" ; _Country= "Namibia" ; " NA" ; _Country= "Natal Island" ; " CX" ; _Country= "Nauru" ; " NR" ; _Country= "Nepal" ; " NP" ; _Country= "Nicaragua" ; " NI" ; _Country= "Niger" ; " NE" ; _Country= "Nigeria" ; " NG" ; _Country= "Niue" ; " NU" ; _Country= "Norway" ; " NO" ; _Country= "New Caledonia" ; " NC" ; _Country= "New Zealand" ; " NZ" ; _Country= "Norfolk Islands" ; " NF" ; _Country= "North Korea" ; " KP" ; _Country= "North Marian Islands" ; " MP" ; _Country= "Occidental Sahara" ; " EH" ; _Country= "Occidental Samoa" ; " AS" ; _Country= "Occidental Samoa " ; " WS" ; _Country= "Oman" ; " OM" ; _Country= "Palau" ; " PW" ; _Country= "Panama" ; " PA" ; _Country= "Papua-Nova Guinea" ; " PG" ; _Country= "Pakistan" ; " PK" ; _Country= "Paraguay" ; " PY" ; _Country= "Peru" ; " PE" ; _Country= "Philippines" ; " PH" ; _Country= "Pitcairn Island " ; " PN" ; _Country= "Poland" ; " PL" ; _Country= "Puerto Rico" ; " PR" ; _Country= "Portugal" ; " PT" ; _Country= "Qatar" ; " QA" ; _Country= "Reunion Island" ; " RE" ; _Country= "Romania" ; " RO" ; _Country= "Russian Federation" ; " RU" ; _Country= "Rwanda" ; " RW" ; _Country= "Saint Christian and Nevis" ; " KN" ; _Country= "Saint Pierre and Miquelon" ; " PM" ; _Country= "Saint Thomas and Prince" ; " ST" ; _Country= "Saint Vincent e Grenadines" ; " VC" ; _Country= "San Marino" ; " SM" ; _Country= "Santa Helena" ; " SH" ; _Country= "Santa Lucia" ; " LC" ; _Country= "Saudi Arabia " ; " SA" ; _Country= "Senegal" ; " SN" ; _Country= "Seychelles Islands" ; " SC" ; _Country= "Sierra Leona" ; " SL" ; _Country= "Singapore" ; " SG" ; _Country= "Slovakia" ; " SK" ; _Country= "Slovenia" ; " SI" ; _Country= "Solomon Islands" ; " SB" ; _Country= "Somalia" ; " SO" ; _Country= "South Africa" ; " ZA" ; _Country= "South Georgia Islands and South Sandwich Islands " ; " GS" ; _Country= "South Korea" ; " KR" ; _Country= "Spain" ; " ES" ; _Country= "Sri Lanka" ; " LK" ; _Country= "Sudan" ; " SD" ; _Country= "Suriname" ; " SR" ; _Country= "Svalbard e Jan Mayen Islands" ; " SJ" ; _Country= "Swaziland" ; " SZ" ; _Country= "Sweden" ; " SE" ; _Country= "Switzerland" ; " CH" ; _Country= "Syria" ; " SY" ; _Country= "Tadzhikistan" ; " TJ" ; _Country= "Thailand" ; " TH" ; _Country= "Taiwan" ; " TW" ; _Country= "Tanzania" ; " TZ" ; _Country= "Togo" ; " TG" ; _Country= "Tokelau Islands" ; " TK" ; _Country= "Tonga" ; " TO" ; _Country= "Trinidad and Tobago" ; " TT" ; _Country= "Tunisia" ; " TN" ; _Country= "Turkey" ; " TR" ; _Country= "Turkmenistan" ; " TM" ; _Country= "Turks and Calicos Islands" ; " TC" ; _Country= "Tuvalu" ; " TV" ; _Country= "Uganda" ; " UG" ; _Country= "Ukraine" ; " UA" ; _Country= "United States" ; " US" ; _Country= "Uruguay" ; " UY" ; _Country= "Uzbekistan" ; " UZ" ; _Country= "Vanuatu" ; " VU" ; _Country= "Vatican" ; " VA" ; _Country= "Venezuela" ; " VE" ; _Country= "Vietnam" ; " VN" ; _Country= "Virgin Islands (US)" ; " VI" ; _Country= "Virgin Islands (GB)" ; " VG" ; _Country= "Wallis e Futuna Islands" ; " WF" ; _Country= "Yemen" ; " YE" ; _Country= "Yugoslavia" ; " YU" ; _Country= "Zaire" ; " ZR" ; _Country= "Zambia" ; " ZM" ; _Country= "Zimbabwe" ; " ZW" ) Click to copy

This is a list of countries (sorted partially by their first letter) and their equivalent letter code. I believe the list is rather complete; however, feel free to improve it as you wish.

 

Comments

		ursus, NL Jun 24, 2009
Holland is NOT a country. Holland is a part of The Netherlands. Which can also be just: Netherlands or Netherlands, The Furthermore: Aruba belongs to the Kingdom of The Netherlands as do Bonaire, Curaçao, Sint Maarten, Saba and Sint Eustatius

		Edward Souza, Victoria, BC, CA Apr 30, 2011
Ursus, I got the info from UN itself. Any xenophobic complaints or corrections, please direct to them. :) Cheers, Edward

		Clair, Mexico City May 5, 2011
Good answer, Dude

		Predrag, Montenegro Sep 1, 2011
Yugoslavia can be only ex yugoslavia! New countries: Montenegro ME Serbia SR Croatia HR Makedonija MK Bosnia and Hercegovina BA Slovenia SL

Log in to post comments.

 

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

Support this website.

This library has been a free commmunity resource for FileMaker users and developers for 21 years. It receives no funding and has no advertisements. If it has helped you out, I'd really appreciate it if you could contribute whatever you think it's worth: