1 Reply Latest reply on Nov 29, 2009 5:33 PM by comment_1

    Checking Syntax of A Particular Field

    bodhibrian

      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.