hjenkins Posted August 7, 2003 Share Posted August 7, 2003 Does anybody have a good validation calculation for email address, a bit better than this one: If(PatternCount(email, " "),0, 1) Cheers, Huw. Link to comment Share on other sites More sharing options...
ernst Posted August 7, 2003 Share Posted August 7, 2003 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. Link to comment Share on other sites More sharing options...
-Queue- Posted August 7, 2003 Share Posted August 7, 2003 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," Link to comment Share on other sites More sharing options...
hjenkins Posted August 8, 2003 Author Share Posted August 8, 2003 Works a treat, thanks! Link to comment Share on other sites More sharing options...
Recommended Posts
This topic is 7590 days old. Please don't post here. Open a new topic instead.
Create an account or sign in to comment
You need to be a member in order to leave a comment
Create an account
Sign up for a new account in our community. It's easy!
Register a new accountSign in
Already have an account? Sign in here.
Sign In Now