String to Datenum Format using opts and Setvaropts

5 次查看（过去 30 天）
Xymbu
Xymbu 2020-9-21
回答： 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.

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

采纳的回答

Star Strider
Star Strider 2020-9-21
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.

更多回答（0 个）

类别

在 Help Center 和 File Exchange 中查找有关 Text Files 的更多信息

标签

产品


版本

R2019a

Community Treasure Hunt

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

Start Hunting!

Translated by