table import in more columns
조회 수: 1 (최근 30일)
이전 댓글 표시
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....
댓글 수: 0
채택된 답변
Mathieu NOE
2022년 5월 10일
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개)
참고 항목
카테고리
Help Center 및 File Exchange에서 Tables에 대해 자세히 알아보기
Community Treasure Hunt
Find the treasures in MATLAB Central and discover how the community can help you!
Start Hunting!