Find NaN in a cell array and only delete the NaNs

How can I delete NaN s from a cell array (only the NaN elements not the whole column or row)?

Answer 1

[Matt J]

results(j)= sqrt(  mean(array{j}.^2,'omitnan')  );

[MatlabUser17]

Worked! Thanks!

Answer 2

[madhan ravi]

C(cellfun(@(x)any(isnan(x)),C))=[]

[madhan ravi]

Matrices cannot have holes.

[MatlabUser17]

This deletes everything within a cell. Let me be more clear, let's assume:

matrix=[1,1,3,5;2,NaN,2,2;4,4,4,NaN]
[Mx My]=size(matrix)
for j=1:My;
    
    array{j}=matrix(:,j);
    
% %     array(cellfun(@(x)any(isnan(x)),array))=[]
    
   results(j)=rms(array{j})
end

I want to calculate the RMS within each individual cell without considering NaN in each cell.

Answer 3

[Pruthvi G]

Data(cellfun(@(cell) any(isnan(cell(:))),Data))={''};