Skip to main content
Sonya Dhand (Ascential) a posé une question dans #Formulas
Hi

I am using the following to validate an text field has email addresses entered in the correct format.  However I also need to ensure between each email address there is a ; seperator  

The regex I found onlne is :

NOT( REGEX(Custom_email_list__c , "([A-Za-z0-9]+([!⌗$%&'*+-/=?^_`{|}~]*[A-Za-z0-9]+)*@[A-Za-z0-9\\-]+(\\.[A-Za-z0-9\\-]+)*[ ]*[,;]?[ ]*)+" ))

which works well but still works without a ; between email addresses

How do I ensure ; is present and if not it will throw the validation error?

Many thanks in advance
11 réponses