how to read a text file as datetime input?

31 views (last 30 days)
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.

Accepted Answer

Walter Roberson
Walter Roberson on 14 Oct 2022
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 Comments
Andi
Andi on 14 Oct 2022
yes, i did but i dont known why datenum values are not competable with other datasets.
Walter Roberson
Walter Roberson on 14 Oct 2022
addtodate is specifically designed to only accept scalar datenum. b=cand_ev(:,jj); selected a vector of datenum entries, so addtodate(b) failed.

Sign in to comment.

More Answers (0)

Categories

Find more on Dates and Time in Help Center and File Exchange

Tags

Products

Community Treasure Hunt

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

Start Hunting!