[HPADM] SUMMARY Script help for finidng out missing no

From: Lal, Neeraj (Neeraj.Lal_at_pfizer.com)
Date: 02/06/04

  • Next message: john corcoran: "[HPADM] XFree86Config on Hpux 11" 
    To: "Lal, Neeraj" <Neeraj.Lal@pfizer.com>, "'hpux-admin@dutchworks.nl'" <hpux-admin@dutchworks.nl>
Date: Fri, 6 Feb 2004 15:04:42 -0500

    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)
  • Next message: john corcoran: "[HPADM] XFree86Config on Hpux 11"