Sorting raw data

I was wondering if anyone can help me with this. Actually I need to be able to write a program in matlab which looks through your raw data and picks up the queue length and delay for the last reading showing any particular value of Unix time, i.e. before it changes to a value that is 0.01 seconds higher. This is an example of my data set. The first Column is my queue length, the second is my unix timestamp, the third is my delay and the fourth the time difference between the time stamps

0 1312023712.02 1.19209289551E-06 0.03999996185303

0 1312023712.02 7.15255737305E-06 0.03999996185303

0 1312023712.02 7.15255737305E-07 0.03999996185303

0 1312023712.02 1.19209289551E-06 0.03999996185303

0 1312023712.03 9.53674316406E-07 0.04999995231628

0 1312023712.03 7.15255737305E-07 0.04999995231628

0 1312023712.03 1.19209289551E-06 0.04999995231628

0 1312023712.03 7.15255737305E-07 0.04999995231628

0 1312023712.03 9.53674316406E-07 0.04999995231628

So in this case i need to get the last value of queue length and delay when time duration is 0.03999 and 0.049999. according to this sample at 0.03999- 0 and 1.19209289551E-06 and for 0.0499- 0 and 9.53674316406E-07

[Jan]

Do you have a specific question? Currently the most likely answer is: yes.

[Image Analyst]

Well your queue length (the first column) is always zero. And I don't see how the 4th column is the difference between rows of the second column. If it were the first 3 rows of the 4th column would be zero because the first 3 rows of your second column are identical.

[Anthony]

I am sorry U really cant see this because the resolution after copying is very poor. Ok please Ignore the the values of the table I can deal with those. What i really need is to be able to get the values

0 1312023712.02 1.19209289551E-06 0.03999996185303

and

0 1312023712.03 9.53674316406E-07 0.04999995231628

because my data is very large about 2GB. So it could take me a lifetime to do it manually. Please do not worry about the values once again. I just need the script to give me the specific values without having to hand pick them; using the values in the fourth column.

Thanks a lot guys

[Image Analyst]

I have no idea what you said. If you say to ignore the junk in the table, then what are we left to deal with?

Answer 1

[Walter Roberson]

YourData(logical(diff([YourData(:,3);inf])),:)

Urrr, perhaps with amendments to fix the problems Image Analyst pointed out.

[Anthony]

Thanks Walter, please could check my reply to Image Analyst's comment and see if you have anything to help out with.

[Anthony]

it works Thanks walter, did a little modification

Answer 2

[Rick Rosson]

Please provide the following information:

1. What specifically are you trying to do?
2. What have you tried so far?
3. What is not working in what you have tried?
4. What is your specific question?

Thanks!

Rick

[Anthony]

Thanks Rick.

I have been ill, that is why i could not reply early enough. I have modified my question. I hope this helps.

I tried using c++ and java to do this but i dont get the values i need. I was told it would be more accurate with matlab.