Convert cell array to double

Question

0 个投票

Hi guys,

I have a variable called MKVALM2PRSALEM came from

[~,~, MKVALM2PRSALEM] = xlsread('C:\Users\X...\199001.xlsx','Sheet1','M3:X502');

Part of the matrix is like,

Notice that there are nulls like '@NA' and '@CF'.

How can I transfer this matrix into double format like the following picture, and keep all nulls like NaN?

When I tried to use str2double(MKVALM2PRSALEM), it returns a all nulls matrix. Actually I want to have the result like

MKVALM2PRSALEM = xlsread('C:\Users\X...\199001.xlsx','Sheet1','M3:X502');

But I can't directly use that syntax because MKVALM2PRSALEM actually comes from a larger cell array.

0 个评论
显示 -2更早的评论隐藏 -2更早的评论

Answer 1

Jan 2012-7-17

0 个投票

MKVALM2PRSALEM(cellfun(@ischar, MKVALM2PRSALEM)) = {NaN};
ABCDEFGHIJKLM_ = cell2mat(MKVALM2PRSALEM);

Answer 2

Walter Roberson 2012-7-17

0 个投票

MKVALM2PRSALEM(cellfun(@ischar, MKVALM2PRSALEM)) = {NaN};

Xiao Tang 2012-7-17

Thanks Walter. But the format of MKVALM2PRSALEM is still in cell array, rather than double.