Table define colums in more columns
2 visualizzazioni (ultimi 30 giorni)
Mostra commenti meno recenti
Frederik Reese
il 6 Mag 2022
Risposto: Frederik Reese
il 6 Mag 2022
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 Commenti
Risposta accettata
Riccardo Scorretti
il 6 Mag 2022
Modificato: Riccardo Scorretti
il 6 Mag 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
However, in my opinion, the point is rather how the original .dat file is imported.
4 Commenti
Più risposte (1)
Vedere anche
Categorie
Scopri di più su Tables in Help Center e File Exchange
Community Treasure Hunt
Find the treasures in MATLAB Central and discover how the community can help you!
Start Hunting!