Help

Airtable Cobuilder is here! Learn more about our new no-code app creation feature, powered by AI on the Airtable Academy

Text contains from Cell

Topic Labels: Data
582 3
cancel
Showing results for 
Search instead for 
Did you mean: 
TH
4 - Data Explorer
4 - Data Explorer

I have 2 tables.

Table 1 contains column A

Table 2 contains column B

Now, I want to check if the text appears in Table 1 also appears in a specific cell in Table 2.

For example:

 

Table 1   Table2

text         text, text6, text99

text3

text4

So in this example I will get a TRUE only for 'text' since it's located on Table 2

3 Replies 3
Sho
11 - Venus
11 - Venus

With this formula, only the matched portion can be replaced by TRUE

IF({A},
  REGEX_REPLACE(
    {B},
    "\\b(" & {A} & ")(, |$)",
    "True, "
  ),
  {B}
)

What return value do you want?

Thank you for your reply.

In terms of results I looking to get TRUE/FALSE

Sho
11 - Venus
11 - Venus

Then how about this

IF({A},
  REGEX_MATCH(
    {B},
    "\\b(" & {A} & ")(, |$)"
  ),
  FALSE()
)