Delete lines containing a range pattern in 4rd columns

Question

In a file 4th column contains a floating point numbers

dsfsd sdfsd sdfds 4.5 dfsdfsd

I want to delete the entire line if the number between -0.1 and 0.1 (or some other range).

Can sed or awk do that for me?

thanks

Answer 1

awk:

{ if ($4 > 0.1 || $4 < -0.1) print $0 }

Answer 2

I recommend using the "pattern { expression }" syntax:

awk '($4 < -0.1) || ($4 > 0.1) {print}' test.txt

Or, even more concicely:

awk '($4 < -0.1) || ($4 > 0.1)' test.txt

Since {print} is the default action. I've assumed that you have a file "test.txt" containing your data.