Convert Cell array with numeric and non-numeric data into a numeric array.

1 次查看（过去 30 天）
Mike
Mike 2011-6-17
I have a cell array of data pulled from field measurements. This data should be numeric, but it sporadically has non numeric (e.g. "I/O Timeout") text strings in it. I'm loading this into MATLAB via xlsread. I'd like to convert this into a numeric array, and have all of the non-numeric values be converted to "NaN". It seems that this should be a pretty basic thing to do, but I have not found a way to do it yet. Cell2Mat wants every element to be of the same data type.
Thanks for any help.
-Mike A.

请先登录，再回答此问题。

采纳的回答

Fangjun Jiang
Fangjun Jiang 2011-6-17
a={1,2,'timeout',3,4,'i/o'}
b=cellfun(@ischar,a)
a(b)={nan}
c=cell2mat(a)

更多回答（0 个）

类别

在 Help Center 和 File Exchange 中查找有关 Cell Arrays 的更多信息

标签

产品

Community Treasure Hunt

Find the treasures in MATLAB Central and discover how the community can help you!

Start Hunting!

Translated by