handling CSV file to get desired output

01-12-2012

Registered User

31, 0

Join Date: Jun 2011

Last Activity: 30 December 2014, 11:16 PM EST

Posts: 31

Thanks Given: 0

Thanked 0 Times in 0 Posts

handling CSV file to get desired output

Hi All , i have a CSV file , pattern is given below :-

Code:

Group # name # host # account # stop # # start # # check 
--------------------------------------------------------------------------

file format and data exmaple :-

Code:

RBP2,RB0112,sihrb001,tksrb011,. ./.profile 1>/dev/null 2>&1;stop_olc_dmn RB0112,,. ./.profile 1>/dev/null 2>&1;nohup rtprio 100 ART_AMC_Start_AVM_ksh -n RB0112 -e gnavm_ewd & 1>/dev/null,,ps -fu \$LOGNAME | grep 'olcServer -n RB0112'|grep -vgrep                                                                                                     
RBP2,RB0212,sihrb001,tksrb011,. ./.profile 1>/dev/null 2>&1;stop_olc_dmn RB0212,,. ./.profile 1>/dev/null 2>&1;nohup rtprio 100 ART_AMC_Start_AVM_ksh -n RB0212 -e gnavm_ewd & 1>/dev/null,,ps -fu \$LOGNAME | grep 'olcServer -n RB0212'|grep -vgrep                                                                                                     
RBS2,RB0622,sihrb001,tksrb011,. ./.profile 1>/dev/null 2>&1;stop_olc_dmn RB0622,,. ./.profile 1>/dev/null 2>&1;nohup rtprio 100 ART_AMC_Start_AVM_ksh -n RB0622 -e gnavm_ewd & 1>/dev/null,,ps -fu \$LOGNAME | grep 'olcServer -n RB0622'|grep -vgrep                                                                                                     
RBP1,RB0111,sihrb001,tksrb011,. ./.profile 1>/dev/null 2>&1;stop_olc_dmn RB0111,,. ./.profile 1>/dev/null 2>&1;nohup rtprio 100 ART_AMC_Start_AVM_ksh -n RB0111 -e gnavm_ewd & 1>/dev/null,,ps -fu \$LOGNAME | grep 'olcServer -n RB0111'|grep -vgrep                                                                                                     
RBP1,RB0211,sihrb001,tksrb011,. ./.profile 1>/dev/null 2>&1;stop_olc_dmn RB0211,,. ./.profile 1>/dev/null 2>&1;nohup rtprio 100 ART_AMC_Start_AVM_ksh -n RB0211 -e gnavm_ewd & 1>/dev/null,,ps -fu \$LOGNAME | grep 'olcServer -n RB0211'|grep -vgrep                                                                                                     
RBS1,RB0621,sihrb001,tksrb011,. ./.profile 1>/dev/null 2>&1;stop_olc_dmn RB0621,,. ./.profile 1>/dev/null 2>&1;nohup rtprio 100 ART_AMC_Start_AVM_ksh -n RB0621 -e gnavm_ewd & 1>/dev/null,,ps -fu \$LOGNAME | grep 'olcServer -n RB0621'|grep -vgrep                                                                                                     
XLA,XLAOLC011,sihrb001,tksrb011,. ./.profile 1>/dev/null 2>&1;ps -fe|grep XLA_OLC011|grep -w 'xladaemon'|grep -v grep |tr -s '[ ]' '[ ]'|cut -d ' ' -f 2|xargs kill -9,,. ./.profile 1>/dev/null 2>&1;nohup ART_AMC_Start_ksh -i XLA_OLC011 -b xladaemon -m "pm olc" -t olc -n RATER -x N &,,ps -fu \$LOGNAME | grep 'xladaemon -n XLA_OLC011'|grep -vgrep
XLA,XLAOLC032,sihrb001,tksrb011,. ./.profile 1>/dev/null 2>&1;ps -fe|grep XLA_OLC032|grep -w 'xladaemon'|grep -v grep |tr -s '[ ]' '[ ]'|cut -d ' ' -f 2|xargs kill -9,,. ./.profile 1>/dev/null 2>&1;nohup ART_AMC_Start_ksh -i XLA_OLC032 -b xladaemon -m "pm olc" -t olc -n RATER -x N &,,ps -fu \$LOGNAME | grep 'xladaemon -n XLA_OLC032'|grep -vgrep
RBFOFFP,RBF011,sihrb001,tksrb011,. ./.profile 1>/dev/null 2>&1;stop_olc_dmn RBF011,,. ./.profile 1>/dev/null 2>&1;nohup rtprio 100 ART_AMC_Start_ksh -i RBF011 -b olcServer -m "pm olc" -t olc -n RATER -x Y &,,ps -fu \$LOGNAME | grep 'olcServer -n RBF011'|grep -vgrep                                                                                 
RBFOFFS,RBF032,sihrb001,tksrb011,. ./.profile 1>/dev/null 2>&1;stop_olc_dmn RBF032,,. ./.profile 1>/dev/null 2>&1;nohup rtprio 100 ART_AMC_Start_ksh -i RBF032 -b olcServer -m "pm olc" -t olc -n RATER -x Y &,,ps -fu \$LOGNAME | grep 'olcServer -n RBF032'|grep -vgrep                                                                                 
AGENTR,AGENTR01,sihrb001,tksrb011,. ./.profile 1>/dev/null 2>&1;ps -fe|grep   AGENTR01 |grep -w gn1avm_agent|tr -s '[ ]' '[ ]'|cut -d ' ' -f 2|xargs kill -9,,. ./.profile 1>/dev/null 2>&1;nohup gn1avm_runproc_Ksh -e OLC1AVMA  -n AGENTR01 &,,ps -fu \$LOGNAME | grep 'gn1avm_agent -n AGENTR01$'|grep -vgrep                                          
SYNC,SYNC011,sihrb001,tksrb011,. ./.profile 1>/dev/null 2>&1;stop_olc_dmn SYNC011,,. ./.profile 1>/dev/null 2>&1;nohup ART_AMC_Start_ksh -i SYNC011 -b olcServer -m "pm olc" -t olc -n RATER -x N &,,ps -fu \$LOGNAME | grep 'olcServer -n SYNC011'|grep -vgrep                                                                                           
SYNC,SYNC032,sihrb001,tksrb011,. ./.profile 1>/dev/null 2>&1;stop_olc_dmn SYNC032,,. ./.profile 1>/dev/null 2>&1;nohup ART_AMC_Start_ksh -i SYNC032 -b olcServer -m "pm olc" -t olc -n RATER -x N &,,ps -fu \$LOGNAME | grep 'olcServer -n SYNC032'|grep -vgrep

