MATLAB: Separate Date and Time from csv file

separate date and time

I have csv file with a column containing the date and time combined as seen below.

How do I separate the date and time?

10/31/2017 17:27:56

10/31/2017 17:27:59

10/31/2017 17:28 :03

Best Answer

How are you currently reading it in? What does your other data look like? There is a space between then, so as long as it doesn't mess up your other data, you could use a space and a comma as delimiters.

Do you need it separate? What if you read it in as a datetime? I'd be tempted to use readtable and just keep it all together, but I don't know what your application is.

Related Solutions

MATLAB: Converting HH:MM:SS into decimal days to make a time series

Use a datetime. When you plot, your data type is honored. You can use xtickformat to format how the data appears.

% Define date and time formats for import
opts = detectImportOptions("CTD12-17.xlsx");
% nice, but not necessary
opts.VariableNamingRule = "preserve";
opts = setvartype(opts,"Time","duration");
opts = setvaropts(opts,"Time","InputFormat","hh:mm:ss","DurationFormat","hh:mm:ss");
% Set datetime format for Date + Time
opts = setvartype(opts,"Date_TimeCombined","datetime");
opts = setvaropts(opts,"Date_TimeCombined","InputFormat","dd/MM/yy HH:mm:ss");
% Load data
data = readtable("CTD12-17.xlsx",opts)
data = 6x7 table
       Date          Time      Date + Time Combined    Bottom Water Mean N+N    Surface Water Mean N+N    Bottom Water Mean P    Surface Water Mean P
    ___________    ________    ____________________    _____________________    ______________________    ___________________    ____________________

    07-Jul-2010    04:55:00     07/07/10 04:55:00              10.24                     5.38                    0.68                    0.43        
    07-Jul-2010    15:06:38     07/07/10 15:06:38               8.77                     3.11                    0.64                     0.5        
    07-Jul-2010    22:21:32     07/07/10 22:21:32               9.86                     4.84                    9.67                    0.39        
    08-Jul-2010    04:12:44     08/07/10 04:12:44               9.86                     4.84                    0.67                    0.39        
    08-Jul-2010    20:31:47     08/07/10 20:31:47               9.81                      4.4                    0.71                    0.38        
    09-Jul-2010    02:35:24     09/07/10 02:35:24              10.46                     3.43                     0.7                    0.32        
%Plot
plot(data.("Date + Time Combined"),data.("Bottom Water Mean N+N"))

MATLAB: Read in timestamps from weird time format

If the data is stored in a cell array of character vectors, S, then

datetime(S, 'InputFormat', 'uuuu-MM-dd''T''hh:mm:ss''Z''', 'TimeZone', 'UTC')

Best Answer

Related Solutions

MATLAB: Converting HH:MM:SS into decimal days to make a time series

MATLAB: Read in timestamps from weird time format

Related Question