UNIX for Dummies Questions & Answers

#=======================================================
# Script Name: pnumname
# By:          J.D.
# Date:        February 2011
# Purpose:     Extract Programmer Numbers and Names
#=======================================================
cut -d: -f1-4 programmer | sort -t: -k 1 | uniq > pnn
# The above cuts out fields 1 through 4.
# The output is piped to a sort by programmer number.
# The sorted output is piped to uniq to remove
# duplicates.
# Uniq redirects the output to pnn.

cat pnn
101:Johnson:John:K
102:King:Mary:K
103:Brown:Gretchen:K
104:Adams:Betty:C
105:Utley:Amos:V
106:Wilson:Patricia:B
107:Culligan:Thomas:F
108:Mitchell:Hillary:N
109:Arbuckle:Margaret:F
110:Ford:Terrence:H
111:Greene:Sarah:L
112:Rose:Richard:P
113:Daniels:Allan:S
114:Edwards:George:J

#=========================================================
# Script Name: joinall
# By:          J.D.
# Date:        February 2011
# Purpose:     Join pnum and pnn to create a report file
#==========================================================
# Join the file including the unassigned programmers.
# You do this by placing the programmer names (pnn) file,
# forst, in the join sequence.
#==========================================================
join -t: a1 -j1 1 -j2 1 pnn pnum > pactrep