Search and delete row from cell array

3 views (last 30 days)
andrew
andrew on 12 Jun 2013
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
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
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);

Community Treasure Hunt

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

Start Hunting!