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:
'*Pear*',), 'Tasty Fruits')
'*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.
Thanks for the reply. I have tried this. However, by adding the comma before the asterisk, I would be unable to check if the last item in the list is a part of the filter due to it not having a comma after it. Would anything else work?