How to truncate the data in a column vector

9 次查看（过去 30 天）
Darryl
Darryl 2013-11-2
评论： Darryl 2013-11-4
I am reading in data from a .xlsx file. One of my columns is the current time which is formatted hour:mins and the other column is the data which is formatted dd/mm/yyyy.
I would like to be able to truncate the time column so I only get the hour, then do the same for minutes (obviously I will have to copy the column vector before hand). The same goes for the date column that uses a / delimiter.
What is the best solution for this?
Thanks

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

回答（1 个）

Image Analyst
Image Analyst 2013-11-2
Try this:
% Create sample data in Darryl's format.
clear d;
for k = 1:5
d{k, 1} = datestr(now, 'HH:MM');
d{k, 2} = datestr(now, 'dd/mm/yyyy');
pause(1);
end
d
% Now we have sample data in the proper format,
% and now we can start.
% Truncate the first column to hours only
for k = 1 : 5
d{k, 1} = datestr(datenum(d{k, 1}), 'HH');
end
d
  5 个评论
显示 3更早的评论
Image Analyst
Image Analyst 2013-11-3
Column E and F? Why did you read those in? It looks like the data are in columns H and I, isn't it? Please clarify which columns you want, and if it's E and F like you use in your code, what do those numbers mean?
Darryl
Darryl 2013-11-4
Sorry, yes the columns that need reading in are H and I. The code I used above is extracting data from another .xlsx file.
I'll give you a rundown of the columns:
ID number; lat; long; altitude; speed; tracking angle; satellites; time; date;
So columns E and F are in this case speed and tracking angle

请先登录，再进行评论。

类别

在 Help Center 和 File Exchange 中查找有关 Dates and Time 的更多信息

标签

Community Treasure Hunt

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

Start Hunting!

Translated by