MATLAB: Remove nan from table with string and numeric type

Question

Hi,

I have data as cell data type like:

    'HRD_0085'    [  190.7900]
    'HRD_0086'    [   11.6500]
    'WAT_0087'    [       NaN]
etc.

I was trying to apply formula like below in order to get rid of all rows with nan but it doesnt work:

    out = C(any(cellfun(@(x)any(~isnan(x)),C),2),:);

Any clue?

Thanks a lot

Answer 1

C = {
    'HRD_0085'    [  190.7900]
    'HRD_0086'    [   11.6500]
    'WAT_0087'    [       NaN]
};
C(~cellfun(@isnan,C(:,2)),:)