Read_Data

I need help for read data like below : /local0/Results/pameungpeuk.20091004.sswma is a version 2 SSWMA data file Record 0 acquired at 04/10/2009 00:01:29 GMT (mode 1) Height | Status Za Ma Zt Mt Vv FT CFT Ps Rat Rot NTD SNR1 SNR2 SNR3 AMP1 AMP2 AMP3 NSR1 NSR2 NSR3 -----------+-------------------------------------------------------------------------------------------------------------- 60.00 km | 4 -31.96 10.48 -1 -1 -20 +30 +31 +22 62.00 km | 7 -7.83 -3 -2 -6 +29 +30 +29 64.00 km | 2 -4 -7 +1 +29 +28 +32 66.00 km | 2 -5 -8 -1 +29 +28 +32 68.00 km | 7 -11.69 -2 -4 -3 +31 +31 +32 70.00 km | 5 -11.38 2.75 +0 -1 -2 +32 +32 +31 -6 -3 -1 72.00 km | 0 -67 +23 -17 +21 -1.53 2.80 2.92 385 1.90 +88 19 +3 +5 +3 +33 +34 +34 -9 -12 -99 74.00 km | 0 -72 -37 -16 -7 -0.44 4.23 4.35 383 1.20 -54 17 +8 +9 +9 +35 +36 [phone] 76.00 km | 0 -46 -31 -18 -6 -1.21 4.26 4.45 327 1.31 -27 8 +9 +11 +11 +36 +37 [phone] 78.00 km | 10 -1.87 3.09 45 +7 +10 +8 +35 +37 [phone] 80.00 km | 14 +8 -10 +29 -7 -0.24 2.24 3.11 126 1.94 +17 29 +3 +6 +4 +33 +34 +34 -12 -6 -99 82.00 km | 0 +10 -11 +7 -11 +0.30 2.27 2.55 157 2.57 +45 2 +1 +1 +3 +31 +32 +33 +1 +3 -99 84.00 km | 14 -8 -8 -62 -1 -0.75 2.02 143 2.53 -14 32 -1 -3 -1 +30 +30 +31 +1 -99 -5 86.00 km | 0 -18 -3 -15 -12 -0.59 1.70 1.93 208 3.62 -84 1 +2 +0 -3 +32 +32 +31 -21 -2 -99 88.00 km | 3 -2.24 +19 +19 +19 +42 +42 +42 90.00 km | 131 -1.84 +27 +34 +32 +45 +45 +45 Record 1 acquired at 04/10/2009 00:03:11 GMT (mode 1) Height | Status Za Ma Zt Mt Vv FT CFT Ps Rat Rot NTD SNR1 SNR2 SNR3 AMP1 AMP2 AMP3 NSR1 NSR2 NSR3 -----------+-------------------------------------------------------------------------------------------------------------- 60.00 km | 7 -24.66 -3 -2 -12 +29 +30 +26 62.00 km | 7 -12.71 -3 -3 -11 +29 +30 +27 64.00 km | 7 -9.79 -3 -5 -5 +29 +29 +30 66.00 km | 7 -6.06 -2 -1 -3 +30 +31 +30 68.00 km | 7 -7.19 +1 +3 -1 +32 +33 +32 70.00 km | 7 -6.42 +2 +1 -5 +32 +32 +30 72.00 km | 0 -41 +16 -7 +5 -0.58 5.18 5.31 360 1.79 +74 8 +5 +5 +3 +33 +34 [phone] 74.00 km | 4 -0.39 6.24 +9 +11 +8 +35 +36 +36 76.00 km | 5 -0.50 3.89 +9 +11 +10 +35 +37 [phone] 78.00 km | 0 -48 -41 -10 -9 -0.26 2.89 2.97 173 1.04 -59 16 +7 +9 +6 +34 +35 +35 -8 -14 -10 80.00 km | 0 +21 -11 +14 -7 -0.57 2.20 2.40 138 1.66 +63 5 +6 +4 +2 +33 +33 +33 -3 +0 -8 82.00 km | 0 +18 -16 +12 -12 -1.77 1.92 2.13 150 1.92 +48 5 +2 +0 +0 +32 +32 +32 -1 +5 -99 84.00 km | 0 -37 -49 -20 -12 -0.47 1.89 1.98 184 1.49 -9 4 -1 -0 -0 +30 +31 +32 +2 -8 -1 86.00 km | 3 +1.40 +6 +6 +8 +34 +34 +36 88.00 km | 131 -0.02 +23 +22 +21 +44 +44 +44 90.00 km | 132 -0.92 8.75 +27 +99 +26 +45 +45 +45

I want data sort by height, status choose for O, and pick part of parameter indicate by header. Thank you

[Oleg Komarov]

Not clear where the file starts...upload it somewhere and leave a link.

[Jan]

What have you tried so far and which problems occurred?

[dyah rahayu martiningrum]

I apologize for delaying command. I didn't know you give command. I have put the data that I send in my question into my blog posting :

http://ion-09.blogspot.com/2011/03/dataexamples.html

Data recorded every 2 minutes and saved in one file for one day

[Jan]

Let me repeat: What have you tried so far and which problems occurred? What is your question?

[dyah rahayu martiningrum]

No,I don't try anything. Actually, my question is how do I get certain data, step by step, like Za or Vv or SNR1 (see in header of data) in certain height and hourly of time( 88 km and 1-24 hour for example). As you know, data recorded every 2 minutes (indicate by title of data table), so in my mind I think firstly I have to sort data in association to height,and then I determine mean or median for hourly data.