Converting a string to datenum format

19 次查看（过去 30 天）
Malavan Subramaniam
Malavan Subramaniam 2019-10-28
回答： Shubham Gupta 2019-10-29
So I have a dataset that presents dates as strings (example: "2011-08-31T21:16:01.948Z"). My question is how do I convert this string into a datenum format? I feel like the 'T' and the 'Z' might make things more complicated. Also, how would I do this for every date in the dataset?
I am very new and bad with Matlab, so please provide as simple as an explanation that you can! That would be greatly appreciated! :)
Thank you!!

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

回答（2 个）

Walter Roberson
Walter Roberson 2019-10-29
Use datetime() to parse the string and then datenum() the results.
In most cases you are better just using the datetime object without datenum()
Shubham Gupta
Shubham Gupta 2019-10-29
Try:
DateString = '2011-08-31T21:16:01.948Z';
RepExp = '[a-zA-Z]'; % want to replace any alphabet, indicated by [a-zA-Z]
RepStr = ' '; % Replace by blank space
DateString_Up = regexprep(DateString,RepExp,RepStr); % Updated date string
DateNumber = datenum(DateString_Up); % Convert it to datenum
Let me know if you have doubts !

类别

在 Help Center 和 File 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