MATLAB: Converting a timetable to a matrix

converting timetable to matrix

Consider the following table
TimeStamp            X1        X2        X3        X4  
  ____________________    ______    ______    ______    ______
  03-Jan-2005 01:08:00    1.9193    1.9193    1.9193    1.9193
  03-Jan-2005 01:13:00    1.9193    1.9193     1.906     1.906
I tried converting it back to a matrix in order to get the following format:
732315  108  1.9193000  1.9193000  1.9193000  1.9193000
732315  113  1.9193000  1.9193000  1.9060000  1.9060000
Somehow I get an error with the following code:
TT=timetable2table(F);
numformat = datevec(TT.TimeStamp);
since_midnight=numformat(:,4)*60+numformat(:,5);
temp=regexp(TT.Timestamp,'\s+', 'split');
datecol=cellfun(@(C)C{1},temp,'uniform',0);
formatfreak='dd/mm/yyyy';
serialdates = datenum(char(datecol),formatfreak);
every=[sum(:,2),sum(:,3),sum(:,4),sum(:,5)];
matrix=cell2mat(every);
everyfull=[serialdates(:),since_midnight(:)];
x=[everyfull,matrix];
Error:
Error using regexp
The 'STRING' input must be either a char row vector, a cell array of char row vectors, or a string

Best Answer

TT.TimeStamp is in datetime() or duration() format for a timetable() object.
daynumbers = floor(datenum(TT.TimeStamp));
HM = hour(TT.TimeStamp)*100 + minute(TT.TimeStamp);
output = [daynumbers(:), HM(:), TT{:,:}];
Related Question