Awk conditional with multiple conditions

Question

I am using awk to check if my data has values of 32th column is greater than 4000 and value of 60th column is less than 10. I am using below command, but it is not working, nor it is showing any error:

awk -F, '$32 > 4000' && '$60 < 10' *

I have , as separator and I am checking it in all the files in a folder.

Do you mean row or column? Because you appear to try to check columns. — Wintermute
– Wintermute, Commented Feb 24, 2015 at 9:37

fedorqui · Accepted Answer · 2015-02-24 09:36:56Z

3

awk evaluates conditions within ' ' and you have two blocks of them, && being outside. So you have to put all this syntax within ' ':

awk -F, '$32 > 4000 && $60 < 10' *

Instead of:

awk -F, '$32 > 4000' && '$60 < 10' *
                   ^    ^

answered Feb 24, 2015 at 9:36

fedorqui

293k113 gold badges592 silver badges640 bronze badges

Sign up to request clarification or add additional context in comments.

Comments

SMA · Accepted Answer · 2015-02-24 09:37:06Z

1

You could just combine multiple condition within one quote and use it like:

awk -F, '$32 > 4000 && $60 < 10' *

answered Feb 24, 2015 at 9:37

SMA

37.2k8 gold badges53 silver badges76 bronze badges

Collectives™ on Stack Overflow

Awk conditional with multiple conditions

2 Answers 2

Comments

Comments

Your Answer

Hot Network Questions

Collectives™ on Stack Overflow

2 Answers 2

Comments

Comments

Your Answer

Sign up or log in

Post as a guest

Related