AWK - Counting 3 columns, 1000;s records

littleIdiot · Jan 25, 2006

feherke · Jan 25, 2006

Hi

This ? ( Without padding column 3 to align the new column. )

Code:

awk '{a[$0]++}END{for(i in a)print i " | " a[i]} /path/to/inputfile

Feherke.

http://rootshell.be/~feherke/

littleIdiot · Jan 25, 2006

I'm just trying that suggestion ...

I should also say that the pipes are not actually in the file - I added them to my post to try to make it look clearer on screen. The fields are only separted by spaces.

Alignment does not matter, so long as there is separation - the output will hopefully end up in some other Windows based presentation - Excel no doubt.

littleIdiot · Jan 25, 2006

Excellent - that worked a treat:

awk ' { a[$0]++ } END { for (i in a ) print i " " a } ' input.txt > output.txt

That would have taken me many hours to figure out, and would never have worked so well - perfect.

Thank you so much! feherke

feherke · Jan 25, 2006

Hi

This is a basic AWK exercise. You should google for some oneliner collections. That codes are short, easy and usually contains usefull tricks.

http://google.com/search?q=awk+oneliners

Feherke.

http://rootshell.be/~feherke/

Tek-Tips is the largest IT community on the Internet today!

Members share and learn making Tek-Tips Forums the best source of peer-reviewed technical information on the Internet!

AWK - Counting 3 columns, 1000;s records

littleIdiot

MIS

feherke

Programmer

littleIdiot

MIS

littleIdiot

MIS

feherke

Programmer

Similar threads

Part and Inventory Search

Sponsor