AWK help 1

[dbadmin]

I have a file which has entries like this

dat1,dat2,dat3
datm,datn,dato
#dat1,dat3,data
dat2,datp,datq
daty,dat1,datb

The requirement which I have is to find the 2nd field when the first field is a particular value.

Assume the value I am checking is dat1 and the code should return dat2. If I use grep,the first, 3rd and 5th record will be returned. I can use awk to get the first field
and then remove the record with # and then get the second record, but I am unable to write the code for it. Could any one help me please.

Thanks,
dbadmin

 

[PHV]

If I use grep,the first, 3rd and 5th record will be returned
Even this ?
grep '^dat1,' /path/to/input

As you asked for awk:
awk -F, '$1=="dat1"{print $2}' /path/to/input

Hope This Helps, PH.
Want to get great answers to your Tek-Tips questions? Have a look at FAQ219-2884 or FAQ181-2886

 

[dbadmin]

Hi,

Thanks for the quick response. The ^ will help me but the problem will be, if I have an entry like dat12 that also will be returned.

dbadmin

 

[PHV]

Reread carefully my post !
grep '[!]^[/!]dat1[!],[/!]' /path/to/input

Hope This Helps, PH.
Want to get great answers to your Tek-Tips questions? Have a look at FAQ219-2884 or FAQ181-2886

 

[dbadmin]

It works like a charm. Thanks a lot

dbadmin