Find index in matrix

1 view (last 30 days)
Chris
Chris on 17 Sep 2011
I am looking to find the first value in a 1600x6 dimension matrix. Column 1 contains dates formatted as yymmdd and column 2 has times formated as mmss.
How would I find the row that contains say 100104 1012 which would be 10:12 on Oct 04 2010
I just need the row index so I can collect the rest of the values

Accepted Answer

David Young
David Young on 17 Sep 2011
Assuming it's a numerical matrix, called M:
d = 100104;
t = 1012;
row = find(M(:,1) == d & M(:,2) == t)
If it's a cell matrix with strings, use strcmp(d, M(:,1)) etc. instead of ==.

More Answers (1)

Andrei Bobrov
Andrei Bobrov on 17 Sep 2011
[~,indrow] = ismember([101004,1012],A(:,1:2),'rows')

Categories

Find more on Resizing and Reshaping Matrices in Help Center and File Exchange

Tags

Community Treasure Hunt

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

Start Hunting!