Requirement :-

i have a script which is using this CSV file. that script will use group name (first coloumn) and collect all daemons in same group and will perform action , start/stop/check. example is below - so select group and go ahead with action on next menu page
13) RBFOFFP
14) RBFOFFS
15) RPL
16) CM
17) SED
18) SYNC

i want - to arrange these groups based on below requirements :-
1. i can bounce all the daemons on each server .(This seems easy , can do ,search all server names and redirect to new file and change group name)
2. IMPORTANT - suppose i want to handle few daemons , like we have one unique ID , i want to search that id and handle those daemons only .
example - on server 1 , 5-6 type of daemons are running , RB0111, RB0211, RB0112, RB0212 , RBF011, XLA011, SYNC011, .....unique ids here are - 01,02.....44 , and for daemon- RB , format is like , [unique_id][1-2][1-2] but for other daemons format is [unique_id][1-2]
if i say i want to handle all d daemons of unique_id = 15 , it means i shoudl get below daemons :-

Code:

RBP2,RB1512,sihrb008,tksrb151,. ./.profile 1>/dev/null 2>&1;stop_olc_dmn RB1512,,. ./.profile 1>/dev/null 2>&1;nohup rtprio 100 ART_AMC_Start_AVM_ksh -n RB1512 -e gnavm_ewd & 1>/dev/null,,ps -fu \$LOGNAME | grep 'olcServer -n RB1512'|grep -vgrep                                                                                                     
RBP1,RB1511,sihrb008,tksrb151,. ./.profile 1>/dev/null 2>&1;stop_olc_dmn RB1511,,. ./.profile 1>/dev/null 2>&1;nohup rtprio 100 ART_AMC_Start_AVM_ksh -n RB1511 -e gnavm_ewd & 1>/dev/null,,ps -fu \$LOGNAME | grep 'olcServer -n RB1511'|grep -vgrep                                                                                                     
XLA,XLAOLC151,sihrb008,tksrb151,. ./.profile 1>/dev/null 2>&1;ps -fe|grep XLA_OLC151|grep -w 'xladaemon'|grep -v grep |tr -s '[ ]' '[ ]'|cut -d ' ' -f 2|xargs kill -9,,. ./.profile 1>/dev/null 2>&1;nohup ART_AMC_Start_ksh -i XLA_OLC151 -b xladaemon -m "pm olc" -t olc -n RATER -x N &,,ps -fu \$LOGNAME | grep 'xladaemon -n XLA_OLC151'|grep -vgrep
RBFOFFP,RBF151,sihrb008,tksrb151,. ./.profile 1>/dev/null 2>&1;stop_olc_dmn RBF151,,. ./.profile 1>/dev/null 2>&1;nohup rtprio 100 ART_AMC_Start_ksh -i RBF151 -b olcServer -m "pm olc" -t olc -n RATER -x Y &,,ps -fu \$LOGNAME | grep 'olcServer -n RBF151'|grep -vgrep                                                                                 
SYNC,SYNC151,sihrb008,tksrb151,. ./.profile 1>/dev/null 2>&1;stop_olc_dmn SYNC151,,. ./.profile 1>/dev/null 2>&1;nohup ART_AMC_Start_ksh -i SYNC151 -b olcServer -m "pm olc" -t olc -n RATER -x N &,,ps -fu \$LOGNAME | grep 'olcServer -n SYNC151'|grep -vgrep

