AWK including headers

[Mike2011]

Hi guys,

I'd recently the problem to include the header row in my result set.

This is my awk command:
bzcat .....txt.bz2 |awk '{if($1=="2011-05-17"&&$3=="2342"&&$6=="2452"){print $1,$3,$6}}'

I've tried the following:
1. bzcat .....txt.bz2 |awk '{if($1=="2011-05-17"&&$3=="2342"&&$6=="2452"){print $1,$3,$6}}' | head -0

2. bzcat .....txt.bz2 | head -0 | awk '{if($1=="2011-05-17"&&$3=="2342"&&$6=="2452"){print $1,$3,$6}}'

Both approaches didn't work. Any ideas what I'm doing wrong?

Much appreciate,
Mike

 

[CaKiwi]

What are you trying to do? head -0 prints the first zero lines of input, i.e. nothing

CaKiwi

 

[LKBrwnDBA]

It's not clear what you want, but assuming it's to print the first line, then do this:

bzcat .....txt.bz2 |\
awk '
{if(NR==1){print $1,$3,$6};
 if($1=="2011-05-17"&&$3=="2342"&&$6=="2452"){print $1,$3,$6}
}'

----------------------------------------------------------------------------
The person who says it can't be done should not interrupt the person doing it. -- Chinese proverb

 

[PHV]

You wanted this ?

bzcat .....txt.bz2 |awk '{if(NR==1||($1=="2011-05-17"&&$3==2342&&$6==2452))print $1,$3,$6}'

Hope This Helps, PH.
FAQ219-2884
FAQ181-2886

 

[Mike2011]

Thanks guys for your help!

The suggestion from PHV did the job!

Thanks,
Mike