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

    Filter

    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],

      '*Apple*',

      '*Orange,*',

      '*Grape,*',

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

       

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

      '*Lemon*',

      '*Lime,*',

      '*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!