Email Validation Calculation

[hjenkins]

Does anybody have a good validation calculation for email address, a bit better than this one:

If(PatternCount(email, " "),0, 1)

Cheers,

Huw.

[ernst]

Hey Huw,

I thought about this one and it seems hard to do this in one calculation.

You could quit easily check on the @ and .

But I'd rather script this and have the entry via a 'custom dialog' followed by a set of 'check'-steps.

Regards,

Ernst.

[-Queue-]

From a post by AndriesV two years ago (and cleaned up a bit):

If(IsEmpty(EmailField), 1,

Case(

PatternCount(EmailField," "), 0,

PatternCount(EmailField,","), 0,

PatternCount(EmailField,";"), 0,

PatternCount(EmailField,":"), 0,

PatternCount(EmailField,"

[hjenkins]

Works a treat, thanks!