Scripting help

[George Chechakunnil]

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

[Sandman! · Accepted solution]

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

[rmueller58]

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

[Hein van den Heuvel]

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.

[Peter Nikitka]

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