cell consisting letters and numbers to matrix double

1 次查看（过去 30 天）

Lotte van de Venis 2017-10-27

0
链接

此问题的直接链接

https://ww2.mathworks.cn/matlabcentral/answers/363675-cell-consisting-letters-and-numbers-to-matrix-double

评论： Cedric 2017-10-29

Hi,

I have a matrix containing 840x1 cells. These consist of 3 letters followed by numbers. Is there a way to convert this into 840x1 double?

I have tried str2double, but these returns only NaN. I tried several combinations with num2str, char, celstr, but i can't figure it out.

Thanks in advance!

2 个评论
显示无隐藏无

Jan 2017-10-27

Please give any meaningful example. What is the wanted result for 'ABC123'? How do you want to convert this to a number?

Walter Roberson 2017-10-28

xlswrite('Name Excelfile.xlsx', [num2cell(Group), num2cell(Trail), mTrail], 1)

请先登录，再进行评论。

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

回答（1 个）

Cedric 2017-10-27

0
链接

此回答的直接链接

https://ww2.mathworks.cn/matlabcentral/answers/363675-cell-consisting-letters-and-numbers-to-matrix-double#answer_288141

编辑：Cedric 2017-10-27

在 MATLAB Online 中打开

>> C  = {'ABC8', 'CAD90.87', 'ZED40'} ;
>> C2 = cellfun( @(s)s(4:end), C, 'UniformOutput', false ) ;
>> str2double( C2 )
ans =
    8.0000   90.8700   40.0000

EDIT 1: here is a solution that extracts both parts:

>> data = textscan( [C{:}], '%3s%f' ) ;

With that you get

 >> data
 data =
  1×2 cell array
    {3×1 cell}    {3×1 double}
 >> data{1}
 ans =
  3×1 cell array
    {'ABC'}
    {'CAD'}
    {'ZED'}
 >> data{2}
 ans =
    8.0000
   90.8700
   40.0000

4 个评论
显示 2更早的评论隐藏 2更早的评论

Cedric 2017-10-27

Please see my updated answer.

Cedric 2017-10-29

Does it solve your problem of splitting alpha codes and numbers or do you still have a problem with that?

请先登录，再进行评论。

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

类别

MATLAB Language Fundamentals Data Types Data Type Conversion

在 Help Center 和 File Exchange 中查找有关 Data Type Conversion 的更多信息

Community Treasure Hunt

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

Start Hunting!

Translated by