Get the country code from a formatted phone number?

[netgoondoo]

Consent to Access & Modify

I don't authorize Pabbly Support to log in to my account.

How to get the country code from a fully formatted phone number?

Is there a global lookup table we can use?

For example, if the phone is +1-520-123-1234

I want to be able to output the string "US" to the country field in Monday.com.

 

[ArshilAhmad]

Hi @netgoondoo,

You can add this JS code to your workflow. It will return the ISO country code associated with the phone number, which you can then pass to the Monday.com action step. stephttps://connect.pabbly.com/workflow/share/WxNSYFUCUzBTGVM5UTQDJAgcBgICWwJgBh8CEFVaAXkGSABFAUBaMApGUnADYgdmXhdUPgBcVGgNGQEFUwUHdFdNBSldXl0nVRhUZwNKCzhbBVJ6VTQ#

// Pure-JS heuristic approach
const callingCodeToIso = {
  "1": "US",
"1242": "BS",
"1246": "BB",
"1264": "AI",
"1268": "AG",
"1284": "VG",
"1340": "VI",
"1345": "KY",
"1441": "BM",
"1473": "GD",
"1649": "TC",
"1664": "MS",
"1670": "MP",
"1671": "GU",
"1684": "AS",
"1758": "LC",
"1767": "DM",
"1784": "VC",
"1787": "PR",
"1809": "DO",
"1829": "DO",
"1849": "DO",
"1868": "TT",
"1869": "KN",
"1876": "JM",
"20": "EG",
"211": "SS",
"212": "MA",
"213": "DZ",
"216": "TN",
"218": "LY",
"220": "GM",
"221": "SN",
"222": "MR",
"223": "ML",
"224": "GN",
"225": "CI",
"226": "BF",
"227": "NE",
"228": "TG",
"229": "BJ",
"230": "MU",
"231": "LR",
"232": "SL",
"233": "GH",
"234": "NG",
"235": "TD",
"236": "CF",
"237": "CM",
"238": "CV",
"239": "ST",
"240": "GQ",
"241": "GA",
"242": "CG",
"243": "CD",
"244": "AO",
"245": "GW",
"246": "IO",
"248": "SC",
"249": "SD",
"250": "RW",
"251": "ET",
"252": "SO",
"253": "DJ",
"254": "KE",
"255": "TZ",
"256": "UG",
"257": "BI",
"258": "MZ",
"260": "ZM",
"261": "MG",
"262": "RE",
"263": "ZW",
"264": "NA",
"265": "MW",
"266": "LS",
"267": "BW",
"268": "SZ",
"269": "KM",
"27": "ZA",
"290": "SH",
"291": "ER",
"297": "AW",
"298": "FO",
"299": "GL",
"30": "GR",
"31": "NL",
"32": "BE",
"33": "FR",
"34": "ES",
"350": "GI",
"351": "PT",
"352": "LU",
"353": "IE",
"354": "IS",
"355": "AL",
"356": "MT",
"357": "CY",
"358": "FI",
"359": "BG",
"36": "HU",
"370": "LT",
"371": "LV",
"372": "EE",
"373": "MD",
"374": "AM",
"375": "BY",
"376": "AD",
"377": "MC",
"378": "SM",
"379": "VA",
"380": "UA",
"381": "RS",
"382": "ME",
"383": "XK",
"385": "HR",
"386": "SI",
"387": "BA",
"389": "MK",
"39": "IT",
"40": "RO",
"41": "CH",
"420": "CZ",
"421": "SK",
"423": "LI",
"43": "AT",
"44": "GB",
"45": "DK",
"46": "SE",
"47": "NO",
"48": "PL",
"49": "DE",
"500": "FK",
"501": "BZ",
"502": "GT",
"503": "SV",
"504": "HN",
"505": "NI",
"506": "CR",
"507": "PA",
"508": "PM",
"509": "HT",
"51": "PE",
"52": "MX",
"53": "CU",
"54": "AR",
"55": "BR",
"56": "CL",
"57": "CO",
"58": "VE",
"590": "GP",
"591": "BO",
"592": "GY",
"593": "EC",
"594": "GF",
"595": "PY",
"596": "MQ",
"597": "SR",
"598": "UY",
"599": "CW",
"60": "MY",
"61": "AU",
"62": "ID",
"63": "PH",
"64": "NZ",
"65": "SG",
"66": "TH",
"670": "TL",
"672": "NF",
"673": "BN",
"674": "NR",
"675": "PG",
"676": "TO",
"677": "SB",
"678": "VU",
"679": "FJ",
"680": "PW",
"681": "WF",
"682": "CK",
"683": "NU",
"685": "WS",
"686": "KI",
"687": "NC",
"688": "TV",
"689": "PF",
"690": "TK",
"691": "FM",
"692": "MH",
"7": "RU",
"76": "KZ",
"77": "KZ",
"81": "JP",
"82": "KR",
"84": "VN",
"850": "KP",
"852": "HK",
"853": "MO",
"855": "KH",
"856": "LA",
"86": "CN",
"880": "BD",
"886": "TW",
"90": "TR",
"91": "IN",
"92": "PK",
"93": "AF",
"94": "LK",
"95": "MM",
"960": "MV",
"961": "LB",
"962": "JO",
"963": "SY",
"964": "IQ",
"965": "KW",
"966": "SA",
"967": "YE",
"968": "OM",
"970": "PS",
"971": "AE",
"972": "IL",
"973": "BH",
"974": "QA",
"975": "BT",
"976": "MN",
"977": "NP",
"98": "IR",
"992": "TJ",
"993": "TM",
"994": "AZ",
"995": "GE",
"996": "KG",
"998": "UZ"
};

function getIsoFromPhone(number) {
  if (!number) return null;
  // normalize to digits with optional leading +
  const normalized = number.replace(/[^\d+]/g, '');
  // must start with +
  const plusNormalized = normalized.startsWith('+') ? normalized : '+' + normalized;

  // strip the plus for matching
  const digits = plusNormalized.slice(1);

  // country calling codes are 1..3 digits — try longest-first
  for (let len = 3; len >= 1; len--) {
    const code = digits.slice(0, len);
    if (callingCodeToIso[code]) return callingCodeToIso[code];
  }
  return null; // unknown / not in our table
}

// example
console.log( getIsoFromPhone('+1-520-123-1234') ); // "US"

Thanks & Regards,
Arshil Ahmad
Customer Support Associate
Pabbly.com
Rate your support