Skip to Content
0
May 17, 2018 at 09:13 AM

Information Steward Email Validation not working

168 Views

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