awk - data filtering question
Hi, All
I have a file like this
chr 746996 C A 48 48 37 25 AAAAAAA
chr 747099 t C 45 45 37 6 c$CCCcc
chr 1003018 g C 36 36 37 20 ccc
I want to extract column 1, 2, 3, 4, 6, 8, 9. Also, I want to those rows in which the elements of column 8 are >=20.
I used
awk '$8>=20 {print $1,$2,$3,$4,$6,$8,$9}' input.txt > out.txt
it can just pick some of the rows where the column8's element >=20 but not all the right columns.
Can anybody help me on this?
I guess the way I used awk is not correct.
Thanks
|