topic Re: script in Operating System - HP-UX

script

Godfrey — Fri, 27 Apr 2001 06:36:01 GMT

I want to select mnemo,sens,qte,prix from the log file where Uti = 102. How to write that script? The output should look like.

uti = 102,
mnemo = 223 ,
sens = 0,
qte = 400000,
prix = 56.750000,
uti = 102,
mnemo = 210 ,
sens = 0,
qte = 400000,
prix = 56.800000,

Re: script

Carsten Krege — Fri, 27 Apr 2001 07:03:48 GMT

That is quick and dirty:

#!/sbin/sh

for i in `grep -n "uti = 102" logfile | cut -f1 -d:`
do
i=`expr $i + 13`
head -n $i logfilename | tail -13 |grep -e "uti =" /
-e mnemo -e sens -e qte -e prix
done

This assumes that one record is always 13 lines long. I bet you will see some nice awk scripts later. :)

Carsten

Re: script

Andreas Voss — Fri, 27 Apr 2001 07:19:19 GMT

Hi,

here my awk script :-)

awk -vUTI_SELECT=102 'BEGIN{valid=0;}
{
if($1 == "uti" && int($3) == UTI_SELECT)
valid=1;
if(valid == 1)
{
if($1 == "uti")
print $0;
else if($1 == "mnemo")
print $1 " " $2 " " $3 " " $4;
else if($1 == "sens")
print $0;
else if($1 == "qte")
print $0;
else if($1 == "prix")
{
print $0;
valid=0;
}
}
}'

Regards

Re: script

Carlos Fernandez Riera — Fri, 27 Apr 2001 08:36:29 GMT

I whish you like this:

sed -e 's/-/#/g
s/ //g
s/,/ /' file > file1

awk ' BEGIN{RS="#"} # set field separator to "#
#
length($0) >0 {
for (i=1; i {
printf "[ %s ]",$i
}
printf "\n" }' file1

Re: script

Vincenzo Restuccia — Fri, 27 Apr 2001 13:55:42 GMT

Re: script

Ralph Grothe — Sun, 29 Apr 2001 22:09:49 GMT

How about a line of Perl for a change? ;-)

# perl -e 'while (<>){print if /uti\s+=\s+102,/../Dval/}' /path/to/raw_data