How to read a csv file (with header + ignore some columns)
1 vue (au cours des 30 derniers jours)
Afficher commentaires plus anciens
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 commentaires
Réponses (1)
Walter Roberson
le 5 Août 2016
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 commentaires
Walter Roberson
le 6 Août 2016
R2013a was before the %q or %D specifiers were introduced. "%[^"]" should work for the quoted strings though.
Voir également
Catégories
En savoir plus sur Data Import and Export dans Help Center et File Exchange
Community Treasure Hunt
Find the treasures in MATLAB Central and discover how the community can help you!
Start Hunting!