Skip to content

Instantly share code, notes, and snippets.

Show Gist options
  • Star 0 You must be signed in to star a gist
  • Fork 0 You must be signed in to fork a gist
  • Save W3BGUY/19d8d24b64f90f779fa2bc42999c1f6e to your computer and use it in GitHub Desktop.
Save W3BGUY/19d8d24b64f90f779fa2bc42999c1f6e to your computer and use it in GitHub Desktop.
<trans>
accoundAddressSFCountry=CASE(
accountAddressNSCountry=="_afghanistan","AF",
accountAddressNSCountry=="_alandIslands","AX",
accountAddressNSCountry=="_albania","AL",
accountAddressNSCountry=="_algeria","DZ",
accountAddressNSCountry=="_americanSamoa","AS",
accountAddressNSCountry=="_andorra","AD",
accountAddressNSCountry=="_angola","AO",
accountAddressNSCountry=="_anguilla","AI",
accountAddressNSCountry=="_antarctica","AQ",
accountAddressNSCountry=="_antiguaAndBarbuda","AG",
accountAddressNSCountry=="_argentina","AR",
accountAddressNSCountry=="_armenia","AM",
accountAddressNSCountry=="_aruba","AW",
accountAddressNSCountry=="_australia","AU",
accountAddressNSCountry=="_austria","AT",
accountAddressNSCountry=="_azerbaijan","AZ",
accountAddressNSCountry=="_bahamas","BS",
accountAddressNSCountry=="_bahrain","BH",
accountAddressNSCountry=="_bangladesh","BD",
accountAddressNSCountry=="_barbados","BB",
accountAddressNSCountry=="_belarus","BY",
accountAddressNSCountry=="_belgium","BE",
accountAddressNSCountry=="_belize","BZ",
accountAddressNSCountry=="_benin","BJ",
accountAddressNSCountry=="_bermuda","BM",
accountAddressNSCountry=="_bhutan","BT",
accountAddressNSCountry=="_bolivia","BO",
accountAddressNSCountry=="_bosniaAndHerzegovina","BA",
accountAddressNSCountry=="_botswana","BW",
accountAddressNSCountry=="_bouvetIsland","BV",
accountAddressNSCountry=="_brazil","BR",
accountAddressNSCountry=="_britishIndianOceanTerritory","IO",
accountAddressNSCountry=="_bruneiDarussalam","BN",
accountAddressNSCountry=="_bulgaria","BG",
accountAddressNSCountry=="_burkinaFaso","BF",
accountAddressNSCountry=="_burundi","BI",
accountAddressNSCountry=="_cambodia","KH",
accountAddressNSCountry=="_cameroon","CM",
accountAddressNSCountry=="_canada","CA",
accountAddressNSCountry=="_canaryIslands","IC",
accountAddressNSCountry=="_capeVerde","CV",
accountAddressNSCountry=="_caymanIslands","KY",
accountAddressNSCountry=="_centralAfricanRepublic","CF",
accountAddressNSCountry=="_ceutaAndMelilla","EA",
accountAddressNSCountry=="_chad","TD",
accountAddressNSCountry=="_chile","CL",
accountAddressNSCountry=="_china","CN",
accountAddressNSCountry=="_christmasIsland","CX",
accountAddressNSCountry=="_cocosKeelingIslands","CC",
accountAddressNSCountry=="_colombia","CO",
accountAddressNSCountry=="_comoros","KM",
accountAddressNSCountry=="_congoDemocraticPeoplesRepublic","CD",
accountAddressNSCountry=="_congoRepublicOf","CG",
accountAddressNSCountry=="_cookIslands","CK",
accountAddressNSCountry=="_costaRica","CR",
accountAddressNSCountry=="_coteDIvoire","CI",
accountAddressNSCountry=="_croatiaHrvatska","HR",
accountAddressNSCountry=="_cuba","CU",
accountAddressNSCountry=="_cyprus","CY",
accountAddressNSCountry=="_czechRepublic","CZ",
accountAddressNSCountry=="_denmark","DK",
accountAddressNSCountry=="_djibouti","DJ",
accountAddressNSCountry=="_dominica","DM",
accountAddressNSCountry=="_dominicanRepublic","DO",
accountAddressNSCountry=="_eastTimor","TP",
accountAddressNSCountry=="_ecuador","EC",
accountAddressNSCountry=="_egypt","EG",
accountAddressNSCountry=="_elSalvador","SV",
accountAddressNSCountry=="_equatorialGuinea","GQ",
accountAddressNSCountry=="_eritrea","ER",
accountAddressNSCountry=="_estonia","EE",
accountAddressNSCountry=="_ethiopia","ET",
accountAddressNSCountry=="_falklandIslands","FK",
accountAddressNSCountry=="_faroeIslands","FO",
accountAddressNSCountry=="_fiji","FJ",
accountAddressNSCountry=="_finland","FI",
accountAddressNSCountry=="_france","FR",
accountAddressNSCountry=="_frenchGuiana","GF",
accountAddressNSCountry=="_frenchPolynesia","PF",
accountAddressNSCountry=="_frenchSouthernTerritories","TF",
accountAddressNSCountry=="_gabon","GA",
accountAddressNSCountry=="_gambia","GM",
accountAddressNSCountry=="_georgia","GE",
accountAddressNSCountry=="_germany","DE",
accountAddressNSCountry=="_ghana","GH",
accountAddressNSCountry=="_gibraltar","GI",
accountAddressNSCountry=="_greece","GR",
accountAddressNSCountry=="_greenland","GL",
accountAddressNSCountry=="_grenada","GD",
accountAddressNSCountry=="_guadeloupe","GP",
accountAddressNSCountry=="_guam","GU",
accountAddressNSCountry=="_guatemala","GT",
accountAddressNSCountry=="_guernsey","GG",
accountAddressNSCountry=="_guinea","GN",
accountAddressNSCountry=="_guineaBissau","GW",
accountAddressNSCountry=="_guyana","GY",
accountAddressNSCountry=="_haiti","HT",
accountAddressNSCountry=="_heardAndMcDonaldIslands","HM",
accountAddressNSCountry=="_holySeeCityVaticanState","VA",
accountAddressNSCountry=="_honduras","HN",
accountAddressNSCountry=="_hongKong","HK",
accountAddressNSCountry=="_hungary","HU",
accountAddressNSCountry=="_iceland","IS",
accountAddressNSCountry=="_india","IN",
accountAddressNSCountry=="_indonesia","ID",
accountAddressNSCountry=="_iranIslamicRepublicOf","IR",
accountAddressNSCountry=="_iraq","IQ",
accountAddressNSCountry=="_ireland","IE",
accountAddressNSCountry=="_isleOfMan","IM",
accountAddressNSCountry=="_israel","IL",
accountAddressNSCountry=="_italy","IT",
accountAddressNSCountry=="_jamaica","JM",
accountAddressNSCountry=="_japan","JP",
accountAddressNSCountry=="_jersey","JE",
accountAddressNSCountry=="_jordan","JO",
accountAddressNSCountry=="_kazakhstan","KZ",
accountAddressNSCountry=="_kenya","KE",
accountAddressNSCountry=="_kiribati","KI",
accountAddressNSCountry=="_koreaDemocraticPeoplesRepublic","KP",
accountAddressNSCountry=="_koreaRepublicOf","KR",
accountAddressNSCountry=="_kuwait","KW",
accountAddressNSCountry=="_kyrgyzstan","KG",
accountAddressNSCountry=="_laoPeoplesDemocraticRepublic","LA",
accountAddressNSCountry=="_latvia","LV",
accountAddressNSCountry=="_lebanon","LB",
accountAddressNSCountry=="_lesotho","LS",
accountAddressNSCountry=="_liberia","LR",
accountAddressNSCountry=="_libyanArabJamahiriya","LY",
accountAddressNSCountry=="_liechtenstein","LI",
accountAddressNSCountry=="_lithuania","LT",
accountAddressNSCountry=="_luxembourg","LU",
accountAddressNSCountry=="_macau","MO",
accountAddressNSCountry=="_macedonia","MK",
accountAddressNSCountry=="_madagascar","MG",
accountAddressNSCountry=="_malawi","MW",
accountAddressNSCountry=="_malaysia","MY",
accountAddressNSCountry=="_maldives","MV",
accountAddressNSCountry=="_mali","ML",
accountAddressNSCountry=="_malta","MT",
accountAddressNSCountry=="_marshallIslands","MH",
accountAddressNSCountry=="_martinique","MQ",
accountAddressNSCountry=="_mauritania","MR",
accountAddressNSCountry=="_mauritius","MU",
accountAddressNSCountry=="_mayotte","YT",
accountAddressNSCountry=="_mexico","MX",
accountAddressNSCountry=="_micronesiaFederalStateOf","FM",
accountAddressNSCountry=="_moldovaRepublicOf","MD",
accountAddressNSCountry=="_monaco","MC",
accountAddressNSCountry=="_mongolia","MN",
accountAddressNSCountry=="_montenegro","ME",
accountAddressNSCountry=="_montserrat","MS",
accountAddressNSCountry=="_morocco","MA",
accountAddressNSCountry=="_mozambique","MZ",
accountAddressNSCountry=="_myanmar","MM",
accountAddressNSCountry=="_namibia","NA",
accountAddressNSCountry=="_nauru","NR",
accountAddressNSCountry=="_nepal","NP",
accountAddressNSCountry=="_netherlands","NL",
accountAddressNSCountry=="_netherlandsAntilles","AN",
accountAddressNSCountry=="_newCaledonia","NC",
accountAddressNSCountry=="_newZealand","NZ",
accountAddressNSCountry=="_nicaragua","NI",
accountAddressNSCountry=="_niger","NE",
accountAddressNSCountry=="_nigeria","NG",
accountAddressNSCountry=="_niue","NU",
accountAddressNSCountry=="_norfolkIsland","NF",
accountAddressNSCountry=="_northernMarianaIslands","MP",
accountAddressNSCountry=="_norway","NO",
accountAddressNSCountry=="_oman","OM",
accountAddressNSCountry=="_pakistan","PK",
accountAddressNSCountry=="_palau","PW",
accountAddressNSCountry=="_palestinianTerritories","PS",
accountAddressNSCountry=="_panama","PA",
accountAddressNSCountry=="_papuaNewGuinea","PG",
accountAddressNSCountry=="_paraguay","PY",
accountAddressNSCountry=="_peru","PE",
accountAddressNSCountry=="_philippines","PH",
accountAddressNSCountry=="_pitcairnIsland","PN",
accountAddressNSCountry=="_poland","PL",
accountAddressNSCountry=="_portugal","PT",
accountAddressNSCountry=="_puertoRico","PR",
accountAddressNSCountry=="_qatar","QA",
accountAddressNSCountry=="_reunionIsland","RE",
accountAddressNSCountry=="_romania","RO",
accountAddressNSCountry=="_russianFederation","RU",
accountAddressNSCountry=="_rwanda","RW",
accountAddressNSCountry=="_saintBarthelemy","BL",
accountAddressNSCountry=="_saintHelena","SH",
accountAddressNSCountry=="_saintKittsAndNevis","KN",
accountAddressNSCountry=="_saintLucia","LC",
accountAddressNSCountry=="_saintMartin","MF",
accountAddressNSCountry=="_saintVincentAndTheGrenadines","VC",
accountAddressNSCountry=="_Samoa","WS",
accountAddressNSCountry=="_sanMarino","SM",
accountAddressNSCountry=="_saoTomeAndPrincipe","ST",
accountAddressNSCountry=="_saudiArabia","SA",
accountAddressNSCountry=="_senegal","SN",
accountAddressNSCountry=="_serbia","RS",
accountAddressNSCountry=="_seychelles","SC",
accountAddressNSCountry=="_sierraLeone","SL",
accountAddressNSCountry=="_singapore","SG",
accountAddressNSCountry=="_slovakRepublic","SK",
accountAddressNSCountry=="_slovenia","SI",
accountAddressNSCountry=="_solomonIslands","SB",
accountAddressNSCountry=="_somalia","SO",
accountAddressNSCountry=="_southAfrica","ZA",
accountAddressNSCountry=="_southGeorgia","GS",
accountAddressNSCountry=="_spain","ES",
accountAddressNSCountry=="_sriLanka","LK",
accountAddressNSCountry=="_stPierreAndMiquelon","PM",
accountAddressNSCountry=="_sudan","SD",
accountAddressNSCountry=="_suriname","SR",
accountAddressNSCountry=="_svalbardAndJanMayenIslands","SJ",
accountAddressNSCountry=="_swaziland","SZ",
accountAddressNSCountry=="_sweden","SE",
accountAddressNSCountry=="_switzerland","CH",
accountAddressNSCountry=="_syrianArabRepublic","SY",
accountAddressNSCountry=="_taiwan","TW",
accountAddressNSCountry=="_tajikistan","TJ",
accountAddressNSCountry=="_tanzania","TZ",
accountAddressNSCountry=="_thailand","TH",
accountAddressNSCountry=="_togo","TG",
accountAddressNSCountry=="_tokelau","TK",
accountAddressNSCountry=="_tonga","TO",
accountAddressNSCountry=="_trinidadAndTobago","TT",
accountAddressNSCountry=="_tunisia","TN",
accountAddressNSCountry=="_turkey","TR",
accountAddressNSCountry=="_turkmenistan","TM",
accountAddressNSCountry=="_turksAndCaicosIslands","TC",
accountAddressNSCountry=="_tuvalu","TV",
accountAddressNSCountry=="_uganda","UG",
accountAddressNSCountry=="_ukraine","UA",
accountAddressNSCountry=="_unitedArabEmirates","AE",
accountAddressNSCountry=="_unitedKingdomGB","GB",
accountAddressNSCountry=="_unitedStates","US",
accountAddressNSCountry=="_uruguay","UY",
accountAddressNSCountry=="_uSMinorOutlyingIslands","UM",
accountAddressNSCountry=="_uzbekistan","UZ",
accountAddressNSCountry=="_vanuatu","VU",
accountAddressNSCountry=="_venezuela","VE",
accountAddressNSCountry=="_vietnam","VN",
accountAddressNSCountry=="_virginIslandsBritish","VG",
accountAddressNSCountry=="_virginIslandsUSA","VI",
accountAddressNSCountry=="_wallisAndFutunaIslands","WF",
accountAddressNSCountry=="_westernSahara","EH",
accountAddressNSCountry=="_yemen","YE",
accountAddressNSCountry=="_zambia","ZM",
accountAddressNSCountry=="_zimbabwe","ZW",
true,''
);
if(Length(accoundAddressSFCountry)>0 && accoundAddressSFCountry!=Null() && accoundAddressSFCountry!='',
accoundAddressSFCountry;,
Unmap();
);
</trans>
Sign up for free to join this conversation on GitHub. Already have an account? Sign in to comment