[HPADM] SUMMARY Script help for finidng out missing no

From: Lal, Neeraj (Neeraj.Lal@pfizer.com)
Date: Fri Feb 06 2004 - 15:04:42 EST

Thanks to Eef & other for responding fast
 
here is the script
file_dir="/a/b/"

file1=FILEA

file2=FILEB

cut -c1-8 ${file_dir}/${file1} | sort > ${file_dir}/temp1

cut -c1-8 ${file_dir}/${file2} | sort > ${file_dir}/temp2

uniq -c temp1 | awk '{print $2}' > temp11

uniq -c temp2 | awk '{print $2}'> temp22

sort temp11 > temp111

sort temp22 > temp222

comm -23 temp111 temp222 > tempout

 
 
 
 

Neeraj Lal
Pfizer Inc.
Consultant CHC-IS
973-385-2734

-----Original Message-----
From: Lal, Neeraj [mailto:Neeraj.Lal@Pfizer.com]
Sent: Friday, February 06, 2004 11:46 AM
To: 'hpux-admin@dutchworks.nl'
Subject: [HPADM] Script help for finidng out missing no

Hi Admin

Script help

I have two files contaning cust NO. & Other fields

FILE A FILE B
CUST No. Name CUST No. Name
12345 aaaa 12345 aaaa
23456 BBB 23456 BBB
67890 CCC 78900 DPP
78900 DDD
78000 DPP

Now I want a script which should tell me that 7800 & 67890 cust no are
missing from file B. we arejust comparing only cust no.

Thanks

Neeraj Lal
Pfizer Inc.
Consultant CHC-IS
973-385-2734 

--
             ---> Please post QUESTIONS and SUMMARIES only!! <---
        To subscribe/unsubscribe to this list, contact majordomo@dutchworks.nl
       Name: hpux-admin@dutchworks.nl     Owner: owner-hpux-admin@dutchworks.nl
 
 Archives:  ftp.dutchworks.nl:/pub/digests/hpux-admin       (FTP, browse only)
            http://www.dutchworks.nl/htbin/hpsysadmin   (Web, browse & search)

This archive was generated by hypermail 2.1.7 : Sat Apr 12 2008 - 11:02:38 EDT