The best way to combine data types (datetime and numeric) is to use a table. There are several possible approaches. Here is one.
- Load the table
- Use datetime to create Date from first 3 columns. Add hours(column 4) to it to complete datetime
- Create variable for elevation data
- Use table to combine Date and Elev
- Format the date
data = readmatrix("tidal data.txt");
Date = datetime(data(:,1:3)) + hours(data(:,4));
Elev = data(:,5);
T = table(Date,Elev);
T.Date.Format = 'yyyy-MM-DD HH:mm:ss'
