instr() in awk

If you have a long command line string, as you may find with java processes with a lot of properties, what is below will allow you to print those “columns” with a certain value as delimited by a space in awk. This is much easier to read than just grepping for the value in a long command long string.

oracle@dbindexap04pxdu:/> ps -ef | awk '{i=1;while (i <= NF) {if ($i ~ "fan") print $i;i++}}'
"fan")
-Djdbcauth.fan="prdracdb01pxdu-vip:6401,prdracdb02pxdu-vip:6402,prdracdb03pxdu-vip:6403"
-Djdbcauthdump.fan="prdracdb01pxdu-vip:6401,prdracdb02pxdu-vip:6402,prdracdb03pxdu-vip:6403"
-Djdbcauth.fan=prdracdb01pxdu-vip:6401,prdracdb02pxdu-vip:6402,prdracdb03pxdu-vip:6403
-Djdbcauthdump.fan=prdracdb01pxdu-vip:6401,prdracdb02pxdu-vip:6402,prdracdb03pxdu-vip:6403
-Djdbcauthupdate.fan=prdracdb01pxdu-vip:6401,prdracdb02pxdu-vip:6402,prdracdb03pxdu-vip:6403
-Djdbcauth.fan="prdracdb01pxdu-vip:6401,prdracdb02pxdu-vip:6402,prdracdb03pxdu-vip:6403"
-Djdbcauthdump.fan="prdracdb01pxdu-vip:6401,prdracdb02pxdu-vip:6402,prdracdb03pxdu-vip:6403"
-Djdbcauth.fan=prdracdb01pxdu-vip:6401,prdracdb02pxdu-vip:6402,prdracdb03pxdu-vip:6403
-Djdbcauthdump.fan=prdracdb01pxdu-vip:6401,prdracdb02pxdu-vip:6402,prdracdb03pxdu-vip:6403
-Djdbcauthupdate.fan=prdracdb01pxdu-vip:6401,prdracdb02pxdu-vip:6402,prdracdb03pxdu-vip:6403
-Djdbcauth.fan="prdracdb01pxdu-vip:6401,prdracdb02pxdu-vip:6402,prdracdb03pxdu-vip:6403"
-Djdbcauthdump.fan="prdracdb01pxdu-vip:6401,prdracdb02pxdu-vip:6402,prdracdb03pxdu-vip:6403"
-Djdbcauth.fan=prdracdb01pxdu-vip:6401,prdracdb02pxdu-vip:6402,prdracdb03pxdu-vip:6403
-Djdbcauthdump.fan=prdracdb01pxdu-vip:6401,prdracdb02pxdu-vip:6402,prdracdb03pxdu-vip:6403
-Djdbcauthupdate.fan=prdracdb01pxdu-vip:6401,prdracdb02pxdu-vip:6402,prdracdb03pxdu-vip:6403
-Djdbcauth.fan="prdracdb01pxdu-vip:6401,prdracdb02pxdu-vip:6402,prdracdb03pxdu-vip:6403"
-Djdbcauthdump.fan="prdracdb01pxdu-vip:6401,prdracdb02pxdu-vip:6402,prdracdb03pxdu-vip:6403"
-Djdbcauth.fan=prdracdb01pxdu-vip:6401,prdracdb02pxdu-vip:6402,prdracdb03pxdu-vip:6403
-Djdbcauthdump.fan=prdracdb01pxdu-vip:6401,prdracdb02pxdu-vip:6402,prdracdb03pxdu-vip:6403
-Djdbcauthupdate.fan=prdracdb01pxdu-vip:6401,prdracdb02pxdu-vip:6402,prdracdb03pxdu-vip:6403
oracle@dbindexap04pxdu:/>

Leave a Reply

Your email address will not be published. Required fields are marked *

This site uses Akismet to reduce spam. Learn how your comment data is processed.