Table define colums in more columns

1 view (last 30 days)
Hello I have the following problem: When I load data from a .dat file into matlab and create a table from it, matlab doesn't recognize the columns, so all the values ​​are in one column.
Arc 2, Z, Time: 0 00:00:000,260450,285
I would like the table separated as below
Time Distance WSPL
Arc 2, Z, Time: 0 00:00:00 0,260 450,285
Thank you very much for your help.
  3 Comments
Riccardo Scorretti
Riccardo Scorretti on 6 May 2022
We need the original .dat file, not the .mat file.

Sign in to comment.

Accepted Answer

Riccardo Scorretti
Riccardo Scorretti on 6 May 2022
Edited: Riccardo Scorretti on 6 May 2022
Perhaps you need something like this?
load Test_Table.mat
tab = table('Size', [numel(Test_Table) 3], ...
'VariableNames', {'Time', 'Distance', 'WSPL'}, ...
'VariableTypes', {'string', 'double', 'double'});
tm = {} ; dst = [] ; swpl = [];
for n = 1 : size(Test_Table,1)
buffer = char(Test_Table{n,1});
tab.Time(n) = string(buffer(1:27));
tm{n,1} = buffer(1:27);
t = str2num(strrep(buffer(28:end), ',', '.'));
tab.Distance(n) = t(1);
tab.WSPL(n) = t(2);
end
tab
tab = 21×3 table
Time Distance WSPL _____________________________ ________ ______ " Arc 2, Z, Time: 0 00:00:00" 0.26 450.29 " Arc 2, Z, Time: 0 00:00:00" 1.468 450.27 " Arc 2, Z, Time: 0 00:00:00" 2.798 450.27 " Arc 2, Z, Time: 0 00:00:00" 3.999 450.31 " Arc 2, Z, Time: 0 00:00:00" 5.202 450.32 " Arc 2, Z, Time: 0 00:00:00" 6.395 450.34 " Arc 2, Z, Time: 0 00:00:00" 7.591 450.34 " Arc 2, Z, Time: 0 00:00:00" 8.641 450.34 " Arc 2, Z, Time: 0 00:00:00" 9.835 450.35 " Arc 2, Z, Time: 0 00:00:00" 10.757 450.35 " Arc 2, Z, Time: 0 00:00:00" 11.942 450.33 " Arc 2, Z, Time: 0 00:00:00" 12.897 450.3 " Arc 2, Z, Time: 0 00:00:00" 15.207 450.52 " Arc 2, Z, Time: 0 00:00:00" 15.483 450.53 " Arc 2, Z, Time: 0 00:00:00" 15.707 450.53 " Arc 2, Z, Time: 0 00:00:00" 15.93 450.54
However, in my opinion, the point is rather how the original .dat file is imported.
  4 Comments

Sign in to comment.

More Answers (1)

Frederik Reese
Frederik Reese on 6 May 2022
Here is the excel table. for this short List I can convert it in exel, but for the size I have I can't open it in excel. Is it possible to convert it, while loading it ?
Thanks

Categories

Find more on Tables in Help Center and File Exchange

Community Treasure Hunt

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

Start Hunting!