awk code question

Question

[rbronste]

Quick question for those that use awk often, what would the following command do to a narrowPeak file:

awk '{if ($8 > 8) print}'

Thanks

[st.ph.n]

I don't know what a narrowPeak file looks like (it would help if you showed an example in your post), but that would print the entire line, where column 8 is greater than 8. I typically use a syntax such as this:

awk -F'\t' '{if($8>8) { print } }' infile.txt

[rbronste]

So basically I am trying to modify the following command:

zcat $dnase | awk '{if ($8 > 8) print}' | gzip > $dnase_gt8

The command is designed for the narrowPeak file (example above) but I have another file I would like to use with only 5 columns.

Answer 1

[Pierre Lindenbaum]

awk '{if ($8 > 8) print}'

using any number of spaces as the delimiter and for any string, if the integer value of the 8th column is greater than 8, then print the whole line.

Which can be simplified as

awk '($8>8)'

[shenwei356]

just need awk '$8>8'

[rbronste]

Thank you, extremely helpful!

[Pierre Lindenbaum]

It it answers the question please mark it as answered to close it (green tick on the left).