# Search any from list pasted in text control

**URL:** <https://connect.superhuman.com/t/search-any-from-list-pasted-in-text-control/50307>\
**Category:** Ask the Community\
**Created:** [July 31, 2024, 1:41pm UTC](https://connect.superhuman.com/t/search-any-from-list-pasted-in-text-control/50307 "2024-07-31T13:41:35Z")\
**Posts on this page:** 5\
**Page:** 1

<div class="post-metadata">

**Author:** ![Guillaume\_Bardon](https://yyz1.discourse-cdn.com/coda1/user_avatar/connect.superhuman.com/guillaume_bardon/32/40919_2.png) [@Guillaume\_Bardon](https://connect.superhuman.com/u/Guillaume_Bardon)\
**Post date:** [July 31, 2024, 1:41pm UTC](https://connect.superhuman.com/t/search-any-from-list-pasted-in-text-control/50307/1 "2024-07-31T13:41:35Z")

</div>

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

https://coda.io/embed/Hy8OHz8BL2?viewMode=embed

Any help on this is greatly appreciated 😀

---

<div class="post-metadata">

**Author:** ![Ryan\_Hubbard1](https://yyz1.discourse-cdn.com/coda1/user_avatar/connect.superhuman.com/ryan_hubbard1/32/42122_2.png) [@Ryan\_Hubbard1](https://connect.superhuman.com/u/Ryan_Hubbard1)\
**Post date:** [July 31, 2024, 5:05pm UTC](https://connect.superhuman.com/t/search-any-from-list-pasted-in-text-control/50307/2 "2024-07-31T17:05:26Z")

</div>

I think this will do what you’re looking for

 ![image](https://global.discourse-cdn.com/coda1/original/3X/1/e/1ef8c232aa3ef964760aee53555702f395f7e398.png)

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:

 ![image](https://global.discourse-cdn.com/coda1/original/3X/e/b/eb48a48bc8844c1ac9d1d70a2a8c927370f1b6b5.png)

---

<div class="post-metadata">

**Author:** ![Ryan\_Hubbard1](https://yyz1.discourse-cdn.com/coda1/user_avatar/connect.superhuman.com/ryan_hubbard1/32/42122_2.png) [@Ryan\_Hubbard1](https://connect.superhuman.com/u/Ryan_Hubbard1)\
**Post date:** [August 5, 2024, 2:26pm UTC](https://connect.superhuman.com/t/search-any-from-list-pasted-in-text-control/50307/3 "2024-08-05T14:26:27Z")

</div>

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

---

<div class="post-metadata">

**Author:** ![Guillaume\_Bardon](https://yyz1.discourse-cdn.com/coda1/user_avatar/connect.superhuman.com/guillaume_bardon/32/40919_2.png) [@Guillaume\_Bardon](https://connect.superhuman.com/u/Guillaume_Bardon)\
**Post date:** [August 6, 2024, 8:28am UTC](https://connect.superhuman.com/t/search-any-from-list-pasted-in-text-control/50307/4 "2024-08-06T08:28:18Z")

</div>

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

---

<div class="post-metadata">

**Author:** ![system](https://yyz1.discourse-cdn.com/coda1/user_avatar/connect.superhuman.com/system/32/24484_2.png) [@system](https://connect.superhuman.com/u/system)\
**Post date:** [August 9, 2024, 8:29am UTC](https://connect.superhuman.com/t/search-any-from-list-pasted-in-text-control/50307/5 "2024-08-09T08:29:00Z")

</div>

This topic was automatically closed 3 days after the last reply. New replies are no longer allowed.