Reading dates/times from a text file

3 views (last 30 days)
dormant
dormant on 24 Aug 2021
Commented: Star Strider on 25 Aug 2021
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?

Answers (1)

Star Strider
Star Strider on 24 Aug 2021
That is not a straightforward as it would fitst appear.
Try this —
Time = '20210824_UTC_06:47:41'
Time = '20210824_UTC_06:47:41'
DT = datetime(Time, 'InputFormat','yyyyMMdd''_UTC_''HH:mm:ss', 'TimeZone','UTC')
DT = datetime
24-Aug-2021 06:47:41
DT.TimeZone = '-7' % Convert To: UTC-7:00:00
DT = datetime
23-Aug-2021 23:47:41
.
  2 Comments
Star Strider
Star Strider on 25 Aug 2021
My pleasure!
If my Answer helped you solve your problem, please Accept it!
.

Sign in to comment.

Categories

Find more on Dates and Time in Help Center and File Exchange

Products


Release

R2021a

Community Treasure Hunt

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

Start Hunting!

Translated by