+ Start a Discussion
Rashed Yaqubi 10Rashed Yaqubi 10 

Validation Rule with Regex Statement: 10digit numbers separated by commas

Hey guys, there is a text field that I want to restrict so it only accepts 10 digit phone numbers separated by commas. 

So far I have this, but it does not specify how many digits the numbers must be.  So it allows any number of digits separated by commas (i.e. 123,12,1234,12345,etc).  But I want to restrict it to comma separated 10-digit numbers (i.e. 4161231234,6470987657,9051231234,etc…).  I know I need a “{10}” somewhere, but can’t seem to figure out where. 

Your help is greatly appreciated.

Best Answer chosen by Rashed Yaqubi 10
Alain CabonAlain Cabon


All Answers

AnudeepAnudeep (Salesforce Developers) 
See Common REGEX Validation

American Phone Number (no extension) is 10 digits


Rashed Yaqubi 10Rashed Yaqubi 10
Thanks Anudeep, but that does not solve my problem.  I want the user to be able to enter 10-digit numbers (no area code, dashes, brackets or spaces) separated by commas into a TEXT field.
Alain CabonAlain Cabon

This was selected as the best answer
Rashed Yaqubi 10Rashed Yaqubi 10
Thank you Alain, this worked! 

If I wanted to allow spaces after the commas, how would this REGEX statement look? i.e 1231231234, 3213213214, 1231231234, etc..
Alain CabonAlain Cabon
There is exactly one space and always one space:  
NOT(REGEX(Text_Field__c,"^([0-9]{10}?(, |$))+"))

There are no space or many spaces:  
NOT(REGEX(Text_Field__c,"^([0-9]{10}?(,[ ]*|$))+"))

There are at least one space:  
NOT(REGEX(Text_Field__c,"^([0-9]{10}?(,[ ]+|$))+"))

Rashed Yaqubi 10Rashed Yaqubi 10
Super helpful Alain, appreicate it!