Search Results

That does the job, thank you!

(I was reading quickly and skipped over your solution thinking it was just a quote from the previous message.)

Yes that's right. That's a better way of saying it.
So if input is:
comp51820_c1_seq1 405 N 0:29:0:0:0:0 0:51:0:0:0:0 0:57:0:0:0:0 0:6:0:0:0:0 0:37:0:0:0:0
comp51820_c1_seq1 ...

This works to exclude the correct lines, but it also excludes a line that should be accepted (since the five sums (one from each column) are all >= 8). Desired output is:...

This works for the example file, but when I try it with my larger file there are some issues. For example if these lines are the input:...

Thank you, this works. Would you mind also showing how I would do it if I did not want to exclude the fifth value? So just print lines where the sum of ALL values in each of columns 4-8 is at least...

If I'm not mistaken, this seems to print all files with at least one value >=8. I get the output:
comp51820_c1_seq1 44 N 0:0:4:0:3:1 0:0:1:9:0:0 10:0:0:0:0:0 0:3:3:2:2:6 2:2:2:5:60:3...

Hello out there,

file.txt:
comp51820_c1_seq1 42 N 0:0:0:0:0:0 1:0:0:0:0:0 0:0:0:0:0:0 3:0:0:0:0:0 0:0:0:0:0:0
comp51820_c1_seq1 43 N 0:0:0:0:0:0 0:1:0:0:0:0 0:0:0:0:0:0 0:3:0:0:0:0 0:0:0:0:0:0...