Checking Syntax of A Particular Field
FMP 10 - Beginning User
Mac OSX 10.6.2
I have a database that contains an email field.
I want to check that field to make sure all the emails at least fit into the firstname.lastname@example.org syntax where it can be any amount of characters before the "@", any amount of characters before the "." and the "." is followed by exactly 3 characters or a ".tv".
And once I check that how can I look at the records that don't match to assess whether they should be deleted?
Thank you very much.