How to ignore additional columns when reading a file using textscan?
Mostrar comentarios más antiguos
I want to extract the 3rd column which contains the time data. I have managed to do it using
if true
f = fopen ('trial1.csv');
C = textscan(f,'%n %n %s','Delimiter',',','HeaderLines', 1)
TimeStamp=C{3}(1)'
DateVector = datevec(TimeStamp)
fclose(f);
end
In the future, I can have additional 50(for eg) new columns. I want to know is there way in matlab such that i do not define these additonal columns which can comprise of string, floating numbers etc. My textscan will become so big! Any other way of extracting the time values in column 3?
2. Secondly, why is my timeStamp value not including the seconds? It is only including until the minutes!
Please find attached the trial1.csv file
2 comentarios
yashvin
el 16 de Jun. de 2015
Walter Roberson
el 19 de Mayo de 2016
Your csv file does not include any seconds.
Respuesta aceptada
Más respuestas (0)
Categorías
Más información sobre Large Files and Big Data en Centro de ayuda y File Exchange.
Community Treasure Hunt
Find the treasures in MATLAB Central and discover how the community can help you!
Start Hunting!
