Login or Register to Ask a Question and Join Our Community


Shell Programming and Scripting

Help needed on SED

Login to Discuss or Reply to this Discussion in Our Community

 
Thread Tools Search this Thread
Top Forums Shell Programming and Scripting Help needed on SED
# 1  
Old 04-29-2009
Help needed on SED
Hi,

I would like to process one file which looks like this :

09-04-16-17:11:53 -> count 1
NAME CHAN QID NMSGS NBYTES MAXBYTES P/T
W_DEALNUM 105 123508770 1 10 14 P
W_APPSTAT 106 123508771 1 12 35 P
W_QSTATUS 107 123508772 1 451 605 P
W_QSTATXX 108 123508773 1 2 905 P
W_QSTAT 109 123508774 1 241 245 P
W_QSTATXY 110 123508775 1 2 605 P
W_WORK 111 123508776 1 51 5500 P
W_CHKP 112 123508777 1 5 55 P
W_QUEUE30 270 100664459 14 294 25000 P
WSS Region Mailbox Totals: 22 messages, 1068 bytes
09-04-16-17:11:58 -> count 2
NAME CHAN QID NMSGS NBYTES MAXBYTES P/T
W_DEALNUM 105 123508770 1 10 14 P
W_APPSTAT 106 123508771 1 12 35 P
W_QSTATUS 107 123508772 1 451 605 P
W_QSTATXX 108 123508773 1 2 905 P
W_QSTAT 109 123508774 1 241 245 P
W_QSTATXY 110 123508775 1 2 605 P
W_WORK 111 123508776 1 51 5500 P
W_CHKP 112 123508777 1 5 55 P
W_QUEUE30 270 100664459 14 294 25000 P
WSS Region Mailbox Totals: 22 messages, 1068 bytes


into this

09-04-16-17:11:53 W_DEALNUM 105 123508770 1 10 14 P
09-04-16-17:11:53 W_APPSTAT 106 123508771 1 12 35 P
09-04-16-17:11:53 W_QSTATUS 107 123508772 1 451 605 P
09-04-16-17:11:53 W_QSTATXX 108 123508773 1 2 905 P
09-04-16-17:11:53 W_QSTAT 109 123508774 1 241 245 P
09-04-16-17:11:53 W_QSTATXY 110 123508775 1 2 605 P
09-04-16-17:11:53 W_WORK 111 123508776 1 51 5500 P
09-04-16-17:11:53 W_CHKP 112 123508777 1 5 55 P
09-04-16-17:11:53 W_QUEUE30 270 100664459 14 294 25000 P
09-04-16-17:11:58 W_DEALNUM 105 123508770 1 10 14 P
09-04-16-17:11:58 W_APPSTAT 106 123508771 1 12 35 P
09-04-16-17:11:58 W_QSTATUS 107 123508772 1 451 605 P
09-04-16-17:11:58 W_QSTATXX 108 123508773 1 2 905 P
09-04-16-17:11:58 W_QSTAT 109 123508774 1 241 245 P
09-04-16-17:11:58 W_QSTATXY 110 123508775 1 2 605 P
09-04-16-17:11:58 W_WORK 111 123508776 1 51 5500 P
09-04-16-17:11:58 W_CHKP 112 123508777 1 5 55 P
09-04-16-17:11:58 W_QUEUE30 270 100664459 14 294 25000 P

could you please help me..?
# 2  
Old 04-29-2009
With awk:

Code:
awk '/[0-9][0-9]-/{d=$1} /^W_/{print d, $0}' file

# 3  
Old 04-29-2009
Quote:
Originally Posted by Franklin52
With awk:

Code:
awk '/[0-9][0-9]-/{d=$1} /^W_/{print d, $0}' file

you're missing the 'date' record/line itself
Code:
nawk '/^[0-9][0-9]-/ {d=$1;print;next} $0=d OFS $0' myFile

