regex - grep 特定字符串并计算致命和错误的数量

Question

我有一个名为 violations.txt 的文件，如下所示:

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

我需要这样的输出:

violations.txt:
Fatal:
    Bgn : 1
    Gnp : 1
Total number of fatals : 2  
Errors:
    Nbgn : 1
    Esp  : 1
Total number of errors : 2

如果文件 violations.txt 在第 3 列包含单词 Status (!) 作为 fatal error 并且包含单词 ，我将尝试执行Status(*) 作为警告和它的计数。

我尝试了下面的代码，但没有得到准确的输出:

#!/bin/bash
pwd
echo " " ;
File="violations.txt"
for g in $File;
do
awk -F' +\\| +' 
if "$3"== "Status (!) /"  "$File" ; then
'BEGIN{ getline; getline }
truncate -s -1 "$File"
echo "$g:";
         { a[$2]++ }
     END{ for(i in a){ print i, a[i]; s=s+a[i] };
        print "Total numer of fatals:", s}' violations.txt
else 
echo "$g:";
'BEGIN{ getline; getline }
truncate -s -1 "$File"
echo "$g:";
         { a[$2]++ }
     END{ for(i in a){ print i, a[i]; s=s+a[i] };
        print "Total numer of errors:", s}' violations.txt
fi
done 

Answer 1

我们不是已经在稍微不同的轮回中介绍过了吗？

$猫tst.awk

BEGIN {
  FS="[[:blank:]][|][[:blank:]]"
  OFS=" : "
}
FNR>1{
   gsub(/[[:blank:]]/, "", $2)
   gsub(/[[:blank:]]/, "", $3)
   a[$3][$2]++
}
END {
  #PROCINFO["sorted_in"]="@ind_str_desc"
  print "Out" OFS
  for(i in a) {
    print ($i~/*/?"Fatal":"Error") OFS
    t=0
    for(j in a[i]) {
      print "\t" j, a[i][j]
      t+=a[i][j]
    }
    print "Total", t
    t=0
  }
}

运行 awk -f tst.awk myFile 结果:

Out :
Fatal :
        Gnp : 1
        Bgn : 1
Total : 2
Fatal :
        Esp : 1
        Nbgn : 1
Total : 2