Created
January 15, 2019 13:26
-
-
Save W3BGUY/19d8d24b64f90f779fa2bc42999c1f6e to your computer and use it in GitHub Desktop.
This file contains bidirectional Unicode text that may be interpreted or compiled differently than what appears below. To review, open the file in an editor that reveals hidden Unicode characters.
Learn more about bidirectional Unicode characters
<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