#!/bin/bash awk -F ':|[ ]+' '/tcp.+\:3306/{ list[$6]++;if($8 ~ /ESTA.+/){a++} b++; } END{ print "TOTAL_IP " length(list); print "ESTABLISHED " a; print "TOTAL_LINK " b; } ' "./nowcoder.txt"