How to read a csv file (with header + ignore some columns)
조회 수: 1 (최근 30일)
이전 댓글 표시
Hello,
I’m in trouble to read a csv file. Here is a sample:
,,,,,,String1[°C], String2[°C], String3[m/s], String4[°C], String5[°C], String6[°C]
,,,,,,Avg, Max, Min, Avg, Max, Min
10/04/2016, 160410 – P10 – AA, “Time,run1”,”BB,Blue”,Turn1,1:50.100,11,100,25,25,55,66
10/04/2016, 160410 – P10 – AA, “Time,run1”,”BB,Blue”,Turn2,1:48.680,22,99,102,56,88,77
10/04/2016, 160410 – P10 – AA, “Time,run1”,”BB,Blue”,Turn3,1:49.100,55,66,123,58,55,88
10/04/2016, 160410 – P10 – AA, “Time,run1”,”BB,Blue”,Turn4,1:49.080,28,33,456,59,44,99
Be careful that “Time,run1” is only one column as well as ”BB,Blue”.
I would like to get an array from this file where the first 2 lines and the first 5 columns are ignored (see below).
1:50.100 11 100 25 25 55 66
1:48.680 22 99 102 56 88 77
1:49.100 55 66 123 58 55 88
1:49.080 28 33 456 59 44 99
I tried csvread and textscan functions but I could not make it work. I don’t want to use Import Wizard function as the file will be loaded within a GUI. Could you help me?
Kind regards,
Sebastien
댓글 수: 0
답변 (1개)
Walter Roberson
2016년 8월 5일
textscan with the %q format specifier, if you have a new enough version of MATLAB. With older MATLAB you would need to use '"%[^"]"' instead of '%q'
댓글 수: 5
Walter Roberson
2016년 8월 6일
R2013a was before the %q or %D specifiers were introduced. "%[^"]" should work for the quoted strings though.
참고 항목
카테고리
Help Center 및 File Exchange에서 Data Import and Export에 대해 자세히 알아보기
Community Treasure Hunt
Find the treasures in MATLAB Central and discover how the community can help you!
Start Hunting!