Find matching entries in cell array

10 次查看（过去 30 天）
Seb
Seb 2017-7-17
评论： Walter Roberson 2017-7-18
If I have a cell array full of character arrays, I want to return a cell array of all the items that are common between all columns. For example:
Sample data:
example{1,1}{1,1} = 'a'
example{1,1}{2,1} = 'b'
example{1,1}{3,1} = 'c'
example{1,2}{1,1} = 'a'
example{1,2}{2,1} = 'b'
example{1,3}{1,1} = 'x'
example{1,3}{2,1} = 'b'
example{1,3}{3,1} = 'a'
I then want to return a Nx1 cell array with the values that match between all items, so it would return [a,b] - (order is not important).
The example data must be assumed to be any size.
I have tried strcmp and a few other methods but cant get my head around it! Any help appreciated.
  2 个评论
John
John 2017-7-17
In the example you provided, "a" and "b" are not common to all. example{1,4} does not contain those values.
Can you clarify what you are trying to achieve?
Seb
Seb 2017-7-18
sorry that was a mistake, disregard those two bottom lines of code

请先登录，再进行评论。

请先登录，再回答此问题。

采纳的回答

Walter Roberson
Walter Roberson 2017-7-17
result = example{1,1};
for K = 2 : numel(example)
result = intersect(result, example{K}, 'rows');
end
At the end, only the items in common with everything will be left. But as John points out, that will be empty.
  3 个评论
显示 1更早的评论
Seb
Seb 2017-7-18
just note: it throws a warning: The 'rows' input is not supported for cell array inputs.
Just wondering if this is fine/any way to resolve this...?

请先登录，再进行评论。

更多回答（0 个）

类别

在 Help Center 和 File Exchange 中查找有关 Matrices and Arrays 的更多信息

标签

Community Treasure Hunt

Find the treasures in MATLAB Central and discover how the community can help you!

Start Hunting!

Translated by