table import in more columns

2022 5 10
1 个回答
回答已采纳
更新时间：2022 5 12
2 次查看（30 天）

0 个投票

Hi,
its me again :(
I have a big table like the one attached.
I don't know how to change the columns.
Instead of one bis I'd like this:
Time Distance 1 WSPL 1 Distance 2 Wspl 2 Distance 3 WSPL 3 .....
Arc 2, Z, Time: 0 00:00:00 0.000 450.280 0.260 450.285 1.468, 450.274 2,798, 450,275 3,999, 450,310 .....
.
.
.
Thanks a lot for your help.
Slowly I get better and better....

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

 采纳的回答

Mathieu NOE
Mathieu NOE 2022-5-10

0 个投票

hello
maybe this will help you to get your data as you want :
load('ModellDDOKLL2table.mat')
C = table2array(ModellDDOKLL2table);
CC = split(C,[" ",", "]); % double delimiters split
CC(1:10,1:10) % show first 10 columns of first 10 rows
ans = 10×10 string array
" Arc 2" "Z" "Time: 0 00:00:00" "0,000" "450,280" "0,260" "450,285" "1,468" "450,274" "2,798"
" Arc 2" "Z" "Time: 0 00:00:10" "0,000" "450,280" "0,260" "450,285" "1,468" "450,274" "2,798"
" Arc 2" "Z" "Time: 0 01:00:00" "0,000" "450,280" "0,260" "450,285" "1,468" "450,274" "2,798"
" Arc 2" "Z" "Time: 0 02:00:00" "0,000" "450,280" "0,260" "450,285" "1,468" "450,274" "2,798"
" Arc 2" "Z" "Time: 0 03:00:00" "0,000" "450,280" "0,260" "450,285" "1,468" "450,274" "2,798"
" Arc 2" "Z" "Time: 0 04:00:00" "0,000" "450,280" "0,260" "450,285" "1,468" "450,274" "2,798"
" Arc 2" "Z" "Time: 0 05:00:00" "0,000" "450,280" "0,260" "450,285" "1,468" "450,274" "2,798"
" Arc 2" "Z" "Time: 0 06:00:00" "0,000" "450,280" "0,260" "450,285" "1,468" "450,274" "2,798"
" Arc 2" "Z" "Time: 0 07:00:00" "0,000" "450,280" "0,260" "450,285" "1,468" "450,274" "2,798"
" Arc 2" "Z" "Time: 0 08:00:00" "0,000" "450,280" "0,260" "450,285" "1,468" "450,274" "2,798"

更多回答（0 个）

类别

在 帮助中心 和 File Exchange 中查找有关 Operators and Elementary Operations 的更多信息

标签

Community Treasure Hunt

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

Start Hunting!

Translated by