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

    Email verification



      Email verification


      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

          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

            awesome thanks!