Table define colums in more columns

1 次查看（过去 30 天）
Frederik Reese
Frederik Reese 2022-5-6
回答： Frederik Reese 2022-5-6
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.

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

采纳的回答

Riccardo Scorretti
编辑：Riccardo Scorretti 2022-5-6
Ran in:
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 个评论
显示 2更早的评论
Frederik Reese
Frederik Reese 2022-5-6
yes it works. thanks a lot
have a nice weekend

请先登录，再进行评论。

更多回答（1 个）

Frederik Reese
Frederik Reese 2022-5-6
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

类别

在 Help Center 和 File Exchange 中查找有关 Spreadsheets 的更多信息

标签

Community Treasure Hunt

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

Start Hunting!

Translated by