Converting a string to datenum format
18 ビュー (過去 30 日間)
古いコメントを表示
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!!
0 件のコメント
回答 (2 件)
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()
0 件のコメント
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 !
0 件のコメント
参考
カテゴリ
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!