Info

This question is closed. Reopen it to edit or answer.

Determine whether a column in a Table contains time data

1 view (last 30 days)
Aniruddha
Aniruddha on 2 Feb 2017
Closed: MATLAB Answer Bot on 20 Aug 2021
How can I determine whether a column in a Table is a time vector? In addition, how can I ensure that all rows in this column have the same time series format?

Answers (1)

Iddo Weiner
Iddo Weiner on 2 Feb 2017
Please define "time vector" - do you mean that the numbers should simply be monotonically increasing? or do you also have a certain "time format" / "time pattern" you're looking for ? If it's the first option, the solution is simple enough:
function out = is_monotonically_increasing(vector)
if sum (vector(2:end) - vector(1:end-1) <= 0) > 0
Out = 0;
else
Out = 1;
end
end
If you need something more specific please describe more thoroughly
  3 Comments
Iddo Weiner
Iddo Weiner on 4 Feb 2017
Absolutely! Aniruddha - are you there? does this help? Or do you have different specifications?

Community Treasure Hunt

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

Start Hunting!