MATLAB Answers

Silpa K

Time reading in matlab

Asked by Silpa K
on 23 Aug 2019
Latest activity Commented on by Silpa K
on 24 Aug 2019
Hi, I have a data set, using matlab I need to read all the data.But the date and time reading is not working.Please help me.


Silpa K
on 24 Aug 2019
How can I give that?
Walter Roberson
on 24 Aug 2019
Zip the file and attach the .zip here.
Silpa K
on 24 Aug 2019
This is one of it

Sign in to comment.


2 Answers

Answer by Sulaymon Eshkabilov on 24 Aug 2019
 Accepted Answer

Here is the complete solution script. Please note that your data file is renamed (S1932.txt):
File_Name = 'S1932.txt';
Formatting_Spec = '%s%s%s %s%f%s %f%f%f %c %d%d%d';
N_header = 10;
My_FID=fopen(File_Name, 'r');
DATA=textscan(My_FID, Formatting_Spec, 'headerlines', N_header);
Date = DATA{1}; % You can ignore this
Time = DATA{2}; % You can ignore this
ET = DATA{3}; % You can ignore this
GT = DATA{4};
MAG = DATA{5};
M = DATA{6};
LAT = DATA{7};
LON = DATA{8};
Q = DATA{10};
EVID = DATA{11};
NPH = DATA{12};
NGRM = DATA{13};
Good luck.

  1 Comment

Silpa K
on 24 Aug 2019
Thank you Sir.

Sign in to comment.

Walter Roberson
Answer by Walter Roberson
on 24 Aug 2019

%set up
opt = detectImportOptions('1932.catalog', 'FileType', 'text', 'readvariablenames', false, 'HeaderLines', 10);
opt = setvartype(opt, 1, 'datetime');
opt = setvaropts(opt,1,'InputFormat', 'yyyy/MM/dd');
opt.VariableNames = {'Date', 'Time', 'ET', 'GT', 'MAG', 'M', 'LAT', 'LON', 'DEPTH', 'Q', 'EVID', 'NPH', 'NGRM'};
%read the file
datatable = readtable('1932.catalog', opt);
%throw away the garbage last entries
datatable = rmmissing(datatable);
%create a composite date/time from the date and time fields
datatable.DateTime = datatable.Date + datatable.Time;
datatable.DateTime.Format = 'dd-MMM-uuuu HH:mm:ss.SSS';

  1 Comment

Silpa K
on 24 Aug 2019
Thank you sir .

Sign in to comment.