[HPADM] SUMMARY :Scripting question

From: Lal, Neeraj (Neeraj.Lal@pfizer.com)
Date: Thu Aug 07 2003 - 18:29:32 EDT

Next message: Julian Rogan: "[HPADM] Understanding output form Symmetrix syscfg command"
Previous message: William Kung: "[HPADM] EMC Power Path"
Messages sorted by: [ date ] [ thread ] [ subject ] [ author ] [ attachment ]

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"
Previous message: William Kung: "[HPADM] EMC Power Path"
Messages sorted by: [ date ] [ thread ] [ subject ] [ author ] [ attachment ]

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