[SalesForce] Regex validation for Phone Number

I am trying to create a validation rule for US format number and using the following regex Validation

NOT(REGEX(Phone, "\\D*?(\\d\\D*?){10}"))

The above seems like a standard regex which will only allow saving for (000) 000-0000 format number.

However, if I enter characters in the following format
(000) 000-0000yyy. It is still allowing save.

Best Answer

You can try the below one as this could make sure that the phone contains only numbers.

NOT( OR( ISBLANK(Phone), REGEX( Phone,"(\\D?[0-9]{3}\\D?)[\\s][0-9]{3}-[0-9]{4}")))

Related Solutions

[SalesForce] Regex Validation rule for telephone number

I would recommend a two step approach. First keep your length restrictions on hold and go and find a well tested working solution for phone numbers. You don't have to reinvent the wheel:

try as formula then something like:

NOT(  
  REGEX( SamplePhone__c, "^\\+([0-9 ]+)$" ) 
  &&  LEN(  SUBSTITUTE(SamplePhone__c , " ", "")   ) < 26  
  &&  LEN(  SUBSTITUTE(SamplePhone__c , " ", "")   ) > 6 
)

Replace the regex to the one of your choice and use nested SUBSTITUE(...) to remove other character you don't want to count against your Min and Max.

The idea is to decouple the regex and the length checks and combine them logically.

[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-+()()()"

Best Answer

Related Solutions

[SalesForce] Regex Validation rule for telephone number

[SalesForce] Validation rule for phone number

Related Topic