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