Reading dates/times from a text file
19 views (last 30 days)
Show older comments
I want to read all the dates and times from a text file into an array of serial date numbers.
I've always done this in the past with textread and then parsing the date string.
There seems to be a more elegant way to do this, using readtable, but I'm struggling to make it work.
The format of the lines in the text file is this:
20210824_UTC_06:47:41
How do I read these in, using readtable or some other way?
0 Comments
Answers (1)
Star Strider
on 24 Aug 2021
That is not a straightforward as it would fitst appear.
Try this —
Time = '20210824_UTC_06:47:41'
DT = datetime(Time, 'InputFormat','yyyyMMdd''_UTC_''HH:mm:ss', 'TimeZone','UTC')
DT.TimeZone = '-7' % Convert To: UTC-7:00:00
.
2 Comments
Star Strider
on 25 Aug 2021
My pleasure!
If my Answer helped you solve your problem, please Accept it!
.
See Also
Categories
Find more on Dates and Time 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!