Remove missing from cell array

I have used readcell to read tabular data.

How can the missing elements be removed?

  6×1 cell array

    {'a'    }
    {'b'     }
    {'c'  }
    {'d'  }
    {1×1 missing}
    {1×1 missing}

[Stephen23]

You should probably use ismissing:

https://www.mathworks.com/help/matlab/ref/ismissing.html

https://www.mathworks.com/help/matlab/data_analysis/missing-data-in-matlab.html

[Gian Pietro Luca]

But how? I tried the obvious rmmissing(cellarray) and it fails with:

Error using matlab.internal.math.ismissingKernel/arraySwitch (line 79)
First argument must be numeric, logical, datetime, duration, calendarDuration, string, categorical, char, cellstr, table,
or timetable.

Answer 1

[madhan ravi]

yourcell(cellfun(@ischar,C))

[madhan ravi]

Read this once again

Try the above see if it satisfies your need else show what missing data contains

since I don’t know because I’m not at the latest stand.

Use 'isempty' instead of @ischar if missing contains an empty scalar.

[Gian Pietro Luca]

Thanks. It is helpful and seems to work but, is it the "standard" way to deal with missing parameters? It seems a bit overbloated: A=A(cellfun(@ischar,A)). Also, if I have a mixture of numbers and strings, it might not work, right?

[Andreas Martin]

Yes, in that case it doesn't work. Try then this instead:

C( cellfun( @(c) isa(c,'missing'), C ) ) = {[]};