1 Reply Latest reply on Nov 23, 2018 4:26 AM by Ankit Bansal

    Function for searching exact match of value

    Gaytri k

      hi Team,

       

      I'm trying to create a calculated field to find the exact match of the values as below

       

       

      if CONTAINS("JOSHUA_RODRIGUEZ2@xyz.com,JOHN_MULLER1@xyz.com,CHRIS_SALVATORE@xyz.com,

      STEVE_CUNHA@xyz.com,",[Emai2])=TRUE

      THEN [emp ID] ELSE NULL end

       

       

       

       

      but the above formula is returning true for "HA@xyz.com"  which is the email id of some other person. this is returning true because its available in string "STEVE_CUNHA@xyz.com"

       

      Could anyone please help me in making the above formula look for exact match of the email ids?