Counting strings from array in bash

Question

I am writing output of awk to array in bash like so:

ARR=$(( awk '{print $2}' file.txt ))

Imagine the content of file.txt is:

A B
A B
A C
A D
A C
A B

What I want is number of repetition of each string in second column like:

B: 3
C: 2
D: 1

Any other solution rather than arrays and awk is welcome.

anubhava · Accepted Answer · 2014-07-23 07:08:47Z

4

Using awk you can do:

awk '{c[$2]++} END{for (i in c) print i ":", c[i]}' file
B: 3
C: 2
D: 1

answered Jul 23, 2014 at 7:08

anubhava

790k67 gold badges603 silver badges671 bronze badges

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

1 Comment

anubhava Over a year ago

Alternative solution is: sort -k2 file | uniq -f1 -c |awk '{print $3 ":", $1}'

MLSC · Accepted Answer · 2014-07-23 07:14:20Z

1

Other solution I found:

awk '{print $2}' file.txt | sort | uniq -c | sort -nr | while read count name
do
        if [ ${count} -gt 1 ]
        then
                echo "${name} ${count}"
        fi
done

answered Jul 23, 2014 at 7:14

MLSC

5,9728 gold badges60 silver badges90 bronze badges

Collectives™ on Stack Overflow

Counting strings from array in bash

2 Answers 2

1 Comment

Comments

Your Answer

Hot Network Questions

Collectives™ on Stack Overflow

2 Answers 2

1 Comment

Comments

Your Answer

Sign up or log in

Post as a guest

Related