AnsweredAssumed Answered

Checking Syntax of A Particular Field

Question asked by bodhibrian on Nov 29, 2009
Latest reply on Nov 29, 2009 by comment_1

Title

Checking Syntax of A Particular Field

Post

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 text@text.com 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. 

Outcomes