Text contains from Cell | Airtable Community

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

Page 1 / 1

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?

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

Then how about this

IF({A},


  REGEX_MATCH(


    {B},


    "\\b(" & {A} & ")(, |$)"


  ),


  FALSE()


)

Sign up