delete rows with a criteria

UNIX for Beginners Q & A UNIX for Dummies Questions & Answers
1

Hi,

I would like to know how can I delete rows of a text file if from the 3rd column onwards there is only zeros?

Thanks in advance

2

Please provide an input sample and desired output and what you have tried so far..

3

Thanks for the reply.

Example Input file:

a b 0 0 0 0 0
a d 0 1 0 0 1.5
d r 0 0 0 0 0

Desired output file:

a d 0 1 0 0 1.5
4

Perhaps:

egrep -v "^[^ ]+ +[^ ]+( +0)*$" filename > outfile
5

another way

awk '{x=0;for(i=3;i<=NF;i++)x+=$i}x>0' infile
6 
awk '$3||$4||$5||$6||$7' infile
7 
awk '{for(i=3;i<=NF;i++)if($i>0){print;next}}' input.txt
8

Thanks a lot to everyone!
I am also interested in getting a similar output but now only output the lines where the number of zeros in each row (starting from column 3) is equal or less than 5% of the total numbers per line (also starting only at column 3).

Thanks in advance