pull out rows with specific criteria

Shell Programming and Scripting
1

Hi,
I have a file with multiple columns and for column 5 I want to extract that row into another file if it is equal to or greater than a certain value.

For example:

FAR  4  5  7  LOP
GAT  3  3  3  POL

I want values that are greater than 5 for column 4. So the final file will look like this.

FAR  4  5  7  LOP

Thanks

Phil

2

This is exactly the sort of problem awk was made for.

awk '$4 > 5' inputfile > outputfile