Problem with formatting operators - textscan
4 views (last 30 days)
Show older comments
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?
0 Comments
Answers (0)
See Also
Categories
Find more on Large Files and Big Data in Help Center and File Exchange
Community Treasure Hunt
Find the treasures in MATLAB Central and discover how the community can help you!
Start Hunting!