How to convert datetime to datenum which date and time from different column?

Question

hanif hamden 2020-9-9

0
链接

此问题的直接链接

https://ww2.mathworks.cn/matlabcentral/answers/591226-how-to-convert-datetime-to-datenum-which-date-and-time-from-different-column

评论： hanif hamden 2020-9-12

采纳的回答： Ameer Hamza

在 MATLAB Online 中打开

Hi. anyone can solve this matter. I have a few columns which column1 (date) column2 (time) column3-15 (data)

I wanted to combine column1 and column2 so that I can convert it to datenum. This is example of data:

2019/10/07 20:15:00.000 5.349262952 103.258721787 2.1295 2 13 0.6876 0.6421 1.5800 -0.1096 0.0901 -0.5698 0.00 1.1

2019/10/07 20:15:01.000 5.349275362 103.258709080 5.0561 2 13 0.0145 0.0172 0.0356 -0.0006 -0.0111 -0.0106 0.00 1.1

2019/10/07 20:15:02.000 5.349286939 103.258719120 5.0214 2 13 0.0145 0.0172 0.0356 -0.0005 -0.0111 -0.0106 0.00 1.1

2019/10/07 20:15:03.000 5.349298684 103.258728601 5.1884 2 12 0.0145 0.0172 0.0358 0.0003 -0.0112 -0.0107 0.00 1.3

Below is the example of my coding:

clc;clear all; close all;
delim = ' '; % space delimited
% delim = '\t'; % tab delimited
% delim = ','; % comma delimited
%Input File
fid=fopen('E3D_KUAL_TPS.pos');
A = textscan(fid,'%s %s %f %f %f %f %f %f %f %f %f %f %f %f %f','HeaderLines',26); % read file;
date =string(A{1}); time =string(A{2});
str =([date time]);
dt = datetime(str,'InputFormat','yyyy/mm/dd  hh:mm:ss.SSS');
dtnum = datenum(dt);

0 个评论
显示 -2更早的评论隐藏 -2更早的评论

请先登录，再进行评论。

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

Answer 1

Ameer Hamza 2020-9-9

1
链接

此回答的直接链接

https://ww2.mathworks.cn/matlabcentral/answers/591226-how-to-convert-datetime-to-datenum-which-date-and-time-from-different-column#answer_492214

编辑：Ameer Hamza 2020-9-9

在 MATLAB Online 中打开

Try this

% clc;clear all; close all;
delim = ' '; % space delimited
% delim = '\t'; % tab delimited
% delim = ','; % comma delimited
%Input File
fid=fopen('E3D_KUAL_TPS.pos');
A = textscan(fid,'%s %s %f %f %f %f %f %f %f %f %f %f %f %f %f','HeaderLines',26); % read file;
date =string(A{1});
time =string(A{2});
str = date + ' ' + time;
dt = datetime(str,'InputFormat','yyyy/MM/dd HH:mm:ss.SSS');
dtnum = datenum(dt);