Printing rows based on column range

Shell Programming and Scripting
1

Hello, I have a file with nearly 57K lines. I want to filter the lines based on the range of values in a column. For e.g. print lines whose 3rd filed is >=0.02.
Input file:

LOC_Os09g32030   LOC_Os02g18880   0.0200037219149773 undirected NA NA
LOC_Os03g58630   LOC_Os09g35690   0.0500037406047893 undirected NA NA
LOC_Os09g38520   LOC_Os03g59610   0.0100037519153753 undirected NA NA
LOC_Os03g04110   LOC_Os01g01280   0.0100037598797819 undirected NA NA

Desired output:

LOC_Os09g32030   LOC_Os02g18880   0.0200037219149773 undirected NA NA
LOC_Os03g58630   LOC_Os09g35690   0.0500037406047893 undirected NA NA

Kindly help..

2

Using awk:

awk '$3 >= 0.02' file
1 Like