Need this output


 
Thread Tools Search this Thread
Top Forums Shell Programming and Scripting Need this output
# 1  
Old 12-25-2012
Need this output

i have a text with the following
Code:
ora.epayprd.db
      1                                                              OFFLINE       ONLINE            sec37-7                          Open
      2                                     ONLINE          ONLINE           sec36-8                          Open
ora.scan1.vip
      1                                   ONLINE          OFFLINE         sec36-8

I need the output to be like this only the line which contains offline word

Code:
ora.epayprd.db:OFFLINE :ONLINE: sec37-7: Open
ora.epayprd.db: ONLINE:ONLINE:sec36-8:Open
ora.scan1.vip:ONLINE:OFFLINE: sec36-8


Last edited by Scrutinizer; 12-26-2012 at 04:15 AM.. Reason: quote tags => code tags
# 2  
Old 12-25-2012
I can't see your desired output to be related to neither input nor requirement phrasing.
# 3  
Old 12-25-2012
ok i updated it please check if you can get the output from this text
# 4  
Old 12-25-2012
Quote:
Originally Posted by maxim42
i have a text with the following
Code:
ora.epayprd.db
1 OFFLINE ONLINE sec37-7 Open
2 ONLINE ONLINE sec36-8 Open
ora.scan1.vip
1 ONLINE OFFLINE sec36-8

I need the output to be like this only the line which contains offline word
Code:
ora.epayprd.db:OFFLINE : ONLINE: sec37-7: Open
ora.epayprd.db: OFFLINE: ONLINE: sec36-8: Open
ora.ARCHIVES_DG.dg: OFFLINE: ONLINE: sec36-8

Given the 1st three lines of your input:
Code:
ora.epayprd.db
1 OFFLINE ONLINE sec37-7 Open
2 ONLINE ONLINE sec36-8 Open

I can see how to get the 1st two lines of your desired output:
Code:
ora.epayprd.db:OFFLINE : ONLINE: sec37-7: Open
ora.epayprd.db: OFFLINE: ONLINE: sec36-8: Open

if I ignore that inconsistent spacing before and after the colons. But, given the last two lines of your input:
Code:
ora.scan1.vip
1 ONLINE OFFLINE sec36-8

I don't see any way to magically transform that into:
Code:
ora.ARCHIVES_DG.dg: OFFLINE: ONLINE: sec36-8

How are we supposed to determine that ora.scan1.vip should be translated to ora.ARCHIVES_DG.dg and that ONLINE OFFLINE should be reordered to be OFFLINE: ONLINE:. If you want us to help you, you need to give us a much better description of the processing involved that makes these transformations.
# 5  
Old 12-26-2012
so sorry i didn't see this word
ora.ARCHIVES_DG.dg


i edited the output again
# 6  
Old 12-26-2012
Code:
$ cat file
ora.epayprd.db
1 OFFLINE ONLINE sec37-7 Open
2 ONLINE ONLINE sec36-8 Open
ora.scan1.vip
1 ONLINE OFFLINE sec36-8

Code:
$ awk '{if($0 ~ /^ora/){s=$0} else{sub($1,"");gsub(FS,":");print s,$0}}' file
ora.epayprd.db :OFFLINE:ONLINE:sec37-7:Open
ora.epayprd.db :ONLINE:ONLINE:sec36-8:Open
ora.scan1.vip :ONLINE:OFFLINE:sec36-8

# 7  
Old 12-26-2012
could you explain what "else{sub($1,"")" this mean to understand this script what $1 mean ?

thanks alot
Login or Register to Ask a Question

Previous Thread | Next Thread

10 More Discussions You Might Find Interesting

1. Shell Programming and Scripting

Redirect script output to a file and mail the output

Hi Guys, I want to redirect the output of 3 scripts to a file and then mail the output of those three scripts. I used below but it is not working: OFILE=/home/home1/report1 echo "report1 details" > $OFILE =/home/home1/1.sh > $OFILE echo... (7 Replies)
Discussion started by: Vivekit82
7 Replies

2. Red Hat

Command understanding the output file destination in case of standard output!!!!!

I ran the following command. cat abc.c > abc.c I got message the following message from command cat: cat: abc.c : input file is same as the output file How the command came to know of the destination file name as the command is sending output to standard file. (3 Replies)
Discussion started by: ravisingh
3 Replies

3. Shell Programming and Scripting

Displaying log file pattern output in tabular form output

Hi All, I have result log file which looks like this (below): from the content need to consolidate the result and put it in tabular form 1). Intercomponents Checking Passed: All Server are passed. ====================================================================== 2). OS version Checking... (9 Replies)
Discussion started by: Optimus81
9 Replies

4. Shell Programming and Scripting

script to mail monitoring output if required or redirect output to log file

Below script perfectly works, giving below mail output. BUT, I want to make the script mail only if there are any D-Defined/T-Transition/B-Broken State WPARs and also to copy the output generated during monitoring to a temporary log file, which gets cleaned up every week. Need suggestions. ... (4 Replies)
Discussion started by: aix_admin_007
4 Replies

5. Shell Programming and Scripting

Awk script to run a sql and print the output to an output file

Hi All, I have around 900 Select Sql's which I would like to run in an awk script and print the output of those sql's in an txt file. Can you anyone pls let me know how do I do it and execute the awk script? Thanks. (4 Replies)
Discussion started by: adept
4 Replies

6. Shell Programming and Scripting

awk: round output or delimit output of arithmatic string

I have a file with the following content. > cat /tmp/internetusage.txt 6709.296322 30000 2/7/2010 0.00I am using the following awk command to calculate a percentage from field 1 and 2 from the file. awk '{ print $1/$2*100 }' /tmp/internetusage.txt This outputs the value "22.3643" as a... (1 Reply)
Discussion started by: jelloir
1 Replies

7. Shell Programming and Scripting

Converting line output to column based output

Hi Guys, I am trying to convert a file which has a row based output to a column based output. My original file looks like this: 1 2 3 4 5 6 1 2 3 1 2 3 (8 Replies)
Discussion started by: npatwardhan
8 Replies

8. Shell Programming and Scripting

top output for six processes with the same name, output changed from column to row

Hi, I have a system under test, and I use a script that does a ps. The output, is in the following format, it's basically the timestamp, followed by the rss and vsize. 09:03:57 68404 183656 68312 181944 69860 217360 67536 182564 69072 183172 69032 199276 09:04:27 68752 183292 70000 189020... (5 Replies)
Discussion started by: Bloke
5 Replies

9. Shell Programming and Scripting

Expect - Interact output hangs when large output

Hello, I have a simple expect script I use to ssh to a workstation. I then pass control over to the user with interact. This script works fine on my HP and Mac, but on my Linux Desktop, I get a problem where the terminal hangs when ever I execute a command in the interact session that requires a... (0 Replies)
Discussion started by: natedog
0 Replies

10. Shell Programming and Scripting

how to make a line BLINKING in output and also how to increase font size in output

how to make a line BLINKING in output and also how to increase font size in output suppose in run a.sh script inside echo "hello world " i want that this should blink in the output and also the font size of hello world should be big .. could you please help me out in this (3 Replies)
Discussion started by: mail2sant
3 Replies
Login or Register to Ask a Question