Separate numerical and txt string into two different strings

2011 11 16
3 个回答
回答已采纳
3 次查看（30 天）

0 个投票

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

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

 采纳的回答

Alexandros
Alexandros 2011-11-16

0 个投票

It looks better but it stills give me
??? Error using ==> textscan First input must be of type double or string.

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

Fangjun Jiang
Fangjun Jiang 2011-11-16
What do you mean? Unless your M_b is different than in your question, it should return the numeric number 1000.
Alexandros
Alexandros 2011-11-16
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
Fangjun Jiang 2011-11-16
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
Alexandros 2011-11-17
This is it man!!!!
Thank you very much

请先登录，再进行评论。

更多回答（2 个）

Alexandros
Alexandros 2011-11-17

0 个投票

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

1 个评论
显示 -1更早的评论 隐藏 -1更早的评论

Alexandros
Alexandros 2011-11-17
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?

请先登录，再进行评论。

类别

在 帮助中心 和 File Exchange 中查找有关 Characters and Strings 的更多信息

标签

Community Treasure Hunt

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

Start Hunting!

Translated by