cell consisting letters and numbers to matrix double
1 次查看(过去 30 天)
显示 更早的评论
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
编辑:Cedric
2017-10-27
>> 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 个评论
Cedric
2017-10-29
Does it solve your problem of splitting alpha codes and numbers or do you still have a problem with that?
另请参阅
类别
在 Help Center 和 File Exchange 中查找有关 Creating and Concatenating Matrices 的更多信息
Community Treasure Hunt
Find the treasures in MATLAB Central and discover how the community can help you!
Start Hunting!