# 4  
Old 04-30-2009
Quote:
Originally Posted by vgersh99
you're missing the 'date' record/line itself
Code:
nawk '/^[0-9][0-9]-/ {d=$1;print;next} $0=d OFS $0' myFile

vgersh99, this is what I get with my solution:

Code:
$ cat file
09-04-16-17:11:53 -> count 1
NAME CHAN QID NMSGS NBYTES MAXBYTES P/T
W_DEALNUM 105 123508770 1 10 14 P
W_APPSTAT 106 123508771 1 12 35 P
W_QSTATUS 107 123508772 1 451 605 P
W_QSTATXX 108 123508773 1 2 905 P
W_QSTAT 109 123508774 1 241 245 P
W_QSTATXY 110 123508775 1 2 605 P
W_WORK 111 123508776 1 51 5500 P
W_CHKP 112 123508777 1 5 55 P
W_QUEUE30 270 100664459 14 294 25000 P
WSS Region Mailbox Totals: 22 messages, 1068 bytes
09-04-16-17:11:58 -> count 2
NAME CHAN QID NMSGS NBYTES MAXBYTES P/T
W_DEALNUM 105 123508770 1 10 14 P
W_APPSTAT 106 123508771 1 12 35 P
W_QSTATUS 107 123508772 1 451 605 P
W_QSTATXX 108 123508773 1 2 905 P
W_QSTAT 109 123508774 1 241 245 P
W_QSTATXY 110 123508775 1 2 605 P
W_WORK 111 123508776 1 51 5500 P
W_CHKP 112 123508777 1 5 55 P
W_QUEUE30 270 100664459 14 294 25000 P
WSS Region Mailbox Totals: 22 messages, 1068 bytes
$
$ awk '
/[0-9][0-9]-/{d=$1}
/^W_/{print d, $0}
' file
09-04-16-17:11:53 W_DEALNUM 105 123508770 1 10 14 P
09-04-16-17:11:53 W_APPSTAT 106 123508771 1 12 35 P
09-04-16-17:11:53 W_QSTATUS 107 123508772 1 451 605 P
09-04-16-17:11:53 W_QSTATXX 108 123508773 1 2 905 P
09-04-16-17:11:53 W_QSTAT 109 123508774 1 241 245 P
09-04-16-17:11:53 W_QSTATXY 110 123508775 1 2 605 P
09-04-16-17:11:53 W_WORK 111 123508776 1 51 5500 P
09-04-16-17:11:53 W_CHKP 112 123508777 1 5 55 P
09-04-16-17:11:53 W_QUEUE30 270 100664459 14 294 25000 P
09-04-16-17:11:58 W_DEALNUM 105 123508770 1 10 14 P
09-04-16-17:11:58 W_APPSTAT 106 123508771 1 12 35 P
09-04-16-17:11:58 W_QSTATUS 107 123508772 1 451 605 P
09-04-16-17:11:58 W_QSTATXX 108 123508773 1 2 905 P
09-04-16-17:11:58 W_QSTAT 109 123508774 1 241 245 P
09-04-16-17:11:58 W_QSTATXY 110 123508775 1 2 605 P
09-04-16-17:11:58 W_WORK 111 123508776 1 51 5500 P
09-04-16-17:11:58 W_CHKP 112 123508777 1 5 55 P
09-04-16-17:11:58 W_QUEUE30 270 100664459 14 294 25000 P
$

