how to convert cell to number in matlab

Question

Putri Basenda Tarigan 2020-11-17

0
链接

此问题的直接链接

https://ww2.mathworks.cn/matlabcentral/answers/650478-how-to-convert-cell-to-number-in-matlab

回答： Rik 2020-11-17

Hello everyone,

I'm beginner in matlab. Could somebody help me on this:

I read my data as cell array from excel, where in one box in excel it contains two numbers, like 3;4

so it's read by matlab as c = {'3;4'}

I tried str2double function, but the result become NaN.

How to overcome this problem?

Thanks in advance.

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

请先登录，再进行评论。

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

Answer 1

Rik 2020-11-17

1
链接

此回答的直接链接

https://ww2.mathworks.cn/matlabcentral/answers/650478-how-to-convert-cell-to-number-in-matlab#answer_546873

在 MATLAB Online 中打开

str2double returns NaN because '3;4' is not a number, it is two numbers. You need to split the text into different numbers first. One of the many ways to do that is this:

c = '1,,-3.1;+4e2';%modified to cover more representations of numbers
%a number can only contain 0-9, a dot, a minus, a plus, or an E
%remove the * if you don't want multiple delimiters to be merged
split_values = regexp(c,'[^0-9\.\-+eE]*','split');
str2double(split_values)
ans = 1×3
    1.0000   -3.1000  400.0000