How to exclude certain colomn from the file?

Shell Programming and Scripting
1

Hi
I have a file in the following format:

4135    f4135acc:    39798  rmtdb:     0  /t1/data/f4135acc.dta   
4135    f4135pdb:    39795  rmtdb:     0  /bb/data/f4135pdb.dta    
4135    p4135eng:        0    rmtdb:     0  /bb/bin/p4135eng           
4135    r4135eng:    14142  rmtdb:     0  /bb/bin/r4135eng           
4137    f4137acc:    39862  rmtdb:     0  /t1/data/f4137acc.dta     
4137    f4137pdb:    39859  rmtdb:     0  /t1/data/f4137pdb.dta

I need to exclude all the lines from the file in which colomn #3 has entry 0

Is it possible to do it with awk ? Thanks a lot for advice -A

2

Use this:-

nawk '($3 != 0)' infile.txt

:D:D:D

3

Lets say, you input file name is a.txt, then

awk '$3!=0 {print }' a.txt
4

Or even:

awk '$3' infile
5

Thanks a lot guys !

6

Just for completeness (under par :wink: ), we could use this too of course:

awk \$3 infile
7

a very nice one Scrutinizer :cool::b: