You need to sign in to do that
Don't have an account?
Alex Christensen 1
Need help with an RGEX Validation Rule
I am trying to create a validation rule to prevent users from leaving first or last name blank or entering in anything aside from alphabetical values. The rule works however I need to allow for spacing. Can someone identify what I need to remove from the formula to allow for spacing?
REGEX(FirstName, ".*([^a-zA-Z]+|\\s{2,}).*") || REGEX(LastName, ".*([^a-zA-Z]+|\\s{2,}).*")
REGEX(FirstName, ".*([^a-zA-Z]+|\\s{2,}).*") || REGEX(LastName, ".*([^a-zA-Z]+|\\s{2,}).*")
Try the below formula will work.
If this helps,Please mark it as best answer.
Thanks,
Ankaiah