Shell Programming and Scripting

***removing confidential info***

So try:

Code:

awk '
/Application State/ {
	c[$0]++
	if(length($0) > m)
		m = length($0)
}
END {	for(i in c)
		printf("%-*s   : total = %02d\n", m, i, c[i])
}' 1.txt

which with your given sample produces:

Code:

  Application State :      Normal       : total = 03
  Application State :      Pending      : total = 01
  Application State :      Terminated   : total = 01

Thanks works gr8 !

With the latest example you posted, this is what I get:

Code:

awk '/Application State/ {app[$NF]++} END{for(a in app) printf "Application State : %-10s : total = %02d\n", a, app[a]}' aixusrsys.file

Code:

Application State : Normal     : total = 03
Application State : Terminated : total = 01
Application State : Pending    : total = 01

I'm very glad that we finally got something to work for you...

Note that the data you posted in message #8 (and deleted 37 minutes later) did not look anything like the data you included in posts #1 and #3. Leading spaces make a difference. Having Application State : instead of Application States : makes a difference. Having six spaces between the colon and the state instead of one space makes a difference.

You don't have to show us confidential data to get our help, but you do need to show us representative data. The commands you said you used in post #3 would have produced absolutely no output (just like Aia's awk script and my awk script) when given your real data instead of the data you showed us in post #1.