8 Replies Latest reply: Mar 5, 2017 5:28 PM by Marco Wedel RSS

    Anything Similar to "Contain" function?

    Bradley Qian

      Hi, I am currently trying to be able to create a calculated field in which I can filter whether or not an observation contains a string of characters.


      Fruits Purchased
      Bananas, Apples, Oranges
      Bananas, Apples, Kiwis, Lemons

      Apples, Pears, Oranges


      I would like to only show observations that include at least one of the following: Apples, Oranges.


      Is there a function that can do something similar in the script?


      Thank you very much for taking a look!