how to read a text file as datetime input?

29 次查看（过去 30 天）
Andi
Andi 2022-10-14
评论： Walter Roberson 2022-10-14
Hi everyone,
I have a text file with tiem date format YYYY-MM-DD HH:MM:SS. I want to load it and convert it to datenum. Here is what i attempt so far. (data attached)
cd_ev=readmatrix('tt.txt'); % file attached
%Or
t = load('tt.txt','InputFormat','yyyy-mm-dd HH:mm:ss')
%or
rr=readtable('tt.txt', 'Format','yyyy_mm_dd/dd hh:mm:ss');
None of the above serve fro my purpsoe.

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

采纳的回答

Walter Roberson
Walter Roberson 2022-10-14
Ran in:
filename = 'https://www.mathworks.com/matlabcentral/answers/uploaded_files/1156138/tt.txt';
t1 = readtable(filename, 'ReadVariableNames', false);
t1.Properties.VariableNames{1} = 'Date';
t1.Date.Format = 'yyyy_MM_dd/dd HH:mm:ss'; %MM for month, HH for 24 hour hour
%verify
t1.Date(1:5)
ans = 5×1 datetime array
2015_07_10/10 04:43:53 2015_07_18/18 02:57:26 2015_07_27/27 04:59:29 2015_07_27/27 22:15:44 2015_09_13/13 08:23:58
I am having trouble thinking of a good reason to repeat the day like you asked to.
  7 个评论
显示 5更早的评论
Andi
Andi 2022-10-14
yes, i did but i dont known why datenum values are not competable with other datasets.
Walter Roberson
Walter Roberson 2022-10-14
addtodate is specifically designed to only accept scalar datenum. b=cand_ev(:,jj); selected a vector of datenum entries, so addtodate(b) failed.

请先登录，再进行评论。

更多回答（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!

Translated by