countryNameEnFr_FromCode ( countryCode ; language )

Given a country's ISO2 name code and a language - "En" for English or "Fr" for French - the CF returns the country's name in the selected language.

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

François Goulet
Lizzy Logik Inc.
not applicable

Sample input:

countryNameEnFr_FromISO2( "TZ" ; "EN") >
countryNameEnFr_FromISO2( "TZ" ; "FR") >
countryNameEnFr_FromISO2( "RO" ; "EN") >
countryNameEnFr_FromISO2( "RO" ; "FR") >

Sample output:

Tanzania, United Republic of
Tanzanie, République unie de
Romania
Roumanie

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

/*
countryNameEnFr_FromCode ( countryCode ; language ) v.1
Ctredits: thanks to Geoff Wells, DataIsland Software LLC,  for the inspiration provided by his "PositionValue" CF,  which is integrated into this CF.



Given a country's ISO2 name code and a language -"EN" for English" or "FR" for French, the CF returns the Contry's name in the chosen language.

EX:

countryNameEnFr_FromCode( "TZ" ; "EN") > Tanzania, United Republic of
countryNameEnFr_FromCode("TZ" ; "FR") > Tanzanie, République unie de
countryNameEnFr_FromCode( "RO" ; "EN") > Romania
countryNameEnFr_FromCode( "RO" ; "FR") > Roumanie
 */

