Filtering @ in a email

[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

[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

[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