Problem with formatting operators - textscan

1 次查看（过去 30 天）

JSL 2013-9-25

0
链接

此问题的直接链接

https://ww2.mathworks.cn/matlabcentral/answers/88257-problem-with-formatting-operators-textscan

I'm trying to bring in some data from a .csv file, but I can't seem to get the formatting operators correct when using textscan(). I'm sure this problem is trivial for someone with more experience. My data is all on one line separated by commas. Format:

XX mins YYYY-MM-DD hh:mm:ss,  XX mins YYYY-MM-DD hh:mm:ss,  XX mins YYYY-MM-DD hh:mm:ss,

Example data:

26 mins 2013-09-17 09:01:45,  29 mins 2013-09-18 16:53:12,  33 mins 2013-09-19 18:24:27,

After using fopen to open the file, I am trying to use textscan:

f = fopen('data.csv');
c = textscan(f,????,'Delimiter',',');

I've tried experimenting with different formatting operators at ????, but can't get anything that makes sense. I would like to extract the following as integers:

XX, YYYY, MM, DD, hh, mm, ss

Help?