[SalesForce] Validation Rule for Phone Numbers

I'm trying to create a validation rule for our phone numbers. Every number has 3 parts:

Country Code (numerical, min. 1 digit, max 3 digits, starts with '+')
Area Code (numerical, min. 1 digit, max 4 digits, cannot start with 0)
Number (numerical, no digit limit, cannot start with 0)

Examples:

+32 12 1234567

+359 123 1234567899

I checked many examples, unfortunately I cannot find out how to say that every parts' digit numbers should be variable (country code could have min. 1 and max. 3 digits) and cannot start with 0

Best Answer

The solution I just came with:

NOT(REGEX(Phone,"[+]\d\d?\d?\s\d\d?\d?\d?\s\d+"))

Explaination:

[+] (the obligatory "+" at the beginning)

Country Code:

\d\d?\d? (min 1 digit, max. 3 digits)

\s (whitespace)

Area Code

\d\d?\d?\d? (min 1 digit, max. 4 digits)

\s (whitespace)

Number

\d+ (min 1 digit)

Related Solutions

[SalesForce] Validation rule for phone number

This should do the trick given the requirements:

NOT(REGEX(Phone, "[0-9+\\-\\(\\)]*"))

But it will allow for some funky phone numbers that are definitely not valid, e.g. "+123-+()()()"

[SalesForce] Validation Rule for Phone Number that should only contain numbers and +

There is already another answer with shorter solution but I still wanted to answer. Below validation rule should work for your situation, too.

OR( 
OR( 
LEN( Phone ) <= 9 , 
LEN( Phone ) >= 13 
), 
NOT( 
OR( 
REGEX(Phone, "[0-9 ]+"), 
REGEX(Phone, "\\+[0-9 ]+")) 
) 
)

Best Answer

Related Solutions

[SalesForce] Validation rule for phone number

[SalesForce] Validation Rule for Phone Number that should only contain numbers and +

Related Topic