how can remove words and split in cellarray in matlab

2018 6 10
1 个回答
回答已采纳
更新时间：2018 6 10
2 次查看（30 天）

0 个投票

for example x={'100614,Peter Beadle,131542'}; i want x= [100614,131542] my dataset have 408934 record like 'x'

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

 采纳的回答

Paolo
Paolo 2018-6-10
编辑：Paolo 2018-6-10

1 个投票

For input:
x = {'100614,Peter Beadle,131542'}
You can use regexp to match numerical entries in your cell. The expression below matches numbers from 0-9 for 6 times since the numbers in your cell have exactly 6 digits.
x={'100614,Peter Beadle,131542'};
[tokens,matches] = regexp(x,'[0-9]{6}','match');
x = str2double(tokens{:});
For input:
x = {'100614','Peter Beadle','131542'}
Use the following:
x = {'100614','Peter Beadle','131542'};
x = str2double(x);
x(isnan(x)) = [];

10 个评论
显示 8更早的评论 隐藏 8更早的评论

Ava persiangulf
Ava persiangulf 2018-6-10
>> x = str2double(tokens{:});
  • Error using str2doubleToo many input arguments.
  • not answered.....why?
Paolo
Paolo 2018-6-10
编辑：Paolo 2018-6-10
Is your x definitely
x={'100614,Peter Beadle,131542'}
and not
x={'100614','Peter Beadle','131542'}
?
Stephen23
Stephen23 2018-6-10
编辑：Stephen23 2018-6-10
str2double only accepts one input argument, so this
str2double(tokens{:})
will not work if tokens contains multiple cells. str2double's one input argument may be cell array, so perhaps you meant to use that:
tokens = vertcat(tokens{:});
str2double(tokens)
Paolo
Paolo 2018-6-10
str2double(tokens{:})
returns the correct array.
str2double(tokens)
returns NaN.
At least on my machine with 2017b. I suspect that her input is not a single cell but rather a cell array.
Ava persiangulf
Ava persiangulf 2018-6-10
yes, tokens contain multiple cells
Paolo
Paolo 2018-6-10
If your input x is:
x={'100614','Peter Beadle','131542'}
Then use:
x = {'100614','Peter Beadle','131542'};
x = str2double(x);
x(isnan(x)) = [];
If you confirm that's the format of your input, I'll edit my answer.
Ava persiangulf
Ava persiangulf 2018-6-10
thanks for answering,.... What should I do now?
Paolo
Paolo 2018-6-10
@Ava,
I have modified my answer. It now contains a solution for both inputs. If the problem is solved you can accept my answer. Consider perhaps adding the other input to your question.
Ava persiangulf
Ava persiangulf 2018-6-10
编辑：Stephen23 2018-6-10
that's answered for me but make change data in my dataset, for example, x=[8213430049,100573,100614] change to x=[8.213430049100573] .... but your answer was very helpful and thank you very much
Paolo
Paolo 2018-6-10
You are welcome. In that case, try using:
x = [8213430049,100573,100614];
x = num2str(x);
x = strsplit(x,' ');
x = str2double(strcat(x{1}(1),'.',x{1}(2:end),x{2}));
x = 8.213430049100573

请先登录，再进行评论。

更多回答（0 个）

类别

在 帮助中心 和 File Exchange 中查找有关 Data Type Conversion 的更多信息

标签

Community Treasure Hunt

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

Start Hunting!

Translated by