Reading dates/times from a text file

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?

Answer 1

[Star Strider]

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

.

[dormant]

Thank you.

[Star Strider]

My pleasure!

If my Answer helped you solve your problem, please Accept it!

.