Delete rows that contains []

Hi

I would like to delete rows that contains [ ].

Thanks very much.

[ ] 1 NaN

[ ] 1 NaN

[ ] 1 NaN

[ ] 1 NaN

[ ] 1 0

'o_c' 1 1

'w_c' 1 1

Answer 1

[Andrei Bobrov]

x = {[ ]   1    NaN
[ ]   1    NaN
[ ]   1    NaN
[ ]   1   NaN
[ ]   1   0
'o_c'   1   1
'w_c'   1   1};

out = x(~any(cellfun(@(x)isempty(x),x),2),:);

[Thorsten]

Or

 out = x(~any(cellfun(@isempty,x),2),:)

[Alfonso Lopez]

OMG!! Thanks very much. I was trying to do this almost all morning :)

Answer 2

[Guillaume]

c = {[] 1 NaN
     [] 1 NaN
     [] 1 NaN
     [] 1 NaN
     [] 1 0
     'o_c' 1 1
     'w_c' 1 1};

You get the cells of the cell array that are empty by using isempty on each cell. You can use cellfun to check each cell. You can then use any on each row (2nd dimension) of the cell array to delete rows that have any cell empty:

c(any(cellfun(@isempty, c), 2), :) = []

[Alfonso Lopez]

The same result as Andrei suggestion. Thanks very much too :)