UNIX for Beginners Questions & Answers

# Time_result: 1.056179  next_value: 0.000077 
OTHER VALUE 445552341;
SELECT row with values
# IP = 192.168.1.15
# Time: 45
# Time_result: 100.15  next_value: 0.000077 
OTHER VALUE 445552341;
SELECT row with values
   value 1 
   value 2
      other value 1
# some row
# Time_result: 50.35  next_value: 0.000077 
SELECT some new values
# IP new 10.150.2.15
# Time_result: 52.15  next_value: 0.000077 
OTHER VALUE 445552341;
SELECT row with values
   value 1 
# some row

SELECT row with values
   value 1 
   value 2
      other value 1
SELECT some new values
SELECT row with values
   value 1

awk '/^#/{flag=0}flag;/^SELECT/{print ;flag=1}' file

awk '
        /Time_result/ && $3 > 50 {
                t_flag = 1
                next
        }
        /SELECT/ {
                s_flag = 1
        }
        /^#/ && s_flag {
                s_flag = 0
        }
        t_flag && s_flag
' file

 awk '/Time_result/ && $3 > 50 { t_flag = 1 ; next } /SELECT/ { s_flag = 1 } /^#/ && s_flag { s_flag = 0 } t_flag && s_flag' file