I have a field that contains email addresses. Many of the email addresses are invalid. I want to filter only valid email addresses where the email address contains "@" and "." in the field.
Is there a formula to do this?
You bet. This'll do it. Setup a filter named Is Valid Email with:
[SIZE=2]instr(".",[EmailAddress])>0 .And. instr("@",[EmailAddress])>0[/SIZE][/code]
The formula will return a value of one (true) if both requirements exist, or a value of zero (false) if either or both do not exist.
Retrieving data ...