FavoritosLaura Gil (Privat) publicou em Salesforce Developer/ Admin/ Consultant (Originalmente perguntado por Laura Gil)14 de set. de 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 #IntegrationMostrar maisAdicionar um comentárioEscrever um comentário...NegritoItálicoSublinhadoTachadoLista com marcadoresLista numeradaAdicionar linkBloco de códigosInserir imagemAnexar arquivosURL do linkCancelarSalvar0/9000Responder
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 #IntegrationMostrar mais