Expression Question

[Jon_Marchand]

I have this expression (below) that I need to pull from my Session(s) column text contained in the search or part of the text contained in the search.
So if I search for strings “S1” or “S2” it returns rows that contain either of those searches but only that exact string. I also need that to return rows containing strings “S1, S2”.

Right now it will only return strings that contain “S1” or “S2” not “S1, S2”. Any help is appreciated.

[Steve]

This appears to be a duplicate post.

Search Form Using EnumList: AND vs OR Questions

I have a search form that is using EnumList for a couple of the fields. The issue that I am running into is that the multiple options chosen in the enumlist field are added together as one string and thus searching by spreadsheet for all items containing that combined string. What I would prefer happen is that the search results show all entries containing option 1, option 2, or option 3 related enumlist search field. For example…I have class database with a column Session(s). Classes can be en…