topic How to select a string from a file in Operating System - HP-UX

How to select a string from a file

Kellogg Unix Team — Tue, 21 Oct 2008 18:30:38 GMT

I have a file (file1) containing unique numbers, that I want to use to extract information from another file (file2).
file1 has the following contents -
14
15
20
201
202

file2 has the following text -
RaidGroup ID 14 Logical Capacity 23456 Free Capacity 12345
RaidGroup ID 20 Logical Capacity 23456 Free Capacity 12341
RaidGroup ID 204 Logical Capacity 23456 Free Capacity 12342
RaidGroup ID 202 Logical Capacity 23456 Free Capacity 12343
RaidGroup ID 2 Logical Capacity 23456 Free Capacity 12344

For each entry in file1 (which is field 3 in file2), I have to extract Free Capacity from file2. How do I structure my query so that when I awk for 20, I don't get results for 202 & 204 as well.

for x in `cat file1`
do
awk '$3 ~ /$x/' file2|awk '{print $NF}'
# The above line also gives error
done

Thanks.

Re: How to select a string from a file

James R. Ferguson — Tue, 21 Oct 2008 18:51:14 GMT

Hi:

# awk -v x=20 '$3==x' file2
RaidGroup ID 20 Logical Capacity 23456 Free Capacity 12341

Regards!

...JRF...

Re: How to select a string from a file

Kellogg Unix Team — Tue, 21 Oct 2008 19:10:19 GMT

Bull's Eye! Thanks JRF!

Here is the quick solution -

for x in `cat file1`
do
awk -v x=$x '$3==x' file2
done

Thanks again.

Re: How to select a string from a file

Steven Schweda — Tue, 21 Oct 2008 21:50:24 GMT

> [...] so that when I awk for 20, I don't
> get results for 202 & 204 as well.

Including some white space in your search
string can help, too.

dy # x=20

dy # grep "$x" file2
RaidGroup ID 20 Logical Capacity 23456 Free Capacity 12341
RaidGroup ID 204 Logical Capacity 23456 Free Capacity 12342
RaidGroup ID 202 Logical Capacity 23456 Free Capacity 12343

dy # grep " $x " file2
RaidGroup ID 20 Logical Capacity 23456 Free Capacity 12341