Find sub-content differences between 2 cells

pohrt

Hello all, 

I have 2 cells in each row with values that are separated by commas (see simplified example). I need to compare the content and find the differences.

The real examples are longer (up to 200 comma delimiters) and I have something like 40 - 300 rows that have these strings.

I was thinking that I could

1) use the TEXT to COLUMN PARSE tool (since the delimiter is always a comma) to spread the Data A and Data B out to more columns

2) then I somehow need to compare each Column from Data A with each Column from Data B

3) I need to do this for each of the rows individually

4) I was hoping to get a result that gives me the a) COMMON Values and then the b) Additional Values for Data A and the c) Additional Values for Data B

I played with transform and Joint Match ... but I am not getting to a solution where I can do this comparison easily for a larger number of values and more rows .....

Does anyone else has an idea???

Thanks so much already,

petra

Qiu

@pohrt 
How about something like this.

I sepearte the data stream to 2 and use Text To Columns given the delimeter is always ','.

1018-pohrt.yxmd