Let(

[
L= List ( "Afghanistan ~ Afghanistan ~ AF"; "Albania ~ Albanie ~ AL"; "Algeria ~ Algérie ~ DZ"; "American Samoa ~ Samoa américaines ~ AS"; "Andorra ~ Andorre ~ AD"; "Angola ~ Angola ~ AO"; "Anguilla ~ Anguilla ~ AI"; "Antarctica ~ Antarctique ~ AQ"; "Antigua and Barbuda ~ Antigua et Barbuda ~ AG"; "Argentina ~ Argentine ~ AR"; "Armenia ~ Arménie ~ AM"; "Aruba ~ Aruba ~ AW"; "Australia ~ Australie ~ AU"; "Austria ~ Autriche ~ AT"; "Azerbaijan ~ Azerbaïdjan ~ AZ"; "Bahrain ~ Bahrein ~ BH"; "Bangladesh ~ Bangladesh ~ BD"; "Barbados ~ Barbade ~ BB"; "Belarus ~ Bélarus ~ BY"; "Belgium ~ Belgique ~ BE"; "Belize ~ Bélize ~ BZ"; "Benin ~ Bénin ~ BJ"; "Bermuda ~ Bermudes ~ BM"; "Bhutan ~ Bhoutan ~ BT"; "Bolivia ~ Bolivie ~ BO"; "Bosnia and Herzegovina ~ Bosnie herzégovine ~ BA"; "Botswana ~ Botswana ~ BW"; "Bouvet Island ~ Bouvet, Ile ~ BV"; "Brazil ~ Brésil ~ BR"; "British Indian Ocean Territory ~ Océan indien, Territoire britannique de l' ~ IO"; "Virgin Islands, British ~ Îles vierges britanniques ~ VG"; "Brunei Darussalam ~ Brunei Darussalam ~ BN"; "Bulgaria ~ Bulgarie ~ BG"; "Burkina Faso ~ Burkina Faso ~ BF"; "Myanmar ~ Myanmar ~ MM"; "Burundi ~ Burundi ~ BI"; "Cambodia ~ Cambodge ~ KH"; "Cameroon ~ Cameroun ~ CM"; "Canada ~ Canada ~ CA"; "Cape Verde ~ Cap-Vert ~ CV"; "Cayman Islands ~ Caïmanes, Iles ~ KY"; "Central African Republic ~ Centrafricaine, République ~ CF"; "Chad ~ Tchad ~ TD"; "Chile ~ Chili ~ CL"; "China ~ Chine ~ CN"; "Christmas Island ~ Christmas, île ~ CX"; "Cocos (Keeling) Islands ~ Cocos (Keeling), Iles ~ CC"; "Colombia ~ Colombie ~ CO"; "Comoros ~ Comores ~ KM"; "Congo, The Democratic Republic of the ~ Congo, République démocratique du ~ CD"; "Congo ~ Congo ~ CG"; "Cook Islands ~ Cook, Iles ~ CK"; "Costa Rica ~ Costa Rica ~ CR"; "Côte d'Ivoire ~ Côte d'Ivoire ~ CI"; "Croatia ~ Croatie ~ HR"; "Cuba ~ Cuba ~ CU"; "Cyprus ~ Chypre ~ CY"; "Czech Republic ~ Tchèque, République ~ CZ"; "Denmark ~ Danemark ~ DK"; "Djibouti ~ Djibouti ~ DJ"; "Dominica ~ Dominique ~ DM"; "Dominican Republic ~ Dominicaine, République ~ DO"; "Timor-Leste ~ Timor-Leste ~ TL"; "Ecuador ~ Equateur ~ EC"; "Egypt ~ Egypte ~ EG"; "El Salvador ~ El Salvador ~ SV"; "Equatorial Guinea ~ Guinée équatoriale ~ GQ"; "Eritrea ~ Erythrée ~ ER"; "Estonia ~ Estonie ~ EE"; "Ethiopia ~ Ethiopie ~ ET"; "Falkland Islands (Malvinas) ~ Falkland, Iles (Malvinas) ~ FK"; "Faroe Islands ~ Feroe, îles ~ FO"; "Fiji ~ Fidji ~ FJ"; "Finland ~ Finlande ~ FI"; "France ~ France ~ FR"; "French Guiana ~ Guyane française ~ GF"; "French Polynesia ~ Polynésie française ~ PF"; "French Southern Territories ~ Terres australes françaises ~ TF"; "Gabon ~ Gabon ~ GA"; "Georgia ~ Géorgie ~ GE"; "Germany ~ Allemagne ~ DE"; "Ghana ~ Ghana ~ GH"; "Gibraltar ~ Gibraltar ~ GI"; "Greece ~ Grèce ~ GR"; "Greenland ~ Groenland ~ GL"; "Grenada ~ Grenade ~ GD"; "Guadeloupe ~ Guadeloupe ~ GP"; "Guam ~ Guam ~ GU"; "Guatemala ~ Guatemala ~ GT"; "Guinea ~ Guinée ~ GN"; "Guinea-Bissau ~ Guinée-Bissau ~ GW"; "Guyana ~ Guyana ~ GY"; "Haiti ~ Haïti ~ HT"; "Heard Island and McDonald Islands ~ Heard, Ile et McDonald, îles ~ HM"; "Holy See (Vatican City State) ~ Saint-Siège (Etat de la cité du Vatican) ~ VA"; "Honduras ~ Honduras ~ HN"; "Hong Kong ~ Hong-Kong ~ HK"; "Hungary ~ Hongrie ~ HU"; "Iceland ~ Islande ~ IS"; "India ~ Inde ~ IN"; "Indonesia ~ Indonésie ~ ID"; "Iran, Islamic Republic of ~ Iran, République islamique d' ~ IR"; "Iraq ~ Iraq ~ IQ"; "Ireland ~ Irlande ~ IE"; "Israel ~ Israël ~ IL"; "Italy ~ Italie ~ IT"; "Jamaica ~ Jamaïque ~ JM"; "Japan ~ Japon ~ JP"; "Jordan ~ Jordanie ~ JO"; "Kazakhstan ~ Kazakhstan ~ KZ"; "Kenya ~ Kenya ~ KE"; "Kiribati ~ Kiribati ~ KI"; "Korea, Democratic People's Republic of ~ Corée, République populaire démocratique de ~ KP"; "Korea, Republic of ~ Corée, République de ~ KR"; "Kuwait ~ Koweït ~ KW"; "Kyrgyzstan ~ Kirghizistan ~ KG"; "Lao People's Democratic Republic ~ Lao, République démocratique populaire ~ LA"; "Latvia ~ Lettonie ~ LV"; "Lebanon ~ Liban ~ LB"; "Lesotho ~ Lesotho ~ LS"; "Liberia ~ Libéria ~ LR"; "Libyan Arab Jamahiriya ~ Libyenne, Jamahiriya arabe ~ LY"; "Liechtenstein ~ Liechtenstein ~ LI"; "Lithuania ~ Lituanie ~ LT"; "Luxembourg ~ Luxembourg ~ LU"; "Macao ~ Macao ~ MO"; "Macedonia, Republic of ~ Macédoine, l'ex-République yougoslave de ~ MK"; "Madagascar ~ Madagascar ~ MG"; "Malawi ~ Malawi ~ MW"; "Malaysia ~ Malaisie ~ MY"; "Maldives ~ Maldives ~ MV"; "Mali ~ Mali ~ ML"; "Malta ~ Malte ~ MT"; "Marshall Islands ~ Marshall, Iles ~ MH"; "Martinique ~ Martinique ~ MQ"; "Mauritania ~ Mauritanie ~ MR"; "Mauritius ~ Maurice ~ MU"; "Mayotte ~ Mayotte ~ YT"; "Mexico ~ Mexique ~ MX"; "Micronesia, Federated States of ~ Micronésie, Etats Fédérés de ~ FM"; "Moldova ~ Moldova, République de ~ MD"; "Monaco ~ Monaco ~ MC"; "Mongolia ~ Mongolie ~ MN"; "Montserrat ~ Montserrat ~ MS"; "Morocco ~ Maroc ~ MA"; "Mozambique ~ Mozambique ~ MZ"; "Namibia ~ Namibie ~ NA"; "Nauru ~ Nauru ~ NR"; "Nepal ~ Népal ~ NP"; "Netherlands Antilles ~ Antilles néerlandaises ~ AN"; "Netherlands ~ Pays-Bas ~ NL"; "New Caledonia ~ Nouvelle-Calédonie ~ NC"; "New Zealand ~ Nouvelle-Zélande ~ NZ"; "Nicaragua ~ Nicaragua ~ NI"; "Niger ~ Niger ~ NE"; "Nigeria ~ Nigéria ~ NG"; "Niue ~ Nioué ~ NU"; "Norfolk Island ~ Norfolk, Ile ~ NF"; "Northern Mariana Islands ~ Mariannes du nord, Iles ~ MP"; "Norway ~ Norvège ~ NO"; "Oman ~ Oman ~ OM"; "Pakistan ~ Pakistan ~ PK"; "Palau ~ Palaos ~ PW"; "Antarctique 1008 ~ Aruba 1012 ~ PS"; "Panama ~ Panama ~ PA"; "Papua New Guinea ~ Papouasie-Nouvelle-Guinée ~ PG"; "Paraguay ~ Paraguay ~ PY"; "Peru ~ Pérou ~ PE"; "Philippines ~ Philippines ~ PH"; "Pitcairn ~ Pitcairn ~ PN"; "Poland ~ Pologne ~ PL"; "Portugal ~ Portugal ~ PT"; "Puerto Rico ~ Porto Rico ~ PR"; "Qatar ~ Qatar ~ QA"; "Romania ~ Roumanie ~ RO"; "Russian Federation ~ Russie, Fédération de ~ RU"; "Rwanda ~ Rwanda ~ RW"; "Reunion ~ Réunion ~ RE"; "Saint Helena ~ Sainte-Hélène ~ SH"; "Saint Kitts and Nevis ~ Saint-Kitts-et-Nevis ~ KN"; "Saint Lucia ~ Sainte-Lucie ~ LC"; "Saint Pierre and Miquelon ~ Saint-Pierre-et-Miquelon ~ PM"; "Saint Vincent and the Grenadines ~ Saint-Vincent-et-les-Grenadines ~ VC"; "Samoa ~ Samoa ~ WS"; "San Marino ~ Saint-Marin ~ SM"; "Saudi Arabia ~ Arabie Saoudite ~ SA"; "Senegal ~ Sénégal ~ SN"; "Seychelles ~ Seychelles ~ SC"; "Sierra Leone ~ Sierra Leone ~ SL"; "Singapore ~ Singapour ~ SG"; "Slovakia ~ Slovaquie ~ SK"; "Slovenia ~ Slovénie ~ SI"; "Solomon Islands ~ Salomon, Iles ~ SB"; "Somalia ~ Somalie ~ SO"; "South Africa ~ Afrique du Sud ~ ZA"; "South Georgia and the South Sandwich Islands ~ Géorgie du sud et les iles sandwich du sud ~ GS"; "Spain ~ Espagne ~ ES"; "Sri Lanka ~ Sri Lanka ~ LK"; "Sudan ~ Soudan ~ SD"; "Suriname ~ Suriname ~ SR"; "Svalbard and Jan Mayen ~ Svalbard et île Jan Mayen ~ SJ"; "Swaziland ~ Swaziland ~ SZ"; "Sweden ~ Suède ~ SE"; "Switzerland ~ Suisse ~ CH"; "Syrian Arab Republic ~ Syrienne, République arabe ~ SY"; "Sao Tome and Principe ~ Sao Tomé-et-Principe ~ ST"; "Taiwan ~ Taïwan, Province de Chine ~ TW"; "Tajikistan ~ Tadjikistan ~ TJ"; "Tanzania, United Republic of ~ Tanzanie, République unie de ~ TZ"; "Thailand ~ Thaïlande ~ TH"; "Bahamas ~ Bahamas ~ BS"; "Gambia ~ Gambie ~ GM"; "Togo ~ Togo ~ TG"; "Tokelau ~ Tokelau ~ TK"; "Tonga ~ Tonga ~ TO"; "Trinidad and Tobago ~ Trinité-et-Tobago ~ TT"; "Tunisia ~ Tunisie ~ TN"; "Turkey ~ Turquie ~ TR"; "Turkmenistan ~ Turkménistan ~ TM"; "Turks and Caicos Islands ~ Turks et Caïques, Iles ~ TC"; "Tuvalu ~ Tuvalu ~ TV"; "Uganda ~ Ouganda ~ UG"; "Ukraine ~ Ukraine ~ UA"; "United Arab Emirates ~ Emirats arabes unis ~ AE"; "United Kingdom ~ Royaume-Uni ~ GB"; "United States Minor Outlying Islands ~ Îles mineures éloignées des Etats-Unis ~ UM"; "United States ~ Etats-Unis ~ US"; "Uruguay ~ Uruguay ~ UY"; "Uzbekistan ~ Ouzbékistan ~ UZ"; "Vanuatu ~ Vanuatu ~ VU"; "Venezuela ~ Venezuela ~ VE"; "Viet Nam ~ Viet Nam ~ VN"; "Virgin Islands, U.S. ~ Îles vierges des Etats-Unis ~ VI"; "Wallis and Futuna ~ Wallis et Futuna ~ WF"; "Western Sahara ~ Sahara occidental ~ EH");

L2=  Substitute(L; " ~ "; ¶);

Lc= Let ( adjustedText = "¶"  & L2 & "¶" ; If ( Position ( adjustedText ; "¶" & countryCode & "¶" ; 1 ; 1 ) = 0 ; 0 ;ValueCount ( Left ( L2 ; (Position ( adjustedText ; "¶" & countryCode & "¶" ; 1 ; 1 ) - 1) + Length ( countryCode ) ) ) ) ) /3;

Rv= GetValue(L;Lc)

];

If( language = "En"; GetValue ( Substitute(Rv; " ~ ";¶ );1);  GetValue ( Substitute(Rv; " ~ ";¶ );2))

) // END LET

countryNameEnFr_FromISO2 ( countryISO2 ; language ) v.1
Ctredits: thanks to Geoff Wells, DataIsland Software LLC, for the inspiration provided by his "PositionValue" CF, which is integrated into this CF.

Given a country's ISO2 name code and a language -"EN" for English" or "FR" for French, the CF returns the Contry's name in the chosen language.
EX:

countryNameEnFr_FromISO2( "TZ" ; "EN") > Tanzania, United Republic of
countryNameEnFr_FromISO2( "TZ" ; "FR") > Tanzanie, République unie de
countryNameEnFr_FromISO2( "RO" ; "EN") > Romania
countryNameEnFr_FromISO2( "RO" ; "FR") > Roumanie

Comments

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

countryNameEnFr_FromCode ( countryCode ; language )

Comments

Support this website.

Support this website.