How to convert a string into a date or datenum?

3 次查看(过去 30 天)
I have a column, about [4000 x 1] with the format 'yyyymmddHH'. Yes, all the numbers are together.
And i need to get a date, or a datenum from that, but i cant, since functions like datetime need the numbers separated.
Anyone know how to get arround this?
Thank you.

回答(1 个)

Stephen23
Stephen23 2021-6-17
编辑:Stephen23 2021-6-17
"... but i cant, since functions like datetime need the numbers separated."
I don't see that restriction mentioned anywhere in the DATETIME documentation.
S = ["2021061701";"2021010100";"1913061423"]
S = 3×1 string array
"2021061701" "2021010100" "1913061423"
D = datetime(S, 'InputFormat','yyyyMMddHH')
D = 3×1 datetime array
17-Jun-2021 01:00:00 01-Jan-2021 00:00:00 14-Jun-1913 23:00:00
  6 个评论
Bruno Carvalho
Bruno Carvalho 2021-6-18
If you can, answer again in a seperate answer so i can accept your answer
Stephen23
Stephen23 2021-6-18
@Bruno Carvalho: you can accept this answer, if one of the comments includes the solution.

请先登录,再进行评论。

类别

Help CenterFile Exchange 中查找有关 Dates and Time 的更多信息

Community Treasure Hunt

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

Start Hunting!

Translated by