With your solution I get:
Code:
$ nawk '/^[0-9][0-9]-/ {d=$1;print;next} $0=d OFS $0' file
09-04-16-17:11:53 -> count 1
09-04-16-17:11:53 NAME CHAN QID NMSGS NBYTES MAXBYTES P/T
09-04-16-17:11:53 W_DEALNUM 105 123508770 1 10 14 P
09-04-16-17:11:53 W_APPSTAT 106 123508771 1 12 35 P
09-04-16-17:11:53 W_QSTATUS 107 123508772 1 451 605 P
09-04-16-17:11:53 W_QSTATXX 108 123508773 1 2 905 P
09-04-16-17:11:53 W_QSTAT 109 123508774 1 241 245 P
09-04-16-17:11:53 W_QSTATXY 110 123508775 1 2 605 P
09-04-16-17:11:53 W_WORK 111 123508776 1 51 5500 P
09-04-16-17:11:53 W_CHKP 112 123508777 1 5 55 P
09-04-16-17:11:53 W_QUEUE30 270 100664459 14 294 25000 P
09-04-16-17:11:53 WSS Region Mailbox Totals: 22 messages, 1068 bytes
09-04-16-17:11:58 -> count 2
09-04-16-17:11:58 NAME CHAN QID NMSGS NBYTES MAXBYTES P/T
09-04-16-17:11:58 W_DEALNUM 105 123508770 1 10 14 P
09-04-16-17:11:58 W_APPSTAT 106 123508771 1 12 35 P
09-04-16-17:11:58 W_QSTATUS 107 123508772 1 451 605 P
09-04-16-17:11:58 W_QSTATXX 108 123508773 1 2 905 P
09-04-16-17:11:58 W_QSTAT 109 123508774 1 241 245 P
09-04-16-17:11:58 W_QSTATXY 110 123508775 1 2 605 P
09-04-16-17:11:58 W_WORK 111 123508776 1 51 5500 P
09-04-16-17:11:58 W_CHKP 112 123508777 1 5 55 P
09-04-16-17:11:58 W_QUEUE30 270 100664459 14 294 25000 P
09-04-16-17:11:58 WSS Region Mailbox Totals: 22 messages, 1068 bytes

Have I missed something?

Regards
# 5  
Old 04-30-2009
Code:
nawk '{
if($0 ~ /->/){
split($0,arr," ")
getline
}
else if ($0 ~ /Totals:/){
next
}
else{
	print arr[1]" "$0
}
}' a.txt

# 6  
Old 04-30-2009
Quote:
Originally Posted by Franklin52
vgersh99, this is what I get with my solution:

Code:
$ cat file
09-04-16-17:11:53 -> count 1
NAME CHAN QID NMSGS NBYTES MAXBYTES P/T
W_DEALNUM 105 123508770 1 10 14 P
W_APPSTAT 106 123508771 1 12 35 P
W_QSTATUS 107 123508772 1 451 605 P
W_QSTATXX 108 123508773 1 2 905 P
W_QSTAT 109 123508774 1 241 245 P
W_QSTATXY 110 123508775 1 2 605 P
W_WORK 111 123508776 1 51 5500 P
W_CHKP 112 123508777 1 5 55 P
W_QUEUE30 270 100664459 14 294 25000 P
WSS Region Mailbox Totals: 22 messages, 1068 bytes
09-04-16-17:11:58 -> count 2
NAME CHAN QID NMSGS NBYTES MAXBYTES P/T
W_DEALNUM 105 123508770 1 10 14 P
W_APPSTAT 106 123508771 1 12 35 P
W_QSTATUS 107 123508772 1 451 605 P
W_QSTATXX 108 123508773 1 2 905 P
W_QSTAT 109 123508774 1 241 245 P
W_QSTATXY 110 123508775 1 2 605 P
W_WORK 111 123508776 1 51 5500 P
W_CHKP 112 123508777 1 5 55 P
W_QUEUE30 270 100664459 14 294 25000 P
WSS Region Mailbox Totals: 22 messages, 1068 bytes
$
$ awk '
/[0-9][0-9]-/{d=$1}
/^W_/{print d, $0}
' file
09-04-16-17:11:53 W_DEALNUM 105 123508770 1 10 14 P
09-04-16-17:11:53 W_APPSTAT 106 123508771 1 12 35 P
09-04-16-17:11:53 W_QSTATUS 107 123508772 1 451 605 P
09-04-16-17:11:53 W_QSTATXX 108 123508773 1 2 905 P
09-04-16-17:11:53 W_QSTAT 109 123508774 1 241 245 P
09-04-16-17:11:53 W_QSTATXY 110 123508775 1 2 605 P
09-04-16-17:11:53 W_WORK 111 123508776 1 51 5500 P
09-04-16-17:11:53 W_CHKP 112 123508777 1 5 55 P
09-04-16-17:11:53 W_QUEUE30 270 100664459 14 294 25000 P
09-04-16-17:11:58 W_DEALNUM 105 123508770 1 10 14 P
09-04-16-17:11:58 W_APPSTAT 106 123508771 1 12 35 P
09-04-16-17:11:58 W_QSTATUS 107 123508772 1 451 605 P
09-04-16-17:11:58 W_QSTATXX 108 123508773 1 2 905 P
09-04-16-17:11:58 W_QSTAT 109 123508774 1 241 245 P
09-04-16-17:11:58 W_QSTATXY 110 123508775 1 2 605 P
09-04-16-17:11:58 W_WORK 111 123508776 1 51 5500 P
09-04-16-17:11:58 W_CHKP 112 123508777 1 5 55 P
09-04-16-17:11:58 W_QUEUE30 270 100664459 14 294 25000 P
$

