deleting all the empty rows

Dear all,

I have

[N,T,R]]=xlsread(name);

I want to erase all the empty rows in T.

I suggest

T( all(cellfun(@isempty,T),2), : ) = [];

Am i correct?

[per isakson]

YES

[antonet]

cheers per

[Stephen23]

A little speed-up that is sometimes worth keeping in mind:

T(all(cellfun('isempty',T),2),:) = [];

There are some special cases (which run faster), where the functions can be supplied as a string. See the cellfun docs for more info.

Answer 1

[Greg Heath]

I don't think MATLAB allows empty rows or columns

>> A = [ 1 2 3; [] [] [] ; 7 8 9 ]

 A =     1     2     3

         7     8     9

>> A = [ 1 [] 3; 4 [] 6; 7 [] 9 ]

 A =  1     3

      4     6

      7     9

>> A = [ [] 2 3; 4 [] 6; 7 8 [] ]

 A =  2     3

      4     6

      7     8

Hope this helps.

Greg

[Nirmal]

T in this case is cell array not the matrix and the cell can have empty string.

[Greg Heath]

Correct:

>> A = { 1 2 3; [] [] [] ; 7 8 9 }, B = { 1 [] 3; 4 [] 6; 7 [] 9 }, C = { [] 2 3; 4 [] 6; 7 8 [] }

 A = [1]    [2]    [3]
     []     []     []
    [7]    [8]    [9]

 B = [1]    []    [3]
    [4]    []    [6]
    [7]    []    [9]

 C = []    [2]    [3]
    [4]     []    [6]
    [7]    [8]     []