Email Validation

[Lee J]

I'm having difficulty in get a validation calculation working for email addresses. Does anyone now the best way of doing this.

cheers in advance

[AndriesV]

I had a similar issue and attacked it using a case calculation, by now 99% of the email addresses in our database are at least not wrong because of illegal characters or wrong formatting. Whenever I find a new frequent mistake in data entry I add another case step.

- - validation calculation - -

If(IsEmpty(EmailField), 1,

Case(

PatternCount(EmailField," ")>0, 0,

PatternCount(EmailField,",")>0, 0,

PatternCount(EmailField,";")>0, 0,

PatternCount(EmailField,":")>0, 0,

PatternCount(EmailField,"