Fedex_Country ( Country )

Converts country name into the two character country code used by FedEx

Average rating: 4.1 (37 votes) Log in to vote

Yvonne Dutreaux - Show more from this author
Cordblood Registry

Sample input:

Fedex_Country ( "United States" )
Fedex_Country ( "Fiji" )

Sample output:

US
FJ

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

Case (

Country = "United States" ; "US" ; 
Country = "Canada" ; "CA" ; 
Country = "Albania" ; "AL" ; 
Country = "Algeria" ; "DZ" ; 
Country = "American Samoa" ; "AS" ; 
Country = "Andorra" ; "AD" ; 
Country = "Angola" ; "AO" ; 
Country = "Anguilla" ; "AI" ; 
Country = "Antigua" ; "AG" ; 
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 = "Bermuda" ; "BM" ; 
Country = "Bhutan" ; "BT" ; 
Country = "Bolivia" ; "BO" ; 
Country = "Botswana" ; "BW" ; 
Country = "Brazil" ; "BR" ; 
Country = "British Virgin Is." ; "VG" ; 
Country = "Brunei" ; "BN" ; 
Country = "Bulgaria" ; "BG" ; 
Country = "Burkino Faso" ; "BF" ; 
Country = "Burma" ; "MM" ; 
Country = "Burundi" ; "BI" ; 
Country = "Cambodia" ; "KH" ; 
Country = "Cameroon" ; "CM" ; 
Country = "Cape Verde" ; "CV" ; 
Country = "Cayman Islands" ; "KY" ; 
Country = "Central African" ; "CF" ; 
Country = "Chad" ; "TD" ; 
Country = "Chile" ; "CL" ; 
Country = "China" ; "CN" ; 
Country = "Colombia" ; "CO" ; 
Country = "Congo" ; "CG" ; 
Country = "Congo, The Republic of" ; "CD" ; 
Country = "Cook Islands" ; "CK" ; 
Country = "Costa Rica" ; "CR" ; 
Country = "Cote D'Ivoire" ; "CI" ; 
Country = "Croatia" ; "HR" ; 
Country = "Cyprus" ; "CY" ; 
Country = "Czech Republic" ; "CZ" ; 
Country = "Denmark" ; "DK" ; 
Country = "Djibouti" ; "DJ" ; 
Country = "Dominica" ; "DM" ; 
Country = "Dominican Republic" ; "DO" ; 
Country = "Ecuador" ; "EC" ; 
Country = "Egypt" ; "EG" ; 
Country = "El Salvador" ; "SV" ; 
Country = "Equatorial Guinea" ; "GQ" ; 
Country = "Eritrea" ; "ER" ; 
Country = "Estonia" ; "EE" ; 
Country = "Ethiopia" ; "ET" ; 
Country = "Faeroe Islands" ; "FO" ; 
Country = "Fiji" ; "FJ" ; 
Country = "Finland" ; "FI" ; 
Country = "France" ; "FR" ; 
Country = "French Guiana" ; "GF" ; 
Country = "French Polynesia" ; "PF" ; 
Country = "Gabon" ; "GA" ; 
Country = "Gambia" ; "GM" ; 
Country = "Georgia, Republic of" ; "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 = "Honduras" ; "HN" ; 
Country = "Hong Kong" ; "HK" ; 
Country = "Hungary" ; "HU" ; 
Country = "Iceland" ; "IS" ; 
Country = "India" ; "IN" ; 
Country = "Indonesia" ; "ID" ; 
Country = "Ireland" ; "IE" ; 
Country = "Israel" ; "IL" ; 
Country = "Italy" ; "IT" ; 
Country = "Ivory Coast" ; "CI" ; 
Country = "Jamaica" ; "JM" ; 
Country = "Japan" ; "JP" ; 
Country = "Jordan" ; "JO" ; 
Country = "Kazakhstan" ; "KZ" ; 
Country = "Kenya" ; "KE" ; 
Country = "Kuwait" ; "KW" ; 
Country = "Kyrgyzstan" ; "KG" ; 
Country = "Latvia" ; "LV" ; 
Country = "Lebanon" ; "LB" ; 
Country = "Lesotho" ; "LS" ; 
Country = "Liechtenstein" ; "LI" ; 
Country = "Lithuania" ; "LT" ; 
Country = "Luxembourg" ; "LU" ; 
Country = "Macau" ; "MO" ; 
Country = "Macedonia" ; "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 = "Mexico" ; "MX" ; 
Country = "Micronesia" ; "FM" ; 
Country = "Moldova" ; "MD" ; 
Country = "Monaco" ; "MC" ; 
Country = "Mongolia" ; "MN" ; 
Country = "Montserrat" ; "MS" ; 
Country = "Morocco" ; "MA" ; 
Country = "Mozambique" ; "MZ" ; 
Country = "Myanmar" ; "MM" ; 
Country = "Namibia" ; "NA" ; 
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 = "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 = "Poland" ; "PL" ; 
Country = "Portugal" ; "PT" ; 
Country = "Puerto Rico" ; "US" ; 
Country = "Qatar" ; "QA" ; 
Country = "Reunion Island" ; "RE" ; 
Country = "Romania" ; "RO" ; 
Country = "Russia" ; "RU" ; 
Country = "Rwanda" ; "RW" ; 
Country = "Saipan" ; "MP" ; 
Country = "San Marino" ; "SM" ; 
Country = "Saudi Arabia" ; "SA" ; 
Country = "Senegal" ; "SN" ; 
Country = "Seychelles" ; "SC" ; 
Country = "Sierra Leone" ; "SL" ; 
Country = "Singapore" ; "SG" ; 
Country = "Slovak Republic" ; "SK" ; 
Country = "Slovenia" ; "SI" ; 
Country = "South Africa" ; "ZA" ; 
Country = "South Korea" ; "KR" ; 
Country = "Spain" ; "ES" ; 
Country = "Sri Lanka" ; "LK" ; 
Country = "St. Kitts & Nevis" ; "KN" ; 
Country = "St. Lucia" ; "LC" ; 
Country = "St. Vincent" ; "VC" ; 
Country = "Suriname" ; "SR" ; 
Country = "Swaziland" ; "SZ" ; 
Country = "Sweden" ; "SE" ; 
Country = "Switzerland" ; "CH" ; 
Country = "Syria" ; "SY" ; 
Country = "Taiwan" ; "TW" ; 
Country = "Tanzania" ; "TZ" ; 
Country = "Thailand" ; "TH" ; 
Country = "Togo" ; "TG" ; 
Country = "Trinidad & Tobago" ; "TT" ; 
Country = "Tunisia" ; "TN" ; 
Country = "Turkey" ; "TR" ; 
Country = "Turkmenistan, Republic of" ; "TM" ; 
Country = "Turks & Caicos Is." ; "TC" ; 
Country = "U.A.E." ; "AE" ; 
Country = "U.S. Virgin Islands" ; "VI" ; 
Country = "Uganda" ; "UG" ; 
Country = "Ukraine" ; "UA" ; 
Country = "United Kingdom" ; "GB" ; 
Country = "Uruguay" ; "UY" ; 
Country = "Uzbekistan" ; "UZ" ; 
Country = "Vanuatu" ; "VU" ; 
Country = "Vatican City" ; "VA" ; 
Country = "Venezuela" ; "VE" ; 
Country = "Vietnam" ; "VN" ; 
Country = "Wallis & Futuna Islands" ; "WF" ; 
Country = "Yemen" ; "YE" ; 
Country = "Zambia" ; "ZM" ; 
Country = "Zimbabwe" ; "ZW" 

)

You have to convert long country names to 2 character codes to send data to the Fedex API.

If you use different long country names ex USA instead of United Statues then you can adjust the criteria to meet your needs.

If you only ship to certain countries, either move them to the top so the function doesn't have to evaluate as hard or remove the countries you do not ship to.

Comments

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

Fedex_Country ( Country )

Comments

Support this website.

Support this website.