How to remove cells in cell matrix that are a certain value?

Hello,

I have a 8x4 cell matrix that looks like:

1x761200 double 1x121400 double 1x299600 double 1x555000 double

1x761200 double 1x121400 double 1x299600 double 1x555000 double

1x761200 double 1x121400 double 1x299600 double 1x555000 double

1x761200 double 1x121400 double 1x299600 double 1x555000 double

-1 -1 -1 -1

-1 -1 -1 -1

1x761200 double 1x121400 double 1x299600 double 1x555000 double

1x761200 double 1x121400 double 1x299600 double 1x555000 double

I would like to find which rows contain '-1' and then remove those rows from the matrix.

Any suggestions?

Answer 1

[Rik]

data(all(cellfun('prodofsize',data)==1),:)=[];

You might need to specify the dimension for the all function (writing of mobile, so no testing). You might also mean the any function instead of all.

Edit:

This does indeed require a modification:

L=all(cellfun('prodofsize',data)==1,2)
%                                  ^^
data(L,:)=[]

[Dc215905]

Thanks. Unfortunately it still shows up empty.

When I try using any() i get an error:

The logical indices in position 1 contain a true value outside of the array bounds.

The closest I can get to is:

data((cellfun('prodofsize',data)==1))

Though, this just returns a 8x1 cell matrix containing {[-1]} in each cell, which isn't very useful

[Rik]

Let's try with a simple example (and the dimension changed, I really should learn the syntax some day..).

data={...
    [1 2],[1 2],[1 2];...
    -1   ,-1   ,1    ;...
    [1 2],[1 2],[1 2]};
L=all(cellfun('prodofsize',data)==1,2)

L = 3×1 logical array
   0
   1
   0

data(L,:)=[]

data = 2×3 cell array
    {[1 2]}    {[1 2]}    {[1 2]}
    {[1 2]}    {[1 2]}    {[1 2]}

[Dc215905]

Thank you! That works great!