Skip to Content

Information Steward Email Validation not working

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

Add comment
10|10000 characters needed characters exceeded

  • Get RSS Feed

1 Answer

  • Best Answer
    May 21 at 08:50 AM

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

    Add comment
    10|10000 characters needed characters exceeded

    • Thank you Eric, it's working good :)