How to convert a string into a date or datenum?

7 次查看（过去 30 天）
Bruno Carvalho
Bruno Carvalho 2021-6-17
评论： Stephen23 2021-6-18
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
Ran in:
"... 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 个评论
显示 4更早的评论
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 Center 和 File Exchange 中查找有关 Calendar 的更多信息

标签

Community Treasure Hunt

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

Start Hunting!

Translated by