You need to sign in to do that
Don't have an account?
Laura Gil
Can somebody please explain me what this REGEX validation means?
Hi all,
I am trying to build a validation rule with REGEX for the field Phone. The validation rule should check the following:
Allow: Numbers
Allow: Characters such as '+', spaces, parenthesis '(', ')', '/', '-'
Allow: Character '+' should be only at the beginning of the phone number not in the middle or at the end
So, just searching pages with REGEX tutorials but unfortunately I could not find any appropriate in order to also decrypt the following expression literally:
NOT(REGEX(Phone,"(\\D?[0-9]{3}\\D?)[\\s][0-9]{3}-[0-9]{4}") )
No idea what do the following do?:
\\D? (at the beginning and at the end)
{3}
\\s
{4}
I would appreciate if experts in REGEX could give me some guidance here.
I am trying to build a validation rule with REGEX for the field Phone. The validation rule should check the following:
Allow: Numbers
Allow: Characters such as '+', spaces, parenthesis '(', ')', '/', '-'
Allow: Character '+' should be only at the beginning of the phone number not in the middle or at the end
So, just searching pages with REGEX tutorials but unfortunately I could not find any appropriate in order to also decrypt the following expression literally:
NOT(REGEX(Phone,"(\\D?[0-9]{3}\\D?)[\\s][0-9]{3}-[0-9]{4}") )
No idea what do the following do?:
\\D? (at the beginning and at the end)
{3}
\\s
{4}
I would appreciate if experts in REGEX could give me some guidance here.
Please find the below article which gives you explanantion for each and every characters that we use in REGEX formula.
https://www.jadeglobal.com/blog/implementation-regex-salesforce
https://developer.salesforce.com/forums/?id=906F0000000BSpNIAW
If this solution helps, Please mark it as best answer.
Thanks,