selecting specific lines based on second column values

Question

The following is my test.log file

a   1020    491 513 1   0   0   52
a   1000    491 513 1   0   0   53
sa  4011    491 513 1   0   0   0
sa  4010    491 513 1   0   0   1
d   1000    508 0   0   0   0   53
d   1020    508 0   0   0   0   52
a   1000    508 513 1   0   0   54
a   1020    508 513 1   0   0   55
sa  4011    508 1026    2   0   0   2
sa  4010    508 1026    2   0   0   3
sd  4010    508 513 1   0   0   1   QIO1
sa  4021    508 513 1   0   0   1
d   1000    525 0   0   0   0   54
d   1020    525 0   0   0   0   55
sd  4021    525 0   0   0   0   1   QIO2
a   1000    525 513 1   0   0   57
a   1020    525 513 1   0   0   56
sa  4010    525 1026    2   0   0   5
sa  4011    525 1539    3   0   0   4
sd  4011    525 1026    2   0   0   0   QIO1
sa  4021    525 513 1   0   0   0
d   1000    542 0   0   0   0   57
sd  4021    542 0   0   0   0   0   QIO2
d   1020    542 0   0   0   0   56

I want to extract only lines that have (first column = sa or sd) and second columns equal to 4010 and 4011. I tried the following command.

cat test.log | grep "sa\|sd" | awk '{if ($2 = "4010"|| $2 ="4011")print}'

But it gives me wrong output.

My expected output is

sa  4011    491 513 1   0   0   0
sa  4010    491 513 1   0   0   1
sa  4011    508 1026    2   0   0   2
sa  4010    508 1026    2   0   0   3
sd  4010    508 513 1   0   0   1   QIO1
sa  4010    525 1026    2   0   0   5
sa  4011    525 1539    3   0   0   4
sd  4011    525 1026    2   0   0   0   QIO1

Can someone suggest where I am going wrong. Thanks

fedorqui · Accepted Answer · 2016-05-23 13:13:44Z

3

Be idiomatic, my friend:

awk '$1 ~ /^s(a|d)$/ && $2 ~ /^401[01]$/' file
#         ^^^^^^^^^           ^^^^^^^^^
#         sa or sd            4010 or 4011

It returns:

sa  4011    491 513 1   0   0   0
sa  4010    491 513 1   0   0   1
sa  4011    508 1026    2   0   0   2
sa  4010    508 1026    2   0   0   3
sd  4010    508 513 1   0   0   1   QIO1
sa  4010    525 1026    2   0   0   5
sa  4011    525 1539    3   0   0   4
sd  4011    525 1026    2   0   0   0   QIO1

edited May 23, 2016 at 13:13

answered May 23, 2016 at 13:08

fedorqui

293k113 gold badges592 silver badges640 bronze badges

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

3 Comments

user2532296 Over a year ago

Thanks, for the explanation

fedorqui Over a year ago

@user2532296 I hope it is clear. Note things like awk '{if (condition) print}' can be squeezed to a mere awk 'condition'.

Ed Morton Over a year ago

Why (a|d) but [01]? IMHO [ad] would make more sense.

dawg · Accepted Answer · 2016-05-23 17:47:04Z

0

You can do this entirely in grep:

$ grep -E '^s[ad]\s+401[01]' file
sa  4011    491 513 1   0   0   0
sa  4010    491 513 1   0   0   1
sa  4011    508 1026    2   0   0   2
sa  4010    508 1026    2   0   0   3
sd  4010    508 513 1   0   0   1   QIO1
sa  4010    525 1026    2   0   0   5
sa  4011    525 1539    3   0   0   4
sd  4011    525 1026    2   0   0   0   QIO1

answered May 23, 2016 at 17:47

dawg

105k24 gold badges143 silver badges217 bronze badges

Collectives™ on Stack Overflow

selecting specific lines based on second column values

2 Answers 2

3 Comments

Comments

Your Answer

Hot Network Questions

Collectives™ on Stack Overflow

2 Answers 2

3 Comments

Comments

Your Answer

Sign up or log in

Post as a guest

Related