dividing file into two files using cutoff value from a column?

Question

[1234anjalianjali1234]

Hi,

I have a FILE:

BINPACKER    protein_Rf1    25.947  1.94e-31     N/A    N/A   quinoa
BINPACKER    mitochondrial  50.947  1.94e-31     N/A    N/A   quinoa

I want to divide this file based on the value in column 3 (e.g value >=50 in one file and others i.e. < 50 in other file) retaining all the columns.

Thankyou

[Ram]

What have you tried? This is pretty straightforward to do in awk.

[1234anjalianjali1234]

cat myfile.txt | awk '$3 > 50' > file_greater_than50.txt

But It is not working and also I don't how to apply =< criteria.

[Ram]

Please specify a delimiter for awk using awk -F or awk 'BEGIN { IFS=...'. >= is applied using the >= operator.

Answer 1

[JC]

perl -lane 'print if ($F[2] >=50)' < input > output

[1234anjalianjali1234]

Thankyou, It worked.