How to split a table column into two seperate columns

68 次查看（过去 30 天）
Cem Akinci
Cem Akinci 2022-5-2
评论： Star Strider 2022-5-2
I have a table which looks like this:
I want to split column a into two seperate columns from the delimiter "\" such that first column will be like 'AIVA-100' and the other column will be '01_Test.....'.
I want to do this for every element in column a. In the end, i will have 2 columns with the elements of column a.
I tried to iterate through the table and split using the delimiter but i couldn't do it

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

采纳的回答

Star Strider
Star Strider 2022-5-2
Ran in:
The regexp function works with cell arrays easily —
C = {'AIVA-100\something'; 'AIVA-75\something else'};
Cs = regexp(C,'\','split')
Cs = 2×1 cell array
{1×2 cell} {1×2 cell}
Cs{1}
ans = 1×2 cell array
{'AIVA-100'} {'something'}
Cs{2}
ans = 1×2 cell array
{'AIVA-75'} {'something else'}
Cs = cellfun(@(x)split(x,'\'), C, 'Unif',0) % The 'split' Function Requires 'cellfun'
Cs = 2×1 cell array
{2×1 cell} {2×1 cell}
Cs{1}
ans = 2×1 cell array
{'AIVA-100' } {'something'}
Cs{2}
ans = 2×1 cell array
{'AIVA-75' } {'something else'}
.
  4 个评论
显示 2更早的评论

请先登录，再进行评论。

更多回答（2 个）

Dyuman Joshi
Dyuman Joshi 2022-5-2
Ran in:
y = {'AIVA_1\abc';'AIVA_12\def';'AIVA_123\xyz'}
y = 3×1 cell array
{'AIVA_1\abc' } {'AIVA_12\def' } {'AIVA_123\xyz'}
z=split(y,'\')
z = 3×2 cell array
{'AIVA_1' } {'abc'} {'AIVA_12' } {'def'} {'AIVA_123'} {'xyz'}
column1 = z(:,1)
column1 = 3×1 cell array
{'AIVA_1' } {'AIVA_12' } {'AIVA_123'}
column2 = z(:,2)
column2 = 3×1 cell array
{'abc'} {'def'} {'xyz'}
  1 个评论
Cem Akinci
Cem Akinci 2022-5-2
Firstly, thank you for your reply.
The elements in column a are cells and not a cell array, hence i cannot use the split function for those. Do you know how can i convert those cells into a cell array?

请先登录，再进行评论。

Matt Butts
Matt Butts 2022-5-2
Not super elegant, but you could use something like:
t = table() % your table
% Split by tokens to grab the first part of a and put it back into a, put
% the remainder in new_a
[t{:,'a'},t{:,'new_a'}] = strtok(t{:,'a'},'\');
% Get rid of the leading delimiter in new_a and put the results back into
% new_a
t{;,'new_a'} = strtok(t{:,'new_a'},'\');

类别

在 Help Center 和 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