MATLAB: Extracting data from several columns by indexing

extracting dataindexing

Hi, I'm a bit new with MatLab and my problem concerns extracting and indexing. I have a large datafile, which has columns month, day, hour, minute, measurement1, measurement2…measurementN e.g.: data=
[2009 1 1 10 100 120 150 120 120
2009 1 1 10 362 323 300 554 654
2009 1 1 11 419 540 640 550 540
...]
I need to extract data at certain hour (e.g. 10) from all columns. (With excel this would be sorting with hour = 10.) I tryed indexing, but I managed only get data from one column not all. How can I extract all hour10 rows from all columns?
Thank you for your help, Liisa

Best Answer

idx = data(:,4) == 10;
data(idx,:)
% Or specific columns
cols = [1:4 7,9];
data(idx,cols)
Related Question