Hi community,
What i need to do:
Column: “Automatically show any matching Table2 Text” sould display all cell values, that have the same category in in both tables. The issue here is, that the values in column Categories are also not comma seperated.
See image:
Thanks for any help! 
Hey @Isebar_de1 - You can do this by RegexMatch’ing the Categories text in Table1 against each Table2.Categories text like this:
I updated the formula in the doc for you. Does that get you what you need?
Wow i can’t believe it! I thought this will be taking days if not weeks to solve! THANK YOU SOO MUCH!!
@Ryan_Hubbard1 i almost knew, that this was celebrated a bit to fast.
Problem:
In the second table, there can be multiple entries in the category column…
I did update the table.
@Isebar_de1 allowing multiple Categories in Table2 like this…
could create some issues but it all depends on what you’re trying to do. Would “FashionComedy” in table1 match to both row 1 (Fashion, Comedy) and row 2 (Fasion) in Table2 or just row1 (aka all categories in Table2 must match categories in Table1)?
The text in table 2 matches several categories. I need to select all of them. Table 1 then needs to display all the texts, that have matching categories. So every category needs to be looked at individually.
Example: If table1 has Fashion, and a row in table 2 has fashion as well, than display the text of the row of table 2 in table 1.
@Isebar_de1 if you want any category in table 2 to match any part of the text in table 1 (ex: if both Art & Comedy is selected in table2 category and should match against “ComedyFashion” text then you need to match each table2 category against table1 category. You can do this using a regular expression like this:
Check out the New Tables page I created for you. I also adjusted the “Automatically show any matching Table2 Text” column.
