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