I need to build a phone validation rule meeting the below format. Can someone help with the REGEX?
Country Code +47
Min 8
Max 8
The phone number should always start with +47, always have 8 digits and no spaces.
Thanks!
Nicole
답변 3개
Try below
OR(
NOT( BEGINS(phone, '+47') ),
LEN(Phone) <> 8,
CONTAINS(phone, " ")
)
