remove [NaN] from cell array

I have large cell arrays in which a couple of entries could not be read from an excel file, since the corresponding places are empty. In my cell array I obtain: [NaN]

now I wish to replace this with an empty string: ''

this is what I tried and got:

>> raw(cellfun(@isnan,raw)) = {''};
Error using cellfun
Non-scalar in Uniform output, at index 1, output 1.
Set 'UniformOutput' to false.

>> raw(cellfun(@isnan,raw,'UniformOutput',false)) = {''};
Error using subsindex
Function 'subsindex' is not defined for values of class 'cell'.

suggestions?

[Jan]

Please post a relevant part of the cell raw such that we can reproduce the problem.

Answer 1

[Titus Edelhofer]

Hi,

if your raw contains both strings and NaN, you will need to do something like this:

raw(cellfun(@(x) isnumeric(x) && isnan(x), raw)) = {''};

If your raw contains numbers only, I would convert to an array (cell2mat) and then use isnan directly.

Titus

[Michiel]

thank you, the first is what I was looking for