Awk extraction with test

Leo The Cat — Mon, 24 Jan 2011 15:08:02 GMT

Hi Guys

How to return only DBX here flag is not N from my file below (Example).

DB1:/su01/app/oracle/product/10203/db:W
DB2:/su01/app/oracle/product/10203/db:Y
DB3:/su01/app/oracle/product/10204.2/db:Y
DB4:/su01/app/oracle/product/10203/db:N
DB5:/su01/app/oracle/product/10203/db:N
DBTEST1:/su01/app/oracle/product/10203/db:Y

Result must be

DB1
DB2
DB3
DBTEST1

Thanks in advance

Bests regards
Den

Re: Awk extraction with test

Earl_Crowder — Mon, 24 Jan 2011 15:42:21 GMT

awk -F':' '!/^#/ && NF==3 && $3!="N"{print $1}'

Re: Awk extraction with test

Leo The Cat — Mon, 24 Jan 2011 19:35:53 GMT

Earl answer is good !

topic Awk extraction with test in Operating System - HP-UX

Awk extraction with test

Re: Awk extraction with test

Re: Awk extraction with test