fork download
  1. BEGIN{FS="\\|"}
  2. FNR==1{ next }
  3. /Status \(\!\)/{
  4. match($0,/\| +[a-zA-Z]+ +\| Status/)
  5. val=substr($0,RSTART,RLENGTH)
  6. gsub(/\| +| +\| Status/,"",val)
  7. countEr[val]++
  8. val=""
  9. }
  10. /Status \(\*\)/{
  11. match($0,/\| +[a-zA-Z]+ +\| Status/)
  12. val=substr($0,RSTART,RLENGTH)
  13. gsub(/\| +| +\| Status/,"",val)
  14. countSu[val]++
  15. val=""
  16. }
  17. END{
  18. print "Fatal:"
  19. for(i in countEr){
  20. print "\t"i,countEr[i]
  21. sumEr+=countEr[i]
  22. }
  23. print "Total number of fatal:" sumEr
  24. for(i in countSu){
  25. print "\t"i,countSu[i]
  26. sumSu+=countSu[i]
  27. }
  28. print "Total number of errors:"sumSu
  29. }
Success #stdin #stdout 0s 4448KB
stdin
column1                  column2      column3         column4                    Situation
Data is preesnt         |  Bgn      | Status (!)    | There are no current runs | Critical level
Data is not existing    |  Nbgn     | Status (*)    | There are runs            | Medium level
Data limit is exceeded  |  Gnp      | Status (!)    | The runs are not present  | Higher level
Dats existing|present   |  Esp      | Status (*)    | The runs are present      | Normal|Higher level
stdout
Fatal:
	Gnp 1
	Bgn 1
Total number of fatal:2
	Esp 1
	Nbgn 1
Total number of errors:2