2 Replies Latest reply on Sep 27, 2010 11:28 AM by rjlevesque

    Email verification

    rjlevesque

      Title

      Email verification

      Post

      What's the best method to authenticate the format of an email address? To be sure it is "email@somewhere.com" and not obscure code, etc. I assume filtering would be possible too based on a value list perhaps for example to prevent things like any emails with "bulk" or "porn" or "list" in the address.

        • 1. Re: Email verification
          philmodjunk

          The @ test is the easy part.

          PatternCount ( EmailField ; "@" ) = 1  will return true if there's one and only one @ in the email address.

          PatternCount ( Right ( EmailField ; 4 ) ; "." ) > 0 is a possible test for a . suffix (.com, .net, .org. , .us , .Uk ...) at the end of your email field, assuming there is no additional text such as a person's name following the email address.

          Similier tests with PatternCount could be used to identify emails with porn, list, xxx etc in them for filtering out or possibly flagging them for human examination.

          • 2. Re: Email verification
            rjlevesque

            awesome thanks!