Split column in table

1 次查看(过去 30 天)
Dion Theunissen
Dion Theunissen 2022-7-22
编辑: Ruger28 2022-7-22
Hi.
I have the folowing table:
I want to split column 7 in 1 column only letters, and 1 column only the numbers. Anyone who can help me?
So 2 new columns. Column 13 will be LH, column 14 will be 0989.

采纳的回答

Ruger28
Ruger28 2022-7-22
编辑:Ruger28 2022-7-22
This isn't the cleanest, but it works. I'm assuming that you always have some combination of 2 letters and then any amount of numbers after it.
TableNames = {'ID','Value'};
ID_Vals = [1;2];
Values = {'LH 1234';'QR1234'};
MyTable = table(ID_Vals,Values,'VariableNames',TableNames);
% Extract column and split it
ColVals = table2cell(MyTable(:,2));
SplitVals(:,1) = regexp(ColVals,'\w\w','match','once'); % look for 2 letters only
SplitVals(:,2) = regexp(ColVals,'\d+','match','once'); % look for a series of numbers only
% Add to table
MyTable.Letters = SplitVals(:,1); % place in table with the name Letters
MyTable.Numbers = SplitVals(:,2); % place in table with the name Numbers

更多回答(0 个)

类别

Help CenterFile Exchange 中查找有关 Matrix Indexing 的更多信息

产品


版本

R2022a

Community Treasure Hunt

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

Start Hunting!

Translated by