topic Re: Match a field and print the line in Operating System - HP-UX

Match a field and print the line

Anand_30 — Mon, 29 Nov 2004 20:23:55 GMT

Hi,

I have a file with about 10000 lines. I have to match the 8th field of each line with a value (say "11") and output the line to another file if the field matches the value. Each field in the file is delimited with "|". I tried using

cat filename|awk -F "|" '{ if ($8 == 11 ) {getline; print $0}}

and also

cat filename | while read line
do
val=`cat -d"|" -f8 $line`
if [ $val -eq 11 ] ; then
echo $line
fi
done

Both did not work.

Can anyone please help me doing this.

Thanks,
Anand.

Re: Match a field and print the line

James A. Donovan — Mon, 29 Nov 2004 20:35:10 GMT

Does your second script really use "cat -d "|"
-f8 $line"? Or is that just a typo in your post?

You would want: val=`cut -d"|" -f8 $line`

Re: Match a field and print the line

A. Clay Stephenson — Mon, 29 Nov 2004 21:47:45 GMT

You are making this too hard:

awk -F '|' '{if ($8 == "11") print $0}' infilename > outfilename

If you want to evaluate $8 as an integer you need to coerce the type and change the comparison to
if (($8 + 0) == 11)

Re: Match a field and print the line

Yan Wong — Mon, 29 Nov 2004 21:54:29 GMT

try the following :
$cat test | awk -F "|" '$8 == 11 {print $0}'
or
val=$(cat -d "|" -f8 $line)

There are spaces in the field separators.

Re: Match a field and print the line

Yan Wong — Mon, 29 Nov 2004 22:15:50 GMT

should be
cat filename |

Re: Match a field and print the line

Muthukumar_5 — Mon, 29 Nov 2004 23:10:24 GMT

Yes. We can do with awk as,

awk -F "|" '{ if ( $8 == 11) print $0 }' >

Problem in your try is, you have matched one line's 8th element but print NEXT line there.

In next try,
try as,

while read line; do

val=`echo $line | cut -d"|" -f8`
if [ $val -eq 11 ] ; then
echo $line
fi

done <

HTH.