List only not unique values of column and count instances of .csv file in UNIX

UNIX for Beginners Q & A
1

I need to take any one of the column of a .csv file and count the number of instances of each not unique value in that column. I'd like the output to be value,count sorted by most instances. Thanks for any guidance!

Data example:

0093320481|4050994|ABC|10-DEC-2001
0093320482|4050994|ADC|10-DEC-2010
9340983269|4819450|SED|06-MAY-1987
9340983269|4819451|MEO|02-FEB-1971
2

Hi, @SanMota
This can be solved by two commands 'uniq' and 'sort'.
Do you work on the command line?
Show what you did and what exactly you can't do

1 Like