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.

       

      ie:
      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!