Problem with formatting operators - textscan

1 view (last 30 days)
JSL
JSL on 25 Sep 2013
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?

Answers (0)

Categories

Find more on Data Import and Export in Help Center and File Exchange

Tags

Community Treasure Hunt

Find the treasures in MATLAB Central and discover how the community can help you!

Start Hunting!