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