Here's a custom function I ran across the other on Brian Dunning's site:
Hope this helps.
ASPEN LANE TECHNOLOGY
From: alagu123 <firstname.lastname@example.org>
Date: Wednesday, 9 May, 2012 9:36 AM
To: Jeff Penner <email@example.com>
Subject: Email Validation Help
created by alagu123 <https://fmdev.filemaker.com/people/alagu123> in
Scripting and Calculations - View the full discussion
Hi All, I have a field Email and when I enter the values other than email
format in this field, it need to show error for wrong input. Any one can
suggest me. Thanks
Reply to this message by replying to this email -or- go to the message on
FileMaker Technical Network
<https://fmdev.filemaker.com/message/81426#81426> Start a new discussion in
Scripting and Calculations by email
aker.com> or at FileMaker Technical Network
Manage your email preferences
FileMaker Developer Conference 2012 Miami, Florida July 16-18
Matt Navarre uses this in his custom function DataType ( Stuff ) on Brian Dunning's site:
PatternCount (stuff ; "@" ) = 1 and PatternCount (stuff ; ".") ≥ 1 ; "email"
Thanks a lot to all ! It's working fine in the end.... !!!
Thanks a lot Jeff... it's working fine....!!