UNIX for Beginners Questions & Answers

Name  |   Status
------------------
DB 1   |  UP
DB 2  |  UP
DB 3  |  DOWN
DB 4  |  UP
DB 5  |  UP

[root@fbakirpomd4 ~]# cat table.txt
Name  |   Status
------------------
DB 1   |  UP
DB 2  |  UP
DB 3  |  DOWN
DB 4  |  UP
DB 5  |  UP

[root@fbakirpomd4 ~]# awk -F"|" '/DOWN/ { print $1" is "$2 }' < table.txt
DB 3   is   DOWN
[root@fbakirpomd4 ~]#

sed -n '/DOWN/s/|/is/p' table.txt

DB 3  is  DOWN

awk -F\| '/DOWN/{print $1}' table.txt

DB 3

awk '/DOWN *$/ && $(NF-1)="is"' table.txt

DOWNEY   |  UP
SHOWDOWN  |  UP

awk -F"|" ' {
        if ($2!="UP"){
           print "Node" $1 "is" $2 ;
        }
        else {
           print "All Nodes OK" ;
}
}' db_status.txt  | awk '/-------/{flag=1;next}/rows/{flag=0}flag'

awk -F"|" '
NR > 2 {
   if ($2 !~ /UP/) {
      print "Node: " $1 "is" $2 ;
      all_nodes_ok=1;
   }
}
END {
   if (! all_nodes_ok) print "All Nodes OK" ;
}' db_status.txt