Shell Programming and Scripting

hi,
total newbie to shell scripting and wondering if some of you guru's can give me a hand on a problem I'm trying to solve.

The tmplsnr.a file contains

Code:

LSNR_51526
db1
db2
LSNR_51527
db3
db4
db5

Summary - depending on which db is set, the script will start the relevant listener (LSNR_). e.g if db5 is set then the script will start the LSNR_51527 listener.

I was thinking the best way maybe to put this information into an array and then search the array.

I want to read the above file into a two dimensional array and the array to looks like this so that I can search the corresponding LSNR for the db.

Code:

LSNR_51526,db1
LSNR_51526,db2
LSNR_51527,db3
LSNR_51527,db4
LSNR_51527,db5

How would I search the array for the listener (LSNR_51527) which relates to db5 ?

Would this method work or have I over complicated things or is there a much simpler method in korn scripting.

I would appreciate any feedback or help

Many Thanks in Advance

This will give you listener name based on the database name (assuming you are using Linux):

Code:

awk -vx="db5" '/^LSNR_/{l=$0}$0==x{print l}' tmplsnr.a

Code:

awk '/^LSNR_/{lsn=$0}lsn!=$0{print lsn,$0}' OFS=, tmplsnr.a
LSNR_51526,db1
LSNR_51526,db2
LSNR_51527,db3
LSNR_51527,db4
LSNR_51527,db5

Thank you Bartus11 ! that is so impressive - the power of awk in just one line - just to let you know i'm working on AIX and using Korn and your code works a treat. I had an issue at first because the tmplsnr.a wasn't formatted - it had spaces before the db's - i will need to sort that bit out in the future.

LSNR_51526
<spaces>db1
<spaces>db2
LSNR_51527
<spaces>db3
<spaces>db4
<spaces>db5
I have no idea how that works, but it's so cool, can you give me a quick explanation on how that piece of code works. Thanks

To fix spaces problem:

Code:

awk -vx="db5" '/^LSNR_/{l=$0}$1==x{print l}' tmplsnr.a

The algorithm is pretty simple. It is saving name of the last encountered listener (line starting with LSNR) and prints it when it finds database name.

If you want to use bash/ksh/sh:

Code:

while read line                    
do                                 
if [ `echo $line|cut -c1-1` =  L ] 
then                               
        hdg=$line                  
else                               
        echo $hdg,$line            
fi                                 
done <data