How to keep certain numbers in a cell array?

Lets say for example I have a cell array A = {1,2,3},{4,5,6},{7,8,9},{10,11,12}. I am then given the string B = [1,3,5,12]. How would I create an output cell array where the numbers which were not mentioned in the string B were removed? i.e ans = {1,3} {5} {12}
Thank you for your time
Nabil

2 Comments

What have you tried so far? Which problems occur?
A = {1,2,3},{4,5,6},{7,8,9},{10,11,12}
This is not a cell array and no valid Matlab code. Please do not let use guess which input you have. Is this:
A = {[1,2,3], [4,5,6], [7,8,9], [10,11,12]}
or
A = {{1,2,3},{4,5,6},{7,8,9},{10,11,12}}
?
my bad its the second one, A = {{1,2,3},{4,5,6},{7,8,9},{10,11,12}}, also the ans would be {{1,3},{5},{12}}
I have tried doing the below:
y = {};
for i = 1:length(A)
C = A{i}
for j = B
if length(intersect(B,C)) == 1
y{end+1} = {intersect(B,C)}
end
end
end

Sign in to comment.

 Accepted Answer

Jan
Jan on 17 Apr 2017
Edited: Jan on 17 Apr 2017
A = {{1,2,3},{4,5,6},{7,8,9},{10,11,12}};
B = [1,3,5,12];
R = cell(size(A));
for iA = 1:numel(A)
v = cat(2, A{iA}{:}); % A{iA} as vector
ex = ismember(v, B);
R{iA} = A{iA}(ex);
end
R = R(~cellfun('isempty', R));
Or:
R = cell(size(A));
iR = 0;
for iA = 1:numel(A)
v = cat(2, A{iA}{:}); % A{iA} as vector
ex = ismember(v, B);
if any(ex)
iR = iR + 1;
R{iR} = A{iA}(ex);
end
end
R = R(1:iR);

2 Comments

I see, I'm not familiar with the ismember function. If you dont mind me asking, would the above code still work if A = {[1,2,3], [4,5,6], [7,8,9], [10,11,12]}? and what would I have to change if I wanted the output ans = {[1,3] [5] [ ] [12]}? is this even possible
To keep the empty matrix in the output, remove the "R = R(~cellfun(..." line from the 1st code. You can try by your own, if the code works for the wanted input.

Sign in to comment.

More Answers (0)

Categories

Asked:

on 17 Apr 2017

Commented:

Jan
on 18 Apr 2017

Community Treasure Hunt

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

Start Hunting!