tricky data parsing question.. how to pull values from certain time intervals

1 view (last 30 days)
take a look at the image in the link below for clarification:
Basically I have a very long data set which includes an occassional break in data at certain times, which looks something similar to what is in the image. I know the exact times at which these occur, and I need to do a search at each time find out what the last 3 numbers are in columns 5, 6, and 7 before the break in data. In this case, the numbers would be 0, -3.137756, and 3.18323 (the values one cell row above the highlighted line). the problem is that the times that i need to check will not match any of those in the left hand column. they will most likely be in between two given times on the 1st column. this might eliminate index creation as a possibility.
Im not expecting anyone to solve this, but any input at all would be greatly helpful as i am still new to matlab. i already know how to do find(... ,'last') to get the last value in a list, but not for multiple columns, and not for different intervals for that matter.
thanks in advance
  1 Comment
Oleg Komarov
Oleg Komarov on 24 May 2011
this is a duplicate question and I answered you here: http://www.mathworks.com/matlabcentral/answers/7716-matlab-challenge-searching-range-of-data-to-see-if-certain-values-exist

Sign in to comment.

Answers (0)

Categories

Find more on Entering Commands in Help Center and File Exchange

Community Treasure Hunt

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

Start Hunting!