Login or Register to Ask a Question and Join Our Community


Shell Programming and Scripting

UNIX Scripting

Login to Discuss or Reply to this Discussion in Our Community

 
Thread Tools Search this Thread
Top Forums Shell Programming and Scripting UNIX Scripting
# 1  
Old 02-04-2014
UNIX Scripting
Hi Guys,

I need your help. I have a file with around 10,000 lines in which i need to get the machine and owner name and paste in the seperate file. I have multiple entries fr machine and owner i need to fetch the data accordingly.

File example:
Code:
command: /data/esb/etl/bods_exported_script
machine: V_lty-sap-fhgfhfgh
Owner: Vinoth
std_out_file: "$$GLB_LOGDIRR11U
alarm_if_fail: 1

command: /data/esb/etl/bods_exported_script
machine: V_lty-sap-crm-prbogfhgfhg
Owner: Ram
std_out_file: "$$GLB_LOGDIRR11U
alarm_if_fail: 1

In the above file i need only machine name and its corresponding owner to be copied in seperate file.

Your help is much appreciated
Last edited by Scott; 02-04-2014 at 07:23 AM.. Reason: Code tags, please...
# 2  
Old 02-04-2014
Hi Vinoth,

you can try the next command:
Code:
cat $file | grep -A 1 machine

it will take every line containing "machine" and the next line

also
Code:
cat $file  |  egrep "^machine|^Owner"

should do the trick

cheers
Marco
Last edited by ocrambo; 02-04-2014 at 06:24 AM..
# 3  
Old 02-04-2014
Thanks for your quick reply Marco!!

But it doesnt works. I tried both the comment. It simply got hungSmilie
# 4  
Old 02-04-2014
LinkedIn
Hi Vinoth,

I am using bash, don't know about you. When I do a small test, it is working fine:
Code:
> vi test.txt  (I copied your text in)

> file=test.txt
> cat $file  |  egrep "^machine|^Owner"
machine: V_lty-sap-fhgfhfgh
Owner: Vinoth
machine: V_lty-sap-crm-prbogfhgfhg
Owner: Ram

I can see the information you are trying to query is from AutoSys / W.C.C. If so, then please be aware that the file created with autorep can contain spaces at the beginning of lines (due to boxes in a box). If the whole file is left aligned (as in your example) it should work. Create a smaller version of your file for testing
Last edited by Scrutinizer; 02-11-2014 at 01:05 AM.. Reason: additional information; [mod] code tags
This User Gave Thanks to ocrambo For This Post:
Das
# 5  
Old 02-04-2014
Hi Macro,

am using ksh. Is there any other command??
# 6  
Old 02-04-2014
You could take a look in the manpage of grep and egrep. I think egrep is not supported under ksh and for grep you can try to find an option that suits your needs

> man grep

Please be aware that also the OS could be a delimiting factor. I am working under bash on Linux (RHEL) and it might differ from your environment.
Last edited by ocrambo; 02-04-2014 at 07:48 AM.. Reason: add question
# 7  
Old 02-04-2014
Hey Macro its working now but its fetching only machine value not the owner. I removed the left spaces.

Output
Code:
cat script.txt | egrep "^machine|^Owner"
machine: V_jdgfjhdsfjgjkfdskmhj

Last edited by Scott; 02-04-2014 at 09:32 AM.. Reason: Code tags
Login or Register to Ask a Question

Previous Thread | Next Thread

10 More Discussions You Might Find Interesting

1. Shell Programming and Scripting

UNIX scripting

LIST=/home/xxxxxxx/ABC/xeeno_scrpts/temp/tempfile ERRORDIR=/home/xxxxxxx/ABC/error_directory EMAILFILE=/home/xxxxxxx/ABC/xeeno_scrpts/temp/emailfile echo "There were errors in the following report file for Xeenos:" > $EMAILFILE echo >> $EMAILFILE echo "This files have been moved to... (9 Replies)
Discussion started by: bcarosi
9 Replies

2. UNIX for Dummies Questions & Answers

Unix Shell Scripting( Calling from Unix to PLSQL)

Hello Experts, I have the following questions to be discussed here at this esteemed discussion forum. I have two Excel sheets which contain Unix Commands llike creating directory the structure/ftp/Copy/Zip etc to basically create an environment. I need help in understanding some of... (1 Reply)
Discussion started by: faizsaadq
1 Replies

3. UNIX for Advanced & Expert Users

Unix scripting

i need help with this problem this is the problem: Write a script that logs how many users login on/off the system over a 5 minute period. It can run in the foreground, and run 4 times a minute. Set a trap that will not allow a CNTRL-C command, and if a CNTRL-C is excuted store the time and date... (1 Reply)
Discussion started by: sportsmansixty6
1 Replies

4. Shell Programming and Scripting

Unix scripting

how to check if a unix script gets executed without errors across all unix platforms. incase if a script gets executed without errors only one platform say AIX, what needs to be done to that script such that it will run all unix platforms like linux, hp, sun etc (2 Replies)
Discussion started by: rmann
2 Replies

5. Shell Programming and Scripting

Unix Scripting

Hi Gurus, I am a system admin in solaris field and ive planned to study unix scripting.ive planned to start reading Mastering Unix scripting by randal.Scripts in that are based on Korn shell(ksh).my question is whether the same scripts can be applied to other shells like bash etc..And... (4 Replies)
Discussion started by: madanmeer
4 Replies

6. UNIX for Dummies Questions & Answers

Unix Scripting

Hi Gurus, I am a system admin in solaris field and ive planned to study unix scripting.ive planned to start reading Mastering Unix scripting by randal.Scripts in that are based on Korn shell(ksh).my question is whether the same scripts can be applied to other shells like bash etc..And... (1 Reply)
Discussion started by: madanmeer
1 Replies

7. UNIX for Dummies Questions & Answers

Unix scripting pl help

Hi All, I am new to Unix Scripting. I have below scenario. I need to write a Unix function with the following. 1. I have table. From this table I need to write a query. SELECT Col1(File_nm),Col2(From_Loc),Col3(To_Loc) FROM A WHERE CONDITION For... (1 Reply)
Discussion started by: sree11
1 Replies

8. Shell Programming and Scripting

difference between AIX shell scripting and Unix shell scripting.

please give the difference between AIX shell scripting and Unix shell scripting. (2 Replies)
Discussion started by: haroonec
2 Replies

9. UNIX for Dummies Questions & Answers

Help With Unix Scripting.

Can anybody tell me the best way to learn unix scripting.can you recommend a good book.Please help! (1 Reply)
Discussion started by: hella
1 Replies

10. UNIX for Dummies Questions & Answers

UNIX Scripting

:confused: I need to find a place or places on the Internet where I can find UNIX scripts to view and to modify to make life easy on the UNIX environment. Can someone help me on this. Thanks (7 Replies)
Discussion started by: wolf
7 Replies
Login or Register to Ask a Question