Shell Programming and Scripting

****ALEX***JOHN*******VIRGIL*****
CHRITINE*****FAISAL*****DON*****
****ALEX***JOHN*******VIRGIL*****
CHRITINE*****FAISAL*****DON*****
****ALEX***JOHN*******VIRGIL*****
****ALEX***JOHN*******VIRGIL*****
CHRITINE*****FAISAL*****DON*****
****ALEX***JOHN*******VIRGIL*****
CHRITINE*****FAISAL*****DON*****
****ALEX***JOHN*******ALEX*****

ALEX
CHRISTINE
DON
FAISAL
JOHN
VIRGIL

ALEX             = 7
CHRISTINE   = 4
DON              =  4
FAISAL         =  4
JOHN            =  6
VIRGIL          =  5
ANDREW      = 0

#!/bin/sh

# By using[*]+ as field separator, strip them all out and
# get them as sane tokens.
# By using OFS="\n", print one name per line.
# ORS="" prevents a few extra newlines.
# $1=$1 is necessary to actually transform the data, which isn't otherwise modified.
file1 < awk -v FS="[*]+" -v OFS="\n" -v ORS="" '{ $1=$1 ; NF--; } 1' |
# Sort alphabetically
        sort | 
# Count repetitions, save output to temp file.
        uniq -c > /tmp/$$

# Read the sorted file, and output it in the manner we need.
while read COUNT NAME
do
        # Ignore blank first line
        [ -z "$NAME" ] && continue
        echo "$NAME = $COUNT"
        echo "$NAME" >&2
done < /tmp/$$ > file2 2> file3

# delete temp file.
rm -f /tmp/$$