FavoriteLaura Gil (Privat) posted in Salesforce Developer/ Admin/ Consultant (Originally asked by Laura Gil)Sep 14, 2021, 1:06 PMLaura GilCan 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: NumbersAllow: Characters such as '+', spaces, parenthesis '(', ')', '/', '-'Allow: Character '+' should be only at the beginning of the phone number not in the middle or at the endSo, 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. #REGEX #Salesforce Developer #Sales Cloud #Service Cloud #Nonprofit #Automation #IntegrationShow MoreAdd a commentWrite a comment...BoldItalicUnderlineStrikethroughBulleted ListNumbered ListAdd linkCode blockInsert imageAttach filesLink URLCancelSave0/9000Reply
Laura GilCan 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: NumbersAllow: Characters such as '+', spaces, parenthesis '(', ')', '/', '-'Allow: Character '+' should be only at the beginning of the phone number not in the middle or at the endSo, 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. #REGEX #Salesforce Developer #Sales Cloud #Service Cloud #Nonprofit #Automation #IntegrationShow More