With your solution I get:
Code:
$ nawk '/^[0-9][0-9]-/ {d=$1;print;next} $0=d OFS $0' file
09-04-16-17:11:53 -> count 1
09-04-16-17:11:53 NAME CHAN QID NMSGS NBYTES MAXBYTES P/T
09-04-16-17:11:53 W_DEALNUM 105 123508770 1 10 14 P
09-04-16-17:11:53 W_APPSTAT 106 123508771 1 12 35 P
09-04-16-17:11:53 W_QSTATUS 107 123508772 1 451 605 P
09-04-16-17:11:53 W_QSTATXX 108 123508773 1 2 905 P
09-04-16-17:11:53 W_QSTAT 109 123508774 1 241 245 P
09-04-16-17:11:53 W_QSTATXY 110 123508775 1 2 605 P
09-04-16-17:11:53 W_WORK 111 123508776 1 51 5500 P
09-04-16-17:11:53 W_CHKP 112 123508777 1 5 55 P
09-04-16-17:11:53 W_QUEUE30 270 100664459 14 294 25000 P
09-04-16-17:11:53 WSS Region Mailbox Totals: 22 messages, 1068 bytes
09-04-16-17:11:58 -> count 2
09-04-16-17:11:58 NAME CHAN QID NMSGS NBYTES MAXBYTES P/T
09-04-16-17:11:58 W_DEALNUM 105 123508770 1 10 14 P
09-04-16-17:11:58 W_APPSTAT 106 123508771 1 12 35 P
09-04-16-17:11:58 W_QSTATUS 107 123508772 1 451 605 P
09-04-16-17:11:58 W_QSTATXX 108 123508773 1 2 905 P
09-04-16-17:11:58 W_QSTAT 109 123508774 1 241 245 P
09-04-16-17:11:58 W_QSTATXY 110 123508775 1 2 605 P
09-04-16-17:11:58 W_WORK 111 123508776 1 51 5500 P
09-04-16-17:11:58 W_CHKP 112 123508777 1 5 55 P
09-04-16-17:11:58 W_QUEUE30 270 100664459 14 294 25000 P
09-04-16-17:11:58 WSS Region Mailbox Totals: 22 messages, 1068 bytes

Have I missed something?

Regards
Yes, you're "missing" 2 lines that determine the timestamps - I'll highlight them in the original file and MY output.
# 7  
Old 04-30-2009
Hi Thank you so much every one.. i have got the output exactly how i wanted ... Thank you !!!
Login or Register to Ask a Question

Previous Thread | Next Thread

10 More Discussions You Might Find Interesting

1. Shell Programming and Scripting

sed Help Needed

I want to search texts between first occurence of the matching pattern and replace it with some other text.pls advice what can be done. I searched alot, i could not find anything relevant. Ex my input is as follows: red yellow grey white blue red pink violet white I want to search... (9 Replies)
Discussion started by: sangitajc
9 Replies

