Extract numbers from cell array

3 views (last 30 days)
Hi,
I have a cell array with both numbers and 'NA' strings for missing values.
Now I want to convert the cell array to a pure number array to use it for calculations, keeping all numbers and setting the 'NA' to NaN.
What would be the easiest way to achieve that?
Best regards,
Chris

Accepted Answer

Walter Roberson
Walter Roberson on 16 Apr 2012
A(cellfun(@ischar,A)) = {NaN};
Amat = cell2mat(A);

More Answers (0)

Categories

Find more on Data Types 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!