You need to sign in to do that
Don't have an account?
Miramo
Regex validation rule help
Hi,
I am close but trying to write a validation rule on mobile number.
Mobile should begin with a + and then the country code (below is 44) and then after the country code it should only allow the number 7 and error if any other numbers are entered.
So far I have th ebelow but its allowing any number after the +44
NOT(REGEX(MobilePhone, "^(\\+44)?[1-9]{2}[7]{1}.*?")),
example number is +44787446352
Thanks
I am close but trying to write a validation rule on mobile number.
Mobile should begin with a + and then the country code (below is 44) and then after the country code it should only allow the number 7 and error if any other numbers are entered.
So far I have th ebelow but its allowing any number after the +44
NOT(REGEX(MobilePhone, "^(\\+44)?[1-9]{2}[7]{1}.*?")),
example number is +44787446352
Thanks
Thanks for your help but its still allowng me to save the mobile number incorrectly
Example UK mobile number is +447837726152
The validation rule must force the +44 first and then the next number must be a 7
its 11 digits long
my version allows any number after the +44
NOT(REGEX(MobilePhone, "^(\\+44)?[1-9]{2}[7]{1}.*?")),
Thanks