Return to FileMaker.com
Validation - contains at least one "@" and "."
How would I create a validation rule where the e-mail address field contains at least one @ and one .
Wouldn't that be Exactly one @ and at least one "." to the right of the @?
Let ( [ @p = Position ( self ; "@" ; 1 ; 1 ) ;
pd = Position ( self ; "." ; Length ( self ) ; -1 ) // this is the position of the last . in self
@p and ( @p < pd )
) // Let
Retrieving data ...