Search and delete row from cell array
Show older comments
I have a m x n cell array. I want to search the 6th column for empty cells and delete the entire row with the emtpy cell.
Answers (2)
Hugo
on 12 Jun 2013
Suppose that C is your cell array
Cnew=C; %Just for not losing original values
Cnew(cellfun(@(x)isempty(x),C(:,6)),:)=[];
Does this work for you?
Youssef Khmou
on 12 Jun 2013
try this example :
% gievn your cell C
%A=cell2mat(C);
% simulating your data
A=randn(10);
A(4,6)=0; % zero
A(7,6)=0; % zero
B=A(:,6); % the 6th column
[index]=find(B==0);
% deleting the corresponding rows
A(index)=[];
C=mat2cell(A);
Categories
Find more on Cell Arrays in Help Center and File Exchange
Community Treasure Hunt
Find the treasures in MATLAB Central and discover how the community can help you!
Start Hunting!