extract the data using AWK command

Shell Programming and Scripting
1

In a file i have a data like
INPUT:

no,name,company
1,vivek,hcl
2,senthil,cts
1,narsi,hcl
4,prabhakaran,ibm

OUTPUT:

1,vivek,hcl
1,narsi,hcl

Using AWK command i want to display the names those having no:1 and company:hcl.Please tell me the command to display above result.

2 
awk -F, '$1==1 && $3=="hcl"' inputfile
3

thanks,please tell the command if i want to delete the line which has $1=1 and $3="hcl"

4 
sed -n '/1,\(.*\),hcl/!p' infile

or

sed '/1,\(.*\),hcl/d'  infile
5

cant we achive this using AWK command?

6 
awk -F, '$1==1 && $3=="hcl"{next}1' inputfile
7

ctsgnb posted

8

Simply reverse the logic with !( ... )

9

Its working fine,Thanks.