Reading dates/times from a text file

14 vues (au cours des 30 derniers jours)
dormant
dormant le 24 Août 2021
Commenté : Star Strider le 25 Août 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?

Réponses (1)

Star Strider
Star Strider le 24 Août 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 commentaires
dormant
dormant le 25 Août 2021
Thank you.
Star Strider
Star Strider le 25 Août 2021
My pleasure!
If my Answer helped you solve your problem, please Accept it!
.

Connectez-vous pour commenter.

Catégories

En savoir plus sur Dates and Time dans Help Center et File Exchange

Produits


Version

R2021a

Community Treasure Hunt

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

Start Hunting!

Translated by