# cell consisting letters and numbers to matrix double

5 views (last 30 days)
Lotte van de Venis on 27 Oct 2017
Commented: Cedric Wannaz on 29 Oct 2017
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.
##### 2 CommentsShowHide 1 older comment
Walter Roberson on 28 Oct 2017
xlswrite('Name Excelfile.xlsx', [num2cell(Group), num2cell(Trail), mTrail], 1)

Cedric Wannaz on 27 Oct 2017
Edited: Cedric Wannaz on 27 Oct 2017
>> 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'}
{'ZED'}
>> data{2}
ans =
8.0000
90.8700
40.0000
Cedric Wannaz on 29 Oct 2017
Does it solve your problem of splitting alpha codes and numbers or do you still have a problem with that?