email address check

[mwmark]

Does anyone have a routine to check a string to see if it looks like a valid email address. example: does it have a "@" in it are there spaces or other invalid email Characters?

 

[synapsevampire]

Try something like:

instr({table.field},"@") > 0
and
instr({table.field}," ") = 0
and
instr("@drphil.com",{table.field}) = 0
// nobody should ever write dr phil
and
...etc..

-k