Separate numerical and txt string into two different strings

Hello people

I have a string M_b = '1000 km' and I want to separated to M_b1 = 1000 (a numerical string) and to M_b2 = km (a text string).

To tell the truth only M_b1 is of importance for me. But the data comes from an excel and by using xlsread I can only transfer the data to matlab as txt.

I tried multiple things without any success like: M_b1 = str2num('M_b') [M_1b,M_2b] = strread('M_b', %s) [M_1b,M_2b] = strread (sprintf('M_b'), %s) M_b1 = textscan(M_b,'%s')

I am new to matlab but I can learn fast Thank you for your time

Answer 1

[Alexandros]

It looks better but it stills give me

??? Error using ==> textscan First input must be of type double or string.

[Fangjun Jiang]

What do you mean? Unless your M_b is different than in your question, it should return the numeric number 1000.

[Alexandros]

Like I have define M_b as

[M_b, M_b] = xlsread ('1.xls', 2, D14)

this gives me M_b = 1000 km

And normally your command should function but it doesn't want to happen :P. Maybe I should not included as a txt from the beginning but then nothing will enter the M_b variable

[Fangjun Jiang]

I would not use the same variable 'M_b' for the two return arguments. It can be done but it's confusing. Maybe you just have a typo. [M_b, M_b] = xlsread ('1.xls', 2, D14).

Anyway, M_b most likely is a cell array, so you need to do M_b1 = textscan(M_b{1},'%f')

[Alexandros]

This is it man!!!!

Thank you very much

Answer 2

[Fangjun Jiang]

You are close.

M_b = '1000 km';
M_b1 = textscan(M_b,'%f')

Answer 3

[Alexandros]

But now it gets more complecated

I have a string

A = xlsread('1.xls', 1, 'D12') A = 'Audi A4 Avant FTSI Flex Man 1984cc 132kw Euro5A [AI002]'

Now i want

A1 = 'Audi'

A2 = ' A4 Avant FTSI Flex Man'

A3 = '1984' without the cc

A4 = '132' without the kw

A5 = 'Euro5A'

Is this separation doable? and if it is how it can be done? I think is too complex

[Alexandros]

I did

B = strread (A{1}, '%s')

But it gives me

??? Error using ==> dataread

Badly formed format string.

Error in ==> strread at 51

[varargout{1:nlhs}]=dataread('string',varargin{:});

Normaly it should work. Any ideas?