so i want to execute a logic which will handle this type of request and get data from given CSV file.
i hope , someone can give an idea.
let me know if more details are required

Moderator's Comments:

Video tutorial on how to use code tags in The UNIX and Linux Forums.

---------- Post updated 01-13-12 at 02:28 AM ---------- Previous update was 01-12-12 at 03:52 AM ----------

i am sorry , cant see video .i see blue screen only and no video, . well i dont have any script code , i h=just provided file and my requirement .

Last edited by radoulov; 01-11-2012 at 05:23 PM..

deepakiniimt

View Public Profile for deepakiniimt

Find all posts by deepakiniimt

Shell Programming and Scripting

handling CSV file to get desired output

10 More Discussions You Might Find Interesting

1. Shell Programming and Scripting

Output not coming as desired.

Discussion started by: Junaid Subhani

2. Shell Programming and Scripting

Save output of updated csv file as csv file itself, part 2

Discussion started by: refrain

3. Shell Programming and Scripting

Save output of updated csv file as csv file itself

Discussion started by: refrain

4. Shell Programming and Scripting

Desired output.txt for reading txt file using awk?

Discussion started by: emily

5. UNIX for Dummies Questions & Answers

Handling Comma in string values in a CSV file

Discussion started by: prabhat.diwaker

6. Shell Programming and Scripting

How to grep the desired output and output to a file?

Discussion started by: jediwannabe

7. Shell Programming and Scripting

need to get the desired output

Discussion started by: anuragpgtgerman

8. Shell Programming and Scripting

SED - output not desired

Discussion started by: kevintse

9. Shell Programming and Scripting

Using awk/sed in handling csv file.

Discussion started by: ajincoep

10. Shell Programming and Scripting

Help me in getting the desired output

Discussion started by: akash