How to ignore additional columns when reading a file using textscan?

Question

yashvin 2015-6-16

0
链接

此问题的直接链接

https://ww2.mathworks.cn/matlabcentral/answers/223981-how-to-ignore-additional-columns-when-reading-a-file-using-textscan

评论： Walter Roberson 2016-5-19

采纳的回答： Ingrid

pscreentime.png

在 MATLAB Online 中打开

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 个评论
显示无隐藏无

yashvin 2015-6-16

trial1.csv

Find attached the trial1.csv file

Walter Roberson 2016-5-19

Your csv file does not include any seconds.

请先登录，再进行评论。

请先登录，再回答此问题。

Answer 1

Ingrid 2015-6-16

2
链接

此回答的直接链接

https://ww2.mathworks.cn/matlabcentral/answers/223981-how-to-ignore-additional-columns-when-reading-a-file-using-textscan#answer_182823

just type doc textscan and you can find this there. So you need to add the * after the % sign for data that you do not want to read in

1 个评论
显示 -1更早的评论隐藏 -1更早的评论

Iain 2016-5-18

Also using %*[^\n] at the end of the formatting string allows you to skip to the end of the line which I think is what you were asking about "not define these additonal columns"

请先登录，再进行评论。