Search any from list pasted in text control

[Guillaume_Bardon]

Dear coda community,
I am stuck with the following problems:

i would like to create a text control called “Omnisearch” and a table with a column called “search_col”
the search_col is already lowered and is a list of values lowered as such:
List(
thisRow.ASIN.Lower(),
thisRow.[Product ID].Lower(),
thisRow.[Material Code].Lower(),
thisRow.[EAN-13]
)
I would like some help creating a filter formula, that filters on any of the partial matches found in any of the list in the search_col

Any help on this is greatly appreciated

[Ryan_Hubbard1]

I think this will do what you’re looking for

Basically split the search by space, join them together with the “|” character and then use that text to do a RegexMatch against the search_col

I modified it in your doc (hope you don’t mind) and commented out the original filter.

So if you search for “b00d 7263” it will grab 2 rows instead of 0:

[Ryan_Hubbard1]

@Guillaume_Bardon did that solve the problem for you or still need help?

[Guillaume_Bardon]

That is exactly what I was trying to do, thank you!!!