Ajouter aux favorisLaura Gil (Privat) a publié du contenu dans Salesforce Developer/ Admin/ Consultant (Question initialement posée par Laura Gil)14 sept. 2021, 13:06Laura 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 #IntegrationAfficher plusAjouter un commentaireRédiger un commentaire...GrasItaliqueSoulignerBarréListe à pucesListe numérotéeAjouter un lienBloc de codeInsérer une imageJoindre des fichiersURL du lienAnnulerEnregistrer0/9000Répondre
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 #IntegrationAfficher plus