topic Re: awk help please in Operating System - HP-UX

awk help please

lawrenzo_1 — Wed, 21 Jun 2006 05:28:00 GMT

hi all,

I am attemting to use awk to get and manipulate data but cannot get the syntax:

Here is what I want, in a logfile I have many summary lines for diffenent sql's that run.

I am running:

TODAY=$(date "+%a %d %b")

awk '
/SQL1 Summary Started/,/SQL1 Summary Finished/ {print}
$2 == "unloaded." {print $1}
' dailystockdownload.log

SQL1 Summary Started Mon 19 Jun 05:31:27 2006

Isolation level set.

1067 row(s) unloaded.

SQL1 Summary Finished Mon 19 Jun 07:57:32 2006

I get all entries from the logfile but I only want todays output in the following format on 1 line.

SQL1 Summary Started Mon 19 Jun 05:31,1067 row(s),Finished Mon 19 Jun 07:57

does this make sense? I do prefer to use awk and sed rather than perl but am open to suggestions.

A million Thanks!

Lawrenzo

Re: awk help please

Peter Nikitka — Wed, 21 Jun 2006 06:02:07 GMT

Hi lawrenzo,

try:

awk -v today="$(date '+%a %d %b')" '$0 ~ today && /SQL1 Summary Started/ { start=$0 }
$2 == "unloaded." {rows=$1" "$2 }
start && /SQL1 Summary Finished/ { print start,rows,$0 ; start="" }' dailystockdownload.log

Note:
- I'm not inserting additional commata.
- Blocks starting before midnight but ending after are reported as well.

mfG Peter

Re: awk help please

lawrenzo_1 — Wed, 21 Jun 2006 06:03:31 GMT

ok maybe I make the question easier:

# echo "$(awk '/R1 Stock Started /,/R1 Stock Finished/' dailystockdownload.log | awk '{print}')"

R1 Stock Finished Sat 17 Jun 00:30:19 2006
R1 Stock Started Sun 18 Jun 01:00:01 2006

Isolation level set.

7645 row(s) unloaded.

R1 Stock Finished Sun 18 Jun 01:00:18 2006
R1 Stock Started Mon 19 Jun 00:30:01 2006

Isolation level set.

7645 row(s) unloaded.

R1 Stock Finished Mon 19 Jun 00:30:18 2006
R1 Stock Started Tue 20 Jun 00:30:01 2006

Isolation level set.

7662 row(s) unloaded.

R1 Stock Finished Tue 20 Jun 00:30:17 2006
R1 Stock Started Wed 21 Jun 00:30:01 2006

Isolation level set.

7699 row(s) unloaded.

R1 Stock Finished Wed 21 Jun 00:30:46 2006

all I want is the information for today but cannot figure out how to print the lines between R1 Stock Started Wed 21 Jun 00:30:01 2006 and R1 Stock Finished Wed 21 Jun 00:30:46 2006

Thanks again

Re: awk help please

Peter Nikitka — Wed, 21 Jun 2006 06:05:28 GMT

Hi,

just reviewd the output format - found that 'unloaded.' is in column 3, so better use:

awk -v today="$(date '+%a %d %b')" '$0 ~ today && /SQL1 Summary Started/ { start=$0 }
$NF == "unloaded." {rows=$1" "$2 }
start && /SQL1 Summary Finished/ { print start,rows,$0 ; start="" }' dailystockdownload.log

mfG Peter

Re: awk help please

lawrenzo_1 — Wed, 21 Jun 2006 06:13:09 GMT

great stuff peter, and the best thing is I am getting used to awk and will use this syntax else where

You the Greatest!

Thanks.