reading text data consisting of a specific format

2 views (last 30 days)
I have a text file containing data of the form:
201901010000
201901010100
201901010200
201901010300
201901010400
201901010500
201901010600
201901010700
201901010800
201901010900
201901011000
...
The data reflect date and time information. I'm trying to figure out a way to read these data in and then parse to a matrix that reflects year, month, day, hour etc. The latter is simple, I'm just stuck on how to read the data in. I have explored both textscan and fscanf but nothing obvious springs to mind. For example, read first 4 numbers = year, 5-6=month etc. Thank you

Accepted Answer

Adam Danz
Adam Danz on 26 Sep 2019
Edited: Adam Danz on 30 Sep 2019
datastr = strsplit(fileread('myTextFile.txt'));
dateMat = datevec(datastr,'yyyymmddHH');
Check that the input format in datevec() describes your datetime format.

More Answers (0)

Community Treasure Hunt

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

Start Hunting!