How to get Matlab to recognize a number string as a date?

Question

Sarah 2011-9-1

0
链接

此问题的直接链接

https://ww2.mathworks.cn/matlabcentral/answers/14933-how-to-get-matlab-to-recognize-a-number-string-as-a-date

评论： Walter Roberson 2018-6-18

Hello everyone,

I am trying to write a Matlab script to automatically update dates within a .txt file. I have a 16 digit number string in the format of yyyymmddhhmmss and I need to get Matlab to read and interpret this number as a date. When I try datenum, datestr, or datevec Matlab doesn't seem to be recognizing the format.

When I use read through the help for the datestr, the closest preset format is yyyymmddTHHMMSS but when I simply add a T to my number string, it is still not recognized.

Any help would be really appreciated as I have been pulling my hair out over this for days. Thanks a lot!

~Sarah :)

1 个评论
显示 -1更早的评论隐藏 -1更早的评论

Sarah 2011-9-1

I am able to pull the information from the text file and have matlab read it as a string, it is just not recognizing it as a date.

请先登录，再进行评论。

请先登录，再回答此问题。

Answer 1

Walter Roberson 2011-9-1

0
链接

此回答的直接链接

https://ww2.mathworks.cn/matlabcentral/answers/14933-how-to-get-matlab-to-recognize-a-number-string-as-a-date#answer_20316

在 MATLAB Online 中打开

datenum(YourString,'yyyymmddHHMMSS')

2 个评论
显示无隐藏无

Sarah 2011-9-1

Thank you, the issue was that I did not capitalize the latter portion of the command. I appreciate the help.

newtomatlab 2016-1-1

That is indeed very helpful.Thanks!

请先登录，再进行评论。

Answer 2

Sean de Wolski 2011-9-1

0
链接

此回答的直接链接

https://ww2.mathworks.cn/matlabcentral/answers/14933-how-to-get-matlab-to-recognize-a-number-string-as-a-date#answer_20294

在 MATLAB Online 中打开

doc datenum

& friends

4 个评论
显示 2更早的评论隐藏 2更早的评论

JAMES MAINA 2018-6-18

编辑：Walter Roberson 2018-6-18

在 MATLAB Online 中打开

 can anyone also assist me how to get date and time from the following
"04.10.201714:20:13:730"
"04.10.201714:20:13:831"
"04.10.201714:20:13:930"
"04.10.201714:20:14:031"
"04.10.201714:20:14:131"
"04.10.201714:20:14:230"
"04.10.201714:20:14:331"
"04.10.201714:20:14:430"
"04.10.201714:20:14:530"
"04.10.201714:20:14:631"

it is in form of month.date.year.time

Walter Roberson 2018-6-18

在 MATLAB Online 中打开

Is that a string() array? Is it a cell array of character vectors each of which happens to begin and end with double-quote? Is that entries in a text file?

If S is a cell array of character vectors that have literal " inside them, then:

datetime(S, 'InputFormat', '"MM.dd.yyyyHH:mm:ss:SSS"')

请先登录，再进行评论。