Split column data into two columns

2017 8 2
1 个回答
更新时间：2017 8 3
4 次查看（30 天）

0 个投票

I have a column of data with numbers formatted as a string. All of the 3,000 plus entries are five characters long such as 01234. I would like to split that out into two columns so that one column would be the first two numbers and the other the last three, such as 01 234. I cannot seem to find the right solution for this. Any thoughts?

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

Kellie Anton
Kellie Anton 2017-8-3
编辑：Kellie Anton 2017-8-3
I finally got something to work. I had to take my column out into its own cell array 'goop'.
glop = cellfun(@(x) x(1:2), goop, 'UniformOutput', false);
glup = cellfun(@(x) x(3:end), goop, 'UniformOutput', false);
Honestly, I do not understand why it would not let me do it in the table directly. Instead, it just gives me a column of 2X1 cells.
Anyhow, this will work for my purposes. I just was hoping for something more... efficient.

请先登录，再进行评论。

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

回答（1 个）

Honglei Chen
Honglei Chen 2017-8-2

0 个投票

Could you elaborate what you have as a matrix?
If you are using character arrays, it should just be a 5-column matrix to start with. So all you need to do is just getting the first 2 columns and then last 3 columns. For example
a = ['01234';'12345']
a(:,1:2)
a(:,3:5)
Does this help?

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

Kellie Anton
Kellie Anton 2017-8-2
I tried that earlier... unfortunately, my computer closed MATLAB and I do not have it. The thing is that it did not work, but I was trying to do it right in the table. IOW, what you have as a, I had as A.code from a table with say five variables and 'code' is one such variable. Does that make sense?
Kellie Anton
Kellie Anton 2017-8-3
Here is what I tried this morning...
glop = goop(:,1:2);
Index exceeds matrix dimensions.
goop is a 3283X1 cell.
Honglei Chen
Honglei Chen 2017-8-3
maybe you can try
glop = goop{1}(:,1:2)
HTH

请先登录，再进行评论。

类别

在 帮助中心 和 File Exchange 中查找有关 Resizing and Reshaping Matrices 的更多信息

标签

Community Treasure Hunt

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

Start Hunting!

Translated by