Compare to tables, one with strings and one without

[Anonymous]

Hello,

I have two tables one with Strings in some cells divided by delimiters " / " and another Table to compare it to without strings.

Table 1:

Table 2:

The problem I have, is that i don't want to split the first table into new rows by delimiter becuase I get to many variations ( last time i tried over 50 million in my case). Normaly I merge both tables to find the difference between them.

Is it possible to compare the rows of the two table without spliting the cells  of the first table into new rows?

Best

[Anonymous]

This, to me, boils down to comparing strings. And the sub-question to your problem is - do you need an exact match between the tables, or are you happy with partial match. 

Another thing - can you do a merge of the tables, in a way that you can compare apples to apples (i.e. Car chassis number) - see the example below:

[Anonymous]

I need to find the exact rows of table 2 which are not present in table 1.

I my example it would be the second row of tabe 2 (car, blue, 200KW, 10)