String to Datenum Format using opts and Setvaropts

Question

Xymbu 2020-9-21

0
链接

此问题的直接链接

https://ww2.mathworks.cn/matlabcentral/answers/597445-string-to-datenum-format-using-opts-and-setvaropts

回答： Star Strider 2020-9-21

I have read in a table using readtable() and am trying to convert on of the columns to datetime as it is currently a string in the format of the data.

My datetime format looks like...

20200721T145002Z

in which the format looks like yyyyMMdd'T'HHmmss'Z'

when i try to use

opts = setvaropts(opts, 'time','DatetimeFormat', 'yyyyMMdd HHmmss ');

or any combination with the T and Z markers it kicks back an error.

Im not an expert with how i need to format this so any help would be appreciated.

0 个评论
显示 -2更早的评论隐藏 -2更早的评论

请先登录，再进行评论。

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

Answer 1

Star Strider 2020-9-21

1
链接

此回答的直接链接

https://ww2.mathworks.cn/matlabcentral/answers/597445-string-to-datenum-format-using-opts-and-setvaropts#answer_498112

在 MATLAB Online 中打开

Try reading those in as strings, then doing the conversion later:

t = repmat('20200721T145002Z', 5, 1);                                                   % Create Data
T1 = table(compose('%s',t));                                                            % Create Table
T1.Var1 = datetime(T1{:,1}, 'InputFormat','uuuuMMdd''T''HHmmssZ','TimeZone','UTC')      % Convert To Datetime

Alternatively, you can try it with setvaropts, using the 'InputFormat' string I use here. If that does not work, read it in as a string and then do the converstion.