find the first instance after a string


 
Thread Tools Search this Thread
Top Forums Shell Programming and Scripting find the first instance after a string
# 1  
Old 05-01-2009
find the first instance after a string

I have this file (below) and need to get out specific data that appears after OSE1_1.FIX, but before OSE1_2.FIX.
Specifically I need to get all of the data after "ROW80_20:", "ROW80_21:", "ROW80_22:" & "ROW80_23:" then I need to do the same for data the appears after OSE1_2.FIX, but before OSE1_3.FIX. (again for the same ROW80_XX).
I then need to format the data so that it stays in the same rows as it has appeared in the file i.e.

file ...

Received DF_STATUS,item = OSE1_1.FIX dataFormat = 2, item =
ROW80_16: Port 2 message rate 0 0
ROW80_6:
ROW80_20:Clients: xtky2143pmd xtky2140pmd xtky2141pmd 127.60.194.1
ROW80_21: Username:mdh_ai1p2_dma mdh_tk3p1_dma mdh_tk3p2_dma tk3d_ose1
ROW80_11: Line Handler Info LHOSERDT LHFIXRDT
ROW80_22: Watchlist: 4 6 10 55
ROW80_12: Uptime 002d05h17m 002d05h17m
ROW80_23: Max watch: 30 0 12 80
Received DF_STATUS, item = OSE1_2.FIX
ROW80_16: Port 2 message rate
ROW80_6:
ROW80_20: Clients: 127.60.194.1
ROW80_10:
ROW80_21: Username: rmds1
ROW80_22: Watchlist: 45
ROW80_12: Uptime
ROW80_23: Max watch: 60
Received DF_STATUS, item = OSE1_3.FIX

required output ...

Clients: , xtky2143pmd , xtky2140pmd , xtky2141pmd , 127.60.194.1 , 127.60.194.1
Username:, mdh_ai1p2_dma , mdh_tk3p1_dma , mdh_tk3p2_dma , tk3d_ose1 , rmds1
Watchlist:, 4 , 6 , 10 , 55 , 45
Max_watch:,30 , 0 , 12 , 80 , 60


(NOTE: My existing output from this script
cat $MY_FILE | grep ROW80_20: | head -2 |awk '{print $2 "," $3 "," $4 "," $5 "," $6 "," $7 "," $8}' > $MY_CLIENTS
cat $MY_FILE | grep ROW80_21: | head -2 |awk '{print $2 "," $3 "," $4 "," $5 "," $6 "," $7 "," $8}' >> $MY_CLIENTS
cat $MY_FILE | grep ROW80_22: | head -2 |awk '{print $2 "," $3 "," $4 "," $5 "," $6 "," $7 "," $8}' >> $MY_CLIENTS
cat $MY_FILE | grep ROW80_23: | head -2 |awk '{print $2 " " $3 "," $4 "," $5 "," $6 "," $7 "," $8}' >> $MY_CLIENTS

is....

Clients:,xtky2143pmd,xtky2140pmd,xtky2141pmd,147.60.194.1,,
Clients:,147.60.194.1,,,,,
Username:,mdh_ai1p2_dma,mdh_tk3p1_dma,mdh_tk3p2_dma,tk3d_ose1,,
Username:,rmds1,,,,,
Watchlist:,4,6,10,55,,
Watchlist:,45,,,,,
Max watch:,30,0,12,80,
Max watch:,60,,,,

Many thanks for all your help!!
# 2  
Old 05-01-2009
Code:
awk -F ":" '$0 ~ /ROW80_20/{n1=$2;c=c $3}
$0 ~ /ROW80_21/{n2=$2;u=u $3}
$0 ~ /ROW80_22/{n3=$2;w=w $3}
$0 ~ /ROW80_23/{n4=$2;m=m $3}END{print n1,c;print n2,u;print n3,w;print n4,m}' OFS=":" FILENAME

Cheers,
Devaraj Takhellambam
# 3  
Old 05-19-2009
Superb - thanks devtakh, that works a treat.
Login or Register to Ask a Question

Previous Thread | Next Thread

10 More Discussions You Might Find Interesting

1. Shell Programming and Scripting

grep for a string until instance of a space

Hey guys, I'm having a bit of trouble getting this to work using either sed or grep. It's possible awk might be the ticket I need as well, but my regulat expression skills aren't quite up to the task for doing this. I'm looking to grep for the string ERROR from the following log up until any... (6 Replies)
Discussion started by: terrell
6 Replies

2. Shell Programming and Scripting

Complex find and replace only 1st instance string with dynamic combination

test.txt is the dynamic file but some of combination are fix like below are the lines ;wonder_off = ;wonder_off = disabled wonder_off = wonder_off = disabled the test.txt can content them in any order #cat test.xt ;wonder_off = ;wonder_off = disabled wonder_off = wonder_off =... (5 Replies)
Discussion started by: SilvesterJ
5 Replies

3. Shell Programming and Scripting

grep second instance of same string

Hi all, i am new to unix scripting in ksh or any shell for that matter. I have downloaded a xml file from a website and saved on my local harddrive. inside the xml, the same tag is listed multiple times. <title>Tonight</title> <title>Thursday</title> <title>Friday</title>... (6 Replies)
Discussion started by: scubasteve39
6 Replies

4. Shell Programming and Scripting

Search text file, then grep next instance of string

I need to be able to search for a beginning line header, then use grep or something else to get the very next instance of a particular string, which will ALWAYS be in "Line5". What I have is some data that appears like this: Line1 Line2 Line3 Line4 Line5 Line6 Line7 Line1 Line2 ...... (4 Replies)
Discussion started by: Akilleez
4 Replies

5. Shell Programming and Scripting

awk - last instance of a string

How do I use awk to find the last occurence of a string in a file? (3 Replies)
Discussion started by: locoroco
3 Replies

6. Shell Programming and Scripting

awk - find first instance of string after NR==10

How do I use awk to find the NR of first instance of a specific string after eg NR==10? I need to find the first instance of the word "class" after a specific NR. (2 Replies)
Discussion started by: locoroco
2 Replies

7. UNIX for Dummies Questions & Answers

replacing a particular instance in a string globally

Hi, I'm trying to update the last two characters coming in a string globally in a file. Here is the sample data: file1 In file1, I want to have all instances replace where _o is appearing in the end of a word with _g. If _o is appearing in the middle or any other position except the... (2 Replies)
Discussion started by: er_ashu
2 Replies

8. Shell Programming and Scripting

Search the last instance of a string in a file

I have a big database log file which keepsgrowing daily. OS is HP UX. Here is a small part of it: Tue Jan 27 04:03:22 2009 : add session begin for mfgeb on /dev/pts/th. : Converting relative path to absolute path. : add session end. Tue Jan 27 04:03:29... (6 Replies)
Discussion started by: dinesh1178
6 Replies

9. UNIX for Dummies Questions & Answers

Find first instance of pattern

I am using grep to find header info in a file and print it to another file. The header info only shows up on line 3 and 4 so i really don't need to search the remainder of the file. the grep -m option doesn't work with my version of UNIX. Also I'm new to UNIX so could you please explain what... (4 Replies)
Discussion started by: NobluesFDT
4 Replies

10. Shell Programming and Scripting

replace nth instance of string

Hi all, I have file with following content ........................... ..........TEST.......... ..........TEST.......... ..................... .....TEST.......... ..................... ..................... .....TEST.......... I want to replace nth "TEST" with "OK" using... (4 Replies)
Discussion started by: uttamhoode
4 Replies
Login or Register to Ask a Question