Reading numbers from alphanumeric strings in a cell matrix

Hi ppl, i am reading a text file consisting of various lines of alpha-numeric strings...

N010 G00 X0 Y0 Z0 N020 G01 X-10 Y10 Z-1 N030 G01 X20 Y40 Z-1 N040 G04 X3 Y3 Z10 M03

Now I need all numerical values of X, i.e. -10,20,3. The problem I am facing is that the strings are read from text file as 'cell' vector and i have to convert them to 'char' to use 'regexp' using '\w*X\w*'....this works, but does not allow the negative number to be read because it starts with a '-'. What to do now??? can anybody help?? I am using MATLAB 2010

[Matt Fig]

What about the 0? You say you need the numeric values beside the X, but don't list zero...

[shapes]

I'd like to carry the zero as well, but the actual numeric value is what I want to extract. And the thing is when the text file is read, it takes on line as an entity, so it is not ['N010' 'G01' 'X-10' 'Y20' 'Z5'] but ['N010 G01 X-10 Y20 Z5']...so first i break them into char, then parse but still the negative numbers are not read..

[Matt Fig]

See my comment on my answer below.

Answer 1

[Matt Fig]

X = {'N010' 'G00' 'X0' 'Y0' 'Z0' 'N020' 'G01'...
     'X-10' 'Y10' 'Z-1' 'N030' 'G01' 'X20' 'Y40'...
     'Z-1' 'N040' 'G04' 'X3' 'Y3' 'Z10' 'M03'};

N = cellfun(@str2double,regexp([X{:}],'(?<=X)-*\d+','match'))

[shapes]

thankyou for ur attention, i have a querry about ur proposed method...i have explained that in answer of your comment...please see that

[Matt Fig]

If you have:

X = ['N010 G00 X0 Y0 Z0 N020 G01 X-10 Y10',...
     'Z-1 N030 G01 X20 Y40 Z-1 N040 G04 X3 Y3 Z10 M03']

Then simply use:

N = cellfun(@str2double,regexp(X,'(?<=X)-*\d+','match'))

[shapes]

Thank you very much sir..I really appreciate it... this works, I am using it for my Y and Z values as well now and it is working. Thanks again!

Answer 2

[Azzi Abdelmalek]

A={'N010' 'G00' 'X0' 'Y0' 'Z0' 'N020' 'G01' 'X-10' 'Y10' 'Z-1' 'N030'} 
y=cell2mat(cellfun(@(x) str2num(cell2mat(regexp(x,'-?[0-9]','match'))),A,'un',0))

[shapes]

thankyou for ur response...but there is this thing, the thing is when the text file is read, it takes one line as an entity, so it is not ['N010' 'G01' 'X-10' 'Y20' 'Z5'] but ['N010 G01 X-10 Y20 Z5']...so first i break them into char, then parse but still the negative numbers are not read..

[Azzi Abdelmalek]

A={' N010 G00 X0 Y0 Z0 N020 G01 X-10 Y10 Z-1 N030 G01 X20 Y40 Z-1 N040 G04 X3 Y3 Z10 M03'}
y=regexp(x,'-?[0-9,.]','match')
out=cell2mat(cellfun(@(x) str2num(cell2mat(x)),y,'un',0))

[shapes]

thanks again, the decimal is a little out of place but the problem is solved. Thanks again