How do I filter rows of a cell based on an empty column

Say I have a 100x100 cell. I want to get all the rows where the 8th column is empty (equal to []), and also all the rows where the 8th column is not empty. These would be two separate variables.

How would I go about doing this?

Answer 1

[Akira Agata]

Similarly to your previous question, the code will be like:

% 100x100 sample cell array with randomly located empty cells 
C = num2cell(randi(10,100,100));
idx = cellfun(@(x) isequal(x,3), C);
C(idx) = {''};

% Rows where the 8th column is empty
idx = cellfun(@isempty, C(:,8));

% Extract the target rows
C1 = C(idx,:);

% Others
C2 = C(~idx,:);