4 Replies Latest reply: Apr 6, 2017 1:11 PM by Bradley Qian RSS


    Bradley Qian

      Hi, I am currently using wildmatch to create a filter that searches a specific column for the presence of a number of strings.


      for example, the column would be called Fruits and a value inside of it would look like


      Apple, Pear, Peach, Orange, Apple Pear


      Currently, I have several filters with the following codes:

      If(WildMatch([Fruit$.Fruit Type],




      '*Pear*',), 'Tasty Fruits')


      If(WildMatch([Fruit$.Fruit Type],



      '*Apple Pear,*'), 'Decent Fruits')


      I would like to be able to filter and only show things that are 'Tasty Fruits' . However, in the case of Apple and Apple Pear, the Tasty Fruits Filter would pick up Apple Pear as Apple due to the asterisks.


      Is there any way to fix this problem? Thanks!