Split table entry into separate columns

Syed Tariq

2022 1 6

1 个回答

1 次查看（30 天）

0 个投票

I have a table the first column has a string of the format 'ABBV 09/17/2021 120.00 C'. I want to expand the table to 4 additional columns 'ABBV','09/17/2021','120.00','C'

0 个评论
显示 -2更早的评论隐藏 -2更早的评论

请先登录，再进行评论。

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

Follow Question

回答（1 个）

Simon Chan 2022-1-6

在 MATLAB Online 中打开

0 个投票

How about the following:

Name =  "ABBV 09/17/2021 120.00 C";
Data = "Dummy";
A = table(Name,Data);
A.Name = strsplit(A.Name,' ');
T2 = splitvars(A,'Name','NewVariableNames',{'newName1','newName2','newName3','newName4'})