Help

Save the date! Join us on October 16 for our Product Ops launch event. Register here.

Re: Find a specific word from a "Array Join" field.

Solved
Jump to Solution
985 1
cancel
Showing results for 
Search instead for 
Did you mean: 
Abraham_Bochner
8 - Airtable Astronomer
8 - Airtable Astronomer

Seeking to identify if two numbers match exactly in both fields, such as 22 matching 22, and not partial matches like 2.

Abraham_Bochner_1-1689286292686.png

 

Abraham_Bochner_0-1689286259382.png

Abraham_Bochner_2-1689286309582.png

 

1 Solution

Accepted Solutions
Sho
11 - Venus
11 - Venus

How about REGEX?

REGEX_MATCH(ARRAYJOIN({Above 20%}),"(^|,)"& {Hours Number} &"(,|$)")

See Solution in Thread

2 Replies 2
Sho
11 - Venus
11 - Venus

How about REGEX?

REGEX_MATCH(ARRAYJOIN({Above 20%}),"(^|,)"& {Hours Number} &"(,|$)")

Thank you greatly, this is precisely what I aimed to achieve.