Page 1 of 1

Filtering @ in a email

Posted: Sat Mar 12, 2005 5:07 am
by Radha_(Guest)
I would like to check the e-mail addresses for an @ or a comma.____I need to output a report with e-mails having these characters either both or one of the above.____How do I get about checking for these character in an e-mail address.____Would appreciate anyone^s help on this.____Regards

=> RE: Filtering @ in a email

Posted: Sat Mar 12, 2005 10:31 am
by kfleming
The expression:____IIF(^@^$email or ^,^$email,^Valid email^,^No comma or at sign^)____will print the text Valid email when the field named email contain a , or an @ otherwise it will print the text No comma or at sign)____Kathleen__R&R Support

==> RE: Filtering @ in a email

Posted: Mon Mar 14, 2005 7:01 am
by Radha_(Guest)
Thanks Kathleen.____I have another question.____How do I determine that the field has a alpha numeric value, and within that value that there are at least 4 numeric values?____You have been always there with the answers and I am sure you could get me an answer for this too.____Thanks once again__Radha