MATLAB: Delete rows from a subset of rows of a mixed cell array

delete rowsnan

I have a mixed 6×7 cell array
A = {'text' 12 NaN 14 'text' 16 17; 'text' 0 NaN 24 25 26 27; 31 32 33 34 35 0 'text'; NaN 42 43 44 45 46 0; 51 'text' 53 54 NaN 56 57; 61 62 0 64 65 NaN 67};
How do I delete the rows from 2 to 5 that have one or more cells in columns 3 to 6 equal to NaN or zero? The remaining rows should be rows 1, 4 and 6. Rows 1 and 6 should remain because, even if they have NaNs or zeros in columns 3 to 6, they should not be considered for elimination, and row 4 should remain because it does not have NaNs or zeros in columns 3 to 6. Thanks!

Best Answer

   keep=~any(  cellfun(   @(c)isequal(c,0)|isequaln(c,nan)  , A(:,3:6) )  , 2); 
   keep([1,end])=1;
B=A(keep,:)
Related Question