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