Hi All,

i have a variable which has a value in it.
RETAILER='JEWL'

i have a text file. Name: file.txt

file.txt
________
WLG 150
JEWL 60
CVS 240
FLN 120
WND 120


I am trying to write a korn script.the script, based on the value in the RETAILER will do a look up against the file.txt. if match found then return the corresponding value in the 2nd column in the file.txt.

Eg: do a look up with RETAILER with file.txt.
JEWL and JEWL (in file.txt) match found then return the value corresponding to JEWL in file.txt i.e 60.

Eg2: RETAILER='WLG'. do a look up with file.txt and return 150.

can anyone please help me. ( korn shell)

Thanks & Regards
pavi.

cat file.txt | awk '/JEWL/ {print $2}'


cat the file and pipe it to awk. Awk is a pattern/action language. The above simple script will look for the pattern JEWL and print the 60 that is the second feild of the row that begins with JEWL.

So you can pull in a variable on the command line and then if that variable matches any of the first feilds of the file.txt file, then, print feild 2.


try this on the command line so that you can see the above program string work. Then we can talk about translating the rest of the algorithm into ksh.


-Douglas

Thanks a lot

hello Douglas,

i tried this one;
cat file.txt | awk '/JEWL/ {print $2}'

but i am not getting any output.

thanks
pavi

ducatisti, you need not use cat. Use awk directly on the file.
try this:
For solaris, use nawk instead of awk.

Yea I know, but I was workin gto explain that the file was being worked through for Pavi's benefit. But thanks. And this will also save a process.