Time reading in matlab

12 次查看（过去 30 天）
Silpa K
Silpa K 2019-8-23
评论： Silpa K 2019-8-24
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.
  8 个评论
显示 6更早的评论
Walter Roberson
Walter Roberson 2019-8-24
Zip the file and attach the .zip here.
Silpa K
Silpa K 2019-8-24
This is one of it

请先登录，再进行评论。

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

采纳的回答

Sulaymon Eshkabilov
Hi,
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);
fclose(My_FID);
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};
DEPTH= DATA{9};
Q = DATA{10};
EVID = DATA{11};
NPH = DATA{12};
NGRM = DATA{13};
Good luck.

更多回答（1 个）

Walter Roberson
Walter Roberson 2019-8-24
%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';

类别

在 Help Center 和 File Exchange 中查找有关 Data Type Conversion 的更多信息

标签

Community Treasure Hunt

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

Start Hunting!

Translated by