CODEWITHSUNDEEP
linuxawk
Yacob
Yacob

Reputation: 525

Find common values in multiple in awk

I would like to find common values from multiple files and corresponding counts of appearance using awk. I have, say four files such as: input1, input2, input3, input4:

input1:   input2:   input3:  input4
AA         AB        AA      AC 
AB         AC        AC      AF
AC         AF        AF      AD
AD         AG        AH      AH 
AF         AH        AK      AK 
                             AI

I would like the answer to be:

Variable:    Count
AA             2
AB             2
AC             4
AD             2
AF             4
AH             3
AK             2
AI             1

Any comments, please !!

Upvotes: 1

Views: 147

Answers (1)

Kent
Kent

Reputation: 195029

awk '{a[$0]++}END{for(x in a)print x,a[x]}' input*

with your inputs, output would be:

AA 2
AB 2
AC 4
AD 2
AF 4
AG 1
AH 3
AI 1
AK 2

Upvotes: 3

Related Questions