topic Re: Hp-ux B.11.11 ksh Scripting . in Operating System - HP-UX

Hp-ux B.11.11 ksh Scripting .

Raj D. — Tue, 01 Feb 2005 03:34:31 GMT

Hi I need help for finding out the persons, marks achived , more than 80.

Hp-UX B.11.11 U 9000/800 /usr/bin/ksh

file name: marks.txt

93 Steeve
72 Brocar
43 Minsen
22 Wilsen
77 David
99 Terence
82 Dave
89 Stuwart
78 Vivek
89 Paul
93 Ravi
95 Richard

How to write a script for that ,
I want listing of those name , who is greater than 80.

Does awk or sed help me.

Many Thanks in Advance,

Raj.
----

Re: Hp-ux B.11.11 ksh Scripting .

KapilRaj — Tue, 01 Feb 2005 03:39:23 GMT

cat filename|awk '{ if ($1 > 79) print $2}'

Regds,

Kaps

Re: Hp-ux B.11.11 ksh Scripting .

Raj D. — Tue, 01 Feb 2005 04:04:40 GMT

Hey Kapil ,

Thanks , thats works fine.
but can i save the result in a file.
Do i need to do >> or can i use something inside awk.

Thanks so much ,

RajD.

Re: Hp-ux B.11.11 ksh Scripting .

Ralph Grothe — Tue, 01 Feb 2005 04:28:13 GMT

Yes you can simply redirect stdout in append mode.
Btw. the prepending cat is redundant.

Since TIMTOWTDI here's a Perl variant that will give you a sorted list of top seats exceeding 80 points

perl -e 'map{printf"%s\t%u\n",@{$_}[1,0]}sort{$b->[0]<=>$a->[0]}grep $_->[0]>80,map[/(\d+)\s+(\w+)/],<>' /path/to/inputdata

Re: Hp-ux B.11.11 ksh Scripting .

KapilRaj — Tue, 01 Feb 2005 04:31:55 GMT

cat filename|awk '{ if ($1 > 79) print $2}' > filename.out

Regds,

Kaps

Re: Hp-ux B.11.11 ksh Scripting .

Gordon Morrison — Wed, 02 Feb 2005 06:21:49 GMT

Why be AWKward?
grep ^[89][0-9] marks.txt > highmarks.txt

or, if you want them in order:
grep ^[89][0-9] marks.txt|sort -n > highmarks.txt

Re: Hp-ux B.11.11 ksh Scripting .

Robert Dill — Wed, 02 Feb 2005 14:02:14 GMT

Hi Raj,
I like "read":

cat test.in | \
while read a b
do
if [ $a -ge 80 ] ; then
echo $a $b
fi
done | \
sort -n

Good luck,
Bob

Re: Hp-ux B.11.11 ksh Scripting .

Stefan Murariu — Thu, 08 Mar 2007 06:42:10 GMT

I like also read, so:

while read rank name; do
if [ $rank -gt 79 ]; then
echo "${rank} ${name}"
fi
done
Note for awk:
no need to cat the input file

awk '{ if ($1 > 79) print $2}' input_file > output_file

Re: Hp-ux B.11.11 ksh Scripting .

James R. Ferguson — Thu, 08 Mar 2007 08:07:16 GMT

Hi:

Using 'cat' to read and then piping its output to 'awk' or a shell 'read' loop is a needless, utter *waste* of a process.

Instead of:

# cat filename|awk '{if ($1 > 79) print $2}'

Do:

# awk '{if ($1 > 79) print $2}' filename

Instead of:

# cat file | \
while read a b
do
...
done | sort

Do:

# while read a b
do
done < file | sort

Regards!

...JRF...

Re: Hp-ux B.11.11 ksh Scripting .

Peter Nikitka — Thu, 08 Mar 2007 09:08:16 GMT

Hi,

@Gordon, @Stefan: what about
100 Gordon

in connection with '/[89]...' ?

I fell better with the compare operator '>'.
mfG Peter