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

12 ビュー (過去 30 日間)
hanif hamden
hanif hamden 2020 年 9 月 9 日
コメント済み: hanif hamden 2020 年 9 月 12 日
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);

採用された回答

Ameer Hamza
Ameer Hamza 2020 年 9 月 9 日
編集済み: Ameer Hamza 2020 年 9 月 9 日
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);

その他の回答 (0 件)

カテゴリ

Help Center および File ExchangeDates and Time についてさらに検索

製品


リリース

R2019a

Community Treasure Hunt

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

Start Hunting!

Translated by