PARSE_PHONE
** The PARSE_PHONE function takes a phone number string and returns the phone number in the E.164 general format.**
This function takes a string that represents a phone number and returns a properly formatted E.164 phone number string satisfying The Phone Variable Data Type requirements.
The region parameter is an optional two-digit country code that can be provided in case the phone string itself does not include a country code. If this parameter is omitted, the input phone number string must include the country code. If the input string contains a country code, the region parameter will be ignored.
If the input phone number string cannot be parsed into a valid phone number, the PARSE_PHONE function will return NULL.
Declaration
Parameters
phone_number_string (required, type: string) The string to parse the phone from.
region (optional, type: string) A two-character country code to be used phone_number_string
Return Values
phone (type: phone) The resulting E.164 formatted phone number, or NULL if phone_number_string does not represent a valid phone number.
Examples
Parsing a string that is already in E.164 format will produce the same string.
Additional characters in the input string will be stripped. In the following example all spaces, as well as the trailing "ext. 5" portion of the string, will be removed leaving just the E.164 formatted phone number.
When a phone number cannot be parsed, the PARSE_PHONE function will return NULL.
If a phone number has been collected from a user, it may not be in an E.164 format. The string "7167762323" is ambiguous without a country code as it may belong to more than one.
However, when the country code is known, it can be provided as a hint.
Note, however, that this is just a hint. If the input phone number does include a country code, that country code will take precedence as in this example with an Australian phone number.
Supported Country Codes
AF
Afghanistan
+93
AL
Albania
+355
DZ
Algeria
+213
AS
American Samoa
+1684
AD
Andorra
+376
AO
Angola
+244
AI
Anguilla
+1264
AQ
Antarctica
+672
AG
Antigua and Barbuda
+1268
AR
Argentina
+54
AM
Armenia
+374
AW
Aruba
+297
AU
Australia
+61
AT
Austria
+43
AZ
Azerbaijan
+994
BS
Bahamas
+1242
BH
Bahrain
+973
BD
Bangladesh
+880
BB
Barbados
+1246
BY
Belarus
+375
BE
Belgium
+32
BZ
Belize
+501
BJ
Benin
+229
BM
Bermuda
+1441
BT
Bhutan
+975
BO
Bolivia
+591
BA
Bosnia and Herzegovina
+387
BW
Botswana
+267
BR
Brazil
+55
IO
British Indian Ocean Territory
+246
VG
British Virgin Islands
+1284
BN
Brunei
+673
BG
Bulgaria
+359
BF
Burkina Faso
+226
MM
Myanmar
+95
BI
Burundi
+257
KH
Cambodia
+855
CM
Cameroon
+237
CA
Canada
+1
CV
Cape Verde
+238
KY
Cayman Islands
+1345
CF
Central African Republic
+236
TD
Chad
+235
CL
Chile
+56
CN
China
+86
CX
Christmas Island
+61
CC
Cocos Islands
+61
CO
Colombia
+57
KM
Comoros
+269
CG
Republic of the Congo
+242
CD
Democratic Republic of the Congo
+243
CK
Cook Islands
+682
CR
Costa Rica
+506
HR
Croatia
+385
CU
Cuba
+53
CW
Curacao
+599
CY
Cyprus
+357
CZ
Czech Republic
+420
DK
Denmark
+45
DJ
Djibouti
+253
DM
Dominica
+1767
DO
Dominican Republic
+1809
DO
Dominican Republic
+1829
DO
Dominican Republic
+1849
TL
East Timor
+670
EC
Ecuador
+593
EG
Egypt
+20
SV
El Salvador
+503
GQ
Equatorial Guinea
+240
ER
Eritrea
+291
EE
Estonia
+372
ET
Ethiopia
+251
FK
Falkland Islands
+500
FO
Faroe Islands
+298
FJ
Fiji
+679
FI
Finland
+358
FR
France
+33
PF
French Polynesia
+689
GA
Gabon
+241
GM
Gambia
+220
GE
Georgia
+995
DE
Germany
+49
GH
Ghana
+233
GI
Gibraltar
+350
GR
Greece
+30
GL
Greenland
+299
GD
Grenada
+1473
GU
Guam
+1671
GT
Guatemala
+502
GG
Guernsey
+441481
GN
Guinea
+224
GW
Guinea-Bissau
+245
GY
Guyana
+592
HT
Haiti
+509
HN
Honduras
+504
HK
Hong Kong
+852
HU
Hungary
+36
IS
Iceland
+354
IN
India
+91
ID
Indonesia
+62
IR
Iran
+98
IQ
Iraq
+964
IE
Ireland
+353
IM
Isle of Man
+441624
IL
Israel
+972
IT
Italy
+39
CI
Ivory Coast
+225
JM
Jamaica
+1876
JP
Japan
+81
JE
Jersey
+441534
JO
Jordan
+962
KZ
Kazakhstan
+7
KE
Kenya
+254
KI
Kiribati
+686
XK
Kosovo
+383
KW
Kuwait
+965
KG
Kyrgyzstan
+996
LA
Laos
+856
LV
Latvia
+371
LB
Lebanon
+961
LS
Lesotho
+266
LR
Liberia
+231
LY
Libya
+218
LI
Liechtenstein
+423
LT
Lithuania
+370
LU
Luxembourg
+352
MO
Macau
+853
MK
Macedonia
+389
MG
Madagascar
+261
MW
Malawi
+265
MY
Malaysia
+60
MV
Maldives
+960
ML
Mali
+223
MT
Malta
+356
MH
Marshall Islands
+692
MR
Mauritania
+222
MU
Mauritius
+230
YT
Mayotte
+262
MX
Mexico
+52
FM
Micronesia
+691
MD
Moldova
+373
MC
Monaco
+377
MN
Mongolia
+976
ME
Montenegro
+382
MS
Montserrat
+1664
MA
Morocco
+212
MZ
Mozambique
+258
NA
Namibia
+264
NR
Nauru
+674
NP
Nepal
+977
NL
Netherlands
+31
AN
Netherlands Antilles
+599
NC
New Caledonia
+687
NZ
New Zealand
+64
NI
Nicaragua
+505
NE
Niger
+227
NG
Nigeria
+234
NU
Niue
+683
MP
Northern Mariana Islands
+1670
KP
North Korea
+850
NO
Norway
+47
OM
Oman
+968
PK
Pakistan
+92
PW
Palau
+680
PS
Palestine
+970
PA
Panama
+507
PG
Papua New Guinea
+675
PY
Paraguay
+595
PE
Peru
+51
PH
Philippines
+63
PN
Pitcairn
+64
PL
Poland
+48
PT
Portugal
+351
PR
Puerto Rico
+1787
PR
Puerto Rico
+1939
QA
Qatar
+974
RE
Reunion
+262
RO
Romania
+40
RU
Russia
+7
RW
Rwanda
+250
BL
Saint Barthelemy
+590
WS
Samoa
+685
SM
San Marino
+378
ST
Sao Tome and Principe
+239
SA
Saudi Arabia
+966
SN
Senegal
+221
RS
Serbia
+381
SC
Seychelles
+248
SL
Sierra Leone
+232
SG
Singapore
+65
SX
Sint Maarten
+1721
SK
Slovakia
+421
SI
Slovenia
+386
SB
Solomon Islands
+677
SO
Somalia
+252
ZA
South Africa
+27
KR
South Korea
+82
SS
South Sudan
+211
ES
Spain
+34
LK
Sri Lanka
+94
SH
Saint Helena
+290
KN
Saint Kitts and Nevis
+1869
LC
Saint Lucia
+1758
MF
Saint Martin
+590
PM
Saint Pierre and Miquelon
+508
VC
Saint Vincent and the Grenadines
+1784
SD
Sudan
+249
SR
Suriname
+597
SJ
Svalbard and Jan Mayen
+47
SZ
Swaziland
+268
SE
Sweden
+46
CH
Switzerland
+41
SY
Syria
+963
TW
Taiwan
+886
TJ
Tajikistan
+992
TZ
Tanzania
+255
TH
Thailand
+66
TG
Togo
+228
TK
Tokelau
+690
TO
Tonga
+676
TT
Trinidad and Tobago
+1868
TN
Tunisia
+216
TR
Turkey
+90
TM
Turkmenistan
+993
TC
Turks and Caicos Islands
+1649
TV
Tuvalu
+688
AE
United Arab Emirates
+971
UG
Uganda
+256
GB
United Kingdom
+44
UA
Ukraine
+380
UY
Uruguay
+598
US
United States
+1
UZ
Uzbekistan
+998
VU
Vanuatu
+678
VA
Vatican
+379
VE
Venezuela
+58
VN
Vietnam
+84
VI
U.S. Virgin Islands
+1340
WF
Wallis and Futuna
+681
EH
Western Sahara
+212
YE
Yemen
+967
ZM
Zambia
+260
ZW
Zimbabwe
+263
Last updated
Was this helpful?