topic Re: ShellScript help pl in Operating System - HP-UX

ShellScript help pl

Ashwin_4 — Mon, 25 Oct 2004 02:56:56 GMT

Hi Masters,
I've the following file,
1 a
1 a
1 a
1 b
1 b

I want the following output:
1 a 3
1 b 2

Pl help

Re: ShellScript help pl

Steve Steel — Mon, 25 Oct 2004 03:15:03 GMT

Hi

This script with filename as parameter

file=$1
sort -u $file|while read line
do
echo "$line"" "$(grep "$line" $file|wc -l)
done

For scripting see

http://www.shelldorado.com/

Steve Steel

Re: ShellScript help pl

Stuart Whitby — Mon, 25 Oct 2004 04:13:56 GMT

Steve's answer's perfectly correct as long as that's the exact format of your file. If you can have a file which has:

1 a
1 a
1 b
1 c
1 a
1 a
1 b

and *still* want

1 a 4
1 b 2
1 c 1

then use

cat | sort -n | uniq -c | awk '{ print $2 " " $3 " " $1 }'

Re: ShellScript help pl

H.Merijn Brand (procura — Mon, 25 Oct 2004 05:48:59 GMT

or

# perl -ne'$x{$_}++}END{for(sort keys%x){s/$/ $x{$_}/;print}' file

Enjoy, Have FUN! H.Merijn

Re: ShellScript help pl

Hein van den Heuvel — Mon, 25 Oct 2004 06:44:16 GMT

and finally, in case you need some further data massaging along the lines (sic), here is an awk solution for a sorted file:

awk 'BEGIN {getline x}{i++;if (x!=$0) {print x,i;i=0;x=$0}} END {print x, ++i}' sorted_input

BEGIN - preset last seen record value
loop - always count. if new value not equal to old then: print value &count and reset value & count
END - print final value & count

fwiw,

Hein.

Re: ShellScript help pl

Rangarajan Radhakrishna — Mon, 25 Oct 2004 09:24:55 GMT

sort filename | uniq -c | sed -e 's:$[0-9][0-9]*$$[ ][ ]*$$.*$$:\3\2\1:'

Re: ShellScript help pl

Singaram — Tue, 26 Oct 2004 10:43:10 GMT

Hi Stuart

Steve's Solution works perfectly in all cases. It works in your file as well ashwin's file

Singaram