EDIT: found the answer thanks to James Brown, there was a problem in the way I formatted the command:
awk -F"," '{ if ($2*$3 > 0.5) print }'
is working.
I’ve got a file like this:
1000,0.5,1
2000,0.5,3
4000,1,3
5000,0.2,1
I need to multiply $2 and $3 for each line and check if the result is superior to 0.5.
I read that the -gt operator cannot handle floating-point numbers and that awk could do it.
Here’s the best I could come up with:
cat awk.txt | awk -F"," '{ if ("$2"*"$3" > "0,5") print "$line"}'
Of course, it doesn’t work, but it doesn’t return any error…
Expected result:
5000,0.2,1
Can you point me in the right direction?
Thank you very much
>Solution :
After fixing the errors in your code:
$ awk -F"," '{if($2*$3 > 0.5) print}' file
output is:
2000,0.5,3
4000,1,3
You could also just:
$ awk -F, '$2*$3>0.5' file