[HPADM] SUMMARY :Scripting question

From: Lal, Neeraj (Neeraj.Lal_at_pfizer.com)
Date: 08/08/03

  • Next message: Julian Rogan: "[HPADM] Understanding output form Symmetrix syscfg command" 
    To: "'hpux-admin@dutchworks.nl'" <hpux-admin@dutchworks.nl>
Date: Thu, 7 Aug 2003 18:29:32 -0400

    Hi thanks to all

    it worked for me

    cat datafile | (

      while linein=`line`;
         do country=`echo "$linein" | awk -F'~' '{print $3}'`;
         echo "$linein" >> ${country}.dat;
       done;)

    -----Original Message-----
    From: Wright, Richard [mailto:Richard.Wright@acs-inc.com]
    Sent: Thursday, August 07, 2003 4:45 PM
    To: 'Lal, Neeraj'
    Subject: RE: [HPADM] Scripting question

    I have not seen a summary yet, so here is my solution.

    # cat test.sh
    #!/bin/sh
    for x in $(cut -f3 -d'~' xxx|sort -u)
    do
    awk -F"~" '$3 ~ /'$x'/ {print $0}' xxx > ${x}.xxx
    done

    Where xxx is your data file.
    And USA.xxx, GER.xxx, are the new files.

    Thanks,

    Richard Wright

    -----Original Message-----
    From: Lal, Neeraj [mailto:Neeraj.Lal@pfizer.com]
    Sent: Thursday, August 07, 2003 12:57 PM
    To: 'hpux-admin@dutchworks.nl'
    Subject: [HPADM] Scripting question

    Hi Admin

    I have a small question reagrding the script here is the scenario I have
    data file like below delimited by ~

    A$BCD~teyeye~USA~djdjdj~dkjdkd!~klcjd;d~;ldd;ldk
    ABCD~teyeye~USA~djdjdj~dkjdkd!~klcjd;d~;ldd;ldk
    ABD~teyeye~USA~djdjdj~dkjdkd!~klcjd;d~;ldd;ldk
    ABD~teyeye~USA~djdjdj~dkjdkd!~klcjd;d~;ldd;ldk
    ABCD~teyeye~USA~djdjdj~dkjdkd!~klcjd;d~;ldd;ldk
    ABCD~tyeye~USA~djdjdj~dkjdkd!~klcjd;d~;ldd;ldk
    ABCD~tyeye~USA~djdjdj~dkjdkd!~klcjd;d~;ldd;ldk
    ACD~teyeye~USA~djdjdj~dkjdkd!~klcjd;d~;ldd;ldk
    ABD~teyeye~USA~djdjdj~dkjdkd!~klcjd;d~;ldd;ldk
    dkjs~dasdlk~GER~nkckdjlk~sklajlakjsdl~nlakslal
    dkjs~dasdlk~GER~nkckdjlk~sklajlakjsdl~nlakslal
    dkjs~dasdlk~GER~nkckdjlk~sklajlakjsdl~nlakslal
    dkjs~dasdlk~GER~nkckdjlk~sklajlakjsdl~nlakslal
    dkjs~dasdlk~GER~nkckdjlk~sklajlakjsdl~nlakslal
    dkjs~dasdlk~GER~nkckdjlk~sklajlakjsdl~nlakslal
    dkjs~dasdlk~GER~nkckdjlk~sklajlakjsdl~nlakslal
    !111~kkk~AMM~jkdd~dddj~jdjjdjdj

    I have this delimited file and in the third field I have country code. On
    basis of country code I need to create output file like if country code is
    USA all the records should go in output file USA.dat if Country code is GER
    all the records with third field GER go to GER.dat file and same on .

    Thanks 

    --
             ---> 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)
--
             ---> 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: Julian Rogan: "[HPADM] Understanding output form Symmetrix syscfg command"