Skip to main content
Sonya Dhand (Ascential) 님이 #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개
  1. 2017년 8월 21일 오후 12:24
    Hi Sonya,

    May I request you please check with below links from the community forums which will point you in the right direction.

    Hope this helps.

    Please mark this as solved if it's resolved.

    Thanks,

    Nagendra