Find a string contains a substring

AppSheet AppSheet Q&A
,
1

I have a column name Keyword1 in one table, which contains a single word in each row and a Title column in another table. I want to highlight the Title if it contains any word from the column Keyword1.

rajtrader_0-1673163854552.png
rajtrader_0-1673163854552.png1169×325 26.7 KB

For that, I used CONTAINS() function, but it seems like it does not work with a list of words and the second parameter of the formula should be a text.

How can we find if a string contains a substring from a list or column?

rajtrader_1-1673163918347.png
rajtrader_1-1673163918347.png975×713 33 KB

1 Like
2

Could you try

ISNOTBLANK(INTERSECT(SPLIT([Title], " "), Keyword[Keyword1]))

2 Likes
3

Thanks, problem solved!

2 Likes
4

You are welcome. Please take a look at the associated functions’ help documents, just in case you have not

SPLIT() - AppSheet Help

INTERSECT() - AppSheet Help

ISNOTBLANK() - AppSheet Help

5

Thanks. I had tried SPLIT, CONTAINS, and FIND functions, but I missed INTERSECT function.

1 Like