Time reading in matlab

2019 8 23
2 个回答
回答已采纳
更新时间：2019 8 24
20 次查看（30 天）

0 个投票

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更早的评论 隐藏 6更早的评论

Walter Roberson
Walter Roberson 2019-8-23
What file format is the dataset in? What code are you trying? Which MATLAB release are you using?
Silpa K
Silpa K 2019-8-23
Dataset is in .catalog format.The conversion is not getting.Iam new in matlab.MatlabR2018b.
[Sig, TStr, Raw] = xlsread('newww.xlsx',1,'A:F');
Walter Roberson
Walter Roberson 2019-8-23
.catalog do not appear to be .xlsx so I would not expect xlsread() to be able to read them.
But if somehow you got some useful information using xlsread() then I suggest you try using readtable() which is an improved xlsx interface.
Silpa K
Silpa K 2019-8-23
Its reading,but time is not reading like HH_MM_SS format.Is there is any way for read it?Please help.
Walter Roberson
Walter Roberson 2019-8-23
I need a sample input file to test with.
Silpa K
Silpa K 2019-8-24
How can I give that?
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

请先登录，再进行评论。

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

 采纳的回答

0 个投票

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

0 个投票

%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';

类别

在 帮助中心 和 File Exchange 中查找有关 Holidays / Seasons 的更多信息

标签

Community Treasure Hunt

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

Start Hunting!

Translated by