Extract data from 800x11 cell to column vector

1 view (last 30 days)
Basically I have an 800x11 cell containing either empty [], text or a scalar value. I am trying to extract the scalar values =/0 from the 6th column and store them in a column vector. I'd then also like to take all of the values = 0 and store them in a column vector also.
This is what I've produced so far, apologies it's my first time ever using Matlab
  4 Comments
Adam Danz
Adam Danz on 18 Jan 2021
Edited: Adam Danz on 18 Jan 2021
Try
% cell named sesl_results
col = 6; % column 6
idx = cellfun(@(c)isscalar(c) && isnumeric(c) && c>0, sesl_results(:,col));
z = [sesl_results{idx,col}];
Owen Gray
Owen Gray on 19 Jan 2021
Thank you so much for all the help! @Adam Danz this worked perfectly, greatly appreciate it!

Sign in to comment.

Answers (0)

Categories

Find more on Interactive Control and Callbacks in Help Center and File Exchange

Community Treasure Hunt

Find the treasures in MATLAB Central and discover how the community can help you!

Start Hunting!