How to read a csv file (with header + ignore some columns)
3 次查看(过去 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!