Split table entry into separate columns

2022 1 6
1 个回答
更新时间：2022 1 6
5 次查看（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'

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

回答（1 个）

Simon Chan
Simon Chan 2022-1-6

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'})

类别

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

产品

版本

R2021b

标签

Community Treasure Hunt

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

Start Hunting!

Translated by