UNIX for Dummies Questions & Answers

YEAHHHHHHHHHHHHHHHHHHHHHH - it worked - I'm still trying to figure out how - but it works! Thank you!

Thought I would share the final product with you. This is giving the company what it needed. I know my coding leaves alot to be desired and any critiques are welcome. I'm just learning again and I can usually get it accomplished - but it ain't pretty. Thanks again for all your help!

#VARIABLES
DATE=$(date +%y%m%d)
TIME=$(date +%T)

# Move today's files into the current directory
cp /lawprd/law/logan/edi_arch_inb/GMED*$DATE* .

# Join all of todays files together
cat GMED*$DATE* > GMED.wrk

#prt header on top of missing540.lst file
echo "$DATE $TIME" > missing540.lst
echo "" >> missing540.lst
echo " Missing GMED Records Report: $TIME" >> missing540.lst
echo "----------------------------------------------" >>missing540.lst

sed -n '/\~ST\^/{N;s/\n//;s/.*\~ST\^//p;}' < GMED.wrk | awk -F "^" '/856\^/ { print $4 }' >ponumber
sed -n '/\~ST\^/{N;s/\n//;s/.*\~ST\^//p;}' < GMED.wrk | awk -F "^" '/810\^/ { print $6 }' >>ponumber

#Pull the requisition numbers out of the MA540CSV file
awk -F "," '/,H,/ { print $10 }' /lawprd/law/prod/work/MA540CSV/MA540CSV >csvnums

#Resort the files and remove duplicate records
sort -u ponumber >po2
sort -u csvnums >csv2

#Write the differences between the inbound and the csv and send them out to a file.
diff po2 csv2 | awk '{if( $2 != "") print $2}' >>missing540.lst

#Remove all the GMED files from the current directory
rm GMED*

#Send the output to cypress
qprt -p17 -z1 -Pcypresst missing540.lst

Note: I have moved the password generation stuff to this thread.


Meanwhile, back at the ranch....

Good work, Barb. But I don't see a #! line as line one. See What does "#! /usr/bin/ksh" mean?

Thank you - it is there now and apologize for interrupting the password thread.