2. Shell Programming and Scripting

some sed help needed

I have file with following contents; 127.0.0.1 www.google.com 127.3.3.1 www.cisco.com 127.3.5.1 www.msnbc.com I want output as 127.0.0.1 www.google.com google.com 127.3.3.1 www.cisco.com cisco.com 127.3.5.1 www.msnbc.com msnbc.com I tried sed 's/www.//g'... (5 Replies)
Discussion started by: sangfroid
5 Replies

3. Shell Programming and Scripting

help needed with SED

Hello! I have a "problem" with sed... In a log, I'm wondering how to have the name of the application when "INCIDENT" is in the file... The name of the application is before "INCIDENT". For this example, The result should be "SPVP0005" thanks for your help! (7 Replies)
Discussion started by: Castelior
7 Replies

4. Shell Programming and Scripting

Help Needed in SED

Hi All , I have a input file which has set of lines like this :: cat a.txt unix1 djkdfkjdkkdfkdjfdfkjd 09191091 unix@unix.com <2008-23-07> unix 2 dfdfdfdfdfdfdfdfdfd unix3 dfldfljdflkjdfldfkljdfldjfl 0565606 unix1@unix.com <2008-10-09> unix4 dfdlfndfldflnlffddfd for some... (4 Replies)
Discussion started by: raghav1982
4 Replies

5. UNIX for Dummies Questions & Answers

SED Help Needed

I am trying to retrieve part of a line from /boot/grub/menu.lst The line is : gfxmenu (hd0,0)/usr/share/gfxboot/themes/pclinuxblue/boot/message I have figured out how to get this line into a file by itself. sed '/gfxmenu/ !d' /boot/grub/menu.lst > /tmp/menu.lst.pcl_tc What I need to... (2 Replies)
Discussion started by: Tide
2 Replies

6. Shell Programming and Scripting

Sed help needed

Hi, I have the following texts : #1#http://www.google.com#2#Google#3# #1#http://www.aol.com#2#AOL#3# I need a bash script which extracts the text between the markers (marks are #1#,#2#,#3#). I also need that text in variables ($URL and $DESCRIPT will be fine) so I can later use it to... (3 Replies)
Discussion started by: tcp27br
3 Replies

7. Shell Programming and Scripting

help with sed needed

Hi, I have a file in a form of jkkhjjk1:!:jkhdjkhjkh2:!:kljkljkljklj3:!:kljsdj4 kljlkfljf5:!:kjljljlj6:!:jhjkhjkh7 I am trying to use sed command such that everytime it find ":!:" it will removes it and print remaining of the line on the new line Output that I need will look like following... (8 Replies)
Discussion started by: arushunter
8 Replies

8. Shell Programming and Scripting

Help Needed -sed

Hi All, i have one file and in that i have to read each line and do some replacement. its is not fixed the number or column always be same it can be less also exm a;b;c;d;e;f (line) i have to do something like In the line If c is present then go to end of line and append ';date' else... (9 Replies)
Discussion started by: ravi.sadani19
9 Replies

9. Shell Programming and Scripting

Sed help needed

Could someone tell me how to replace varibles using SED inside Korn Shell? e.g. I have a ksh file program.ksh below: ------------------------------------ #!/bin/ksh sed -n '/ABC/p' $1 > output.txt if ] then status=new elif ] then status=old fi sed -n '/$status/p' $1... (5 Replies)
Discussion started by: stevefox
5 Replies

10. UNIX for Dummies Questions & Answers

Help needed with sed

Hi, I need to insert a line into a file underneath an existing line in the file, but am unsure as to the syntax. I'm pretty sure sed can be used though, although any ideas are more than welcome. For example: File ---- Line 1 Line 2 Line 3 Line 4 Line 6 I need to say: Insert "Line 5"... (1 Reply)
Discussion started by: danhodges99
1 Replies
Login or Register to Ask a Question