Information Steward Email Validation not working

[former_member567672]

Hi Guys,

Can you please help with this code in InfoSteward?

BEGIN IF(match_regex($SMTP_Email, '[a-zA-Z0-9_\-]+@([a-zA-Z0-9_\-]+\.)+(com|org|edu|nz|au|COM|co.uk|.co.uk|net)', 'CASE_INSENSITIVE'))

RETURN TRUE;

ELSE RETURN FALSE;

END

The problem is that the rule doesn't return emails like (ANDREWCOATH@EPICPUBS. or / MANAGER@CORNE or MJP_HOWELLS80@YAHOO.C ) .

I'm using ADR6, LFA1,KNVV tables joined in a view.

Thank you

Mihai

[MFZhuang · Accepted solution]

return (match_regex($SMTP, '^[a-z0-9_-]+(\.[_a-z0-9-]+)*@[a-z0-9-]+(\.[a-z0-9-]+)*(\.[a-z]{2,4})$','CASE_INSENSITIVE'));

[former_member567672 · Accepted solution]

Thank you Eric, it's working good 🙂