1 Reply Latest reply: May 15, 2014 10:02 AM by Data Kruncher RSS

    Email Validation

    bchao728 _

      I have a field that contains email addresses. Many of the email addresses are invalid. I want to filter only valid email addresses where the email address contains "@" and "." in the field.

      Is there a formula to do this?

        • Email Validation
          Data Kruncher

          You bet. This'll do it. Setup a filter named Is Valid Email with:

          [SIZE=2]instr(".",[EmailAddress])>0 .And. instr("@",[EmailAddress])>0[/SIZE][/code]

           

          The formula will return a value of one (true) if both requirements exist, or a value of zero (false) if either or both do not exist.