topic Re: Scripting help in Operating System - HP-UX

Scripting help

George Chechakunnil — Tue, 30 Oct 2007 02:15:26 GMT

hello Gurus,

I have a file which has some 10 coloumns. If the value of the 6th field is non zero value then i need to print out first field

STWBK01 2979 WNT FTA 40 0
USTWNA01 2979 WNT FTA 40 0
USTWA448 2979 WNT FTA 40 HI

Now i want the output as

USTWA448

As the 6th field here is not 0 but HI.

what awk combination shall i use to get this?

thanks in advance
George

Re: Scripting help

Sandman! — Tue, 30 Oct 2007 02:28:42 GMT

# awk '$6!=0 {print $1}' file

Re: Scripting help

rmueller58 — Wed, 31 Oct 2007 08:59:00 GMT

grep HI FILENAME |awk '{print $1}'

Re: Scripting help

Hein van den Heuvel — Wed, 31 Oct 2007 09:47:14 GMT

Rex>> grep HI FILENAME |awk '{print $1}'

Hmmm, thanks for playing, but that's just so wrong on so many levels!

1) Why bring our attention back to a problem with a perfect solution?

2) Why pipe through grep when awk is perfectly happy to read the file directly and pretty much designed to do the filtering. ( awk '/HI/{print $1}' FILENAME )

but most importantly...

3) this 'solution' will have false positives for records where other columns happen to have the character sequence HI in them

4) this 'solution' will have false negatives for cases where column 6 is not 0, but not HI either.

The question/requirement was

"If the value of the 6th field is non zero"

Cheers!
Hein.

Re: Scripting help

Peter Nikitka — Wed, 31 Oct 2007 13:11:54 GMT

Hi,

Hein, there is a shorter solution:
awk '$6+0 {print $1}' file
and yes, no forced conversion to integer is needed, even this will work:
awk '$6 {print $1}' file

The evaluation of $6 to TRUE will exactly succeed when the condition of Geoerge is met.

mfG Peter