Shell Programming and Scripting

ex -s log <<EOF
?\*\*\* Total?+1,/THEN.*600;/-1p
EOF

$
$
$ cat -n f16
     1  index sql
     2
     3  *** Index has been created.
     4  *** Total elapsed time was 8 seconds.
     5
     6
     7  +---------+---------+---------+---------+---------+---------+---------+---------+---------+---------+---------+---------+---------+-
     8
     9  index from 1
    10
    11  *** Index has been created.
    12  *** Total elapsed time was 2 seconds.
    13
    14
    15  +---------+---------+---------+---------+---------+---------+---------+---------+---------+---------+---------+---------+---------+-
    16  table from 2
    17
    18  *** Index has been created.
    19  *** Total elapsed time was 2 seconds.
    20
    21
    22  +---------+---------+---------+---------+---------+---------+---------+---------+---------+---------+---------+---------+---------+-
    23  sql create from 1
    24
    25  *** Query completed. One row found. 3 columns returned.
    26  *** Total elapsed time was 1 second.
    27
    28  abc def ghi
    29  --------- ---------- ----------
    30  123 456 789
    31
    32  +---------+---------+---------+---------+---------+---------+---------+---------+---------+---------+---------+---------+---------+-
    33
    34  .IF ACTIVITYCOUNT > 0 THEN .QUIT 600;
    35  .QUIT 600;
    36  *** You are now logged off from the DBC.
    37  *** Exiting BTEQ...
    38  *** RC (return code) = 600
    39  returncode is 600
$
$
$ perl -0ne 'while(/Total elapsed.*?\.\n(.*?-\+-)\n/sg){$x=$1} END{print $x,"\n"}' f16

abc def ghi
--------- ---------- ----------
123 456 789

+---------+---------+---------+---------+---------+---------+---------+---------+---------+---------+---------+---------+---------+-
$
$
$

sed -n '/elapsed/,/QUIT/ { 
                    /elapsed/ {n;n;h;n}
                    /QUIT/ {g;p}
                    H
                   } 
        ' file
abc def ghi
--------- ---------- ----------
123 456 789

+---------+---------+---------+---------+---------+---------+---------+---------+---------+---------+---------+---------+---------+-

awk 'c-->0{print A[NR%7]} {A[NR%7]=$0} /^\..*THEN.*600\;$/{c=5}' infile

awk '/^\..*THEN.*600\;$/{printf "%s",p} g{p=p $0 RS} /^\+-/{g=0} /\*\*\* Total.*\.$/{getline; p=x; g=1}' infile

sed -n '/elapsed/ {n;h;n}
        /THEN .QUIT/ {g;p}
        H
       ' file