3 Replies Latest reply: Aug 15, 2017 10:58 AM by Wes Browning RSS

    IF statement to match string within field

    Wes Browning

      I've been trying many ideas but no luck and hoping the community can assist. 

       

      I am wanting to "look" within a field and when I match a particular string of characters, in this case "IBM", return a "Yes" text string into my table.  Something like:

       

      =IF[(Field) Contains string(IBM), Return "Yes"]

       

      I know that's not proper syntax but hoping writing out the logic conveys my goals better.

       

      Any help greatly appreciated!  Thanks... Wes