Split column in table

8 views (last 30 days)
Dion Theunissen
Dion Theunissen on 22 Jul 2022
Edited: Ruger28 on 22 Jul 2022
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.

Accepted Answer

Ruger28 on 22 Jul 2022
Edited: Ruger28 on 22 Jul 2022
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

More Answers (0)




Community Treasure Hunt

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

Start Hunting!