Emails Domains

[pablomind]

Hi Im trying to write an expression where I ensure there are no blank fields. All with correct corporate address or "NO MAIL".

I have a table with corporate address (@domain1.com, @domain2.com, etc) with one column called [email_domains.Allow_domains]

So far I have this:

=SUM(IF(Len(Email)<1 ,1,0) ) to ensure there are no blank fields.

How can I look the domains and count the wrong ones?? In script would be with WHERE but in expression dont work that statement.

Any help?

Thank you for your time,

Pablo

[swuehl · Accepted solution]

Maybe something like

If( Exists( [email_domains.Allow_domains], '@' & Subfield(Email, '@', 2) ),1,0)

[pablomind]

Thank you this helped me a lot.