Search Results

sed -n 's/^DBconnection.*SERVICE_NAME=\([^)]*\).*/\1/p' filename

Regards,
Alister

First off, "grep" isn't the right tool: "grep" will always return whole lines, but not parts of it. You need "sed" (or "awk" or some other text filter) to do what you want.

First, lets describe...

sed '/^DBconn/!d;s/.*SERVICE_NAME=//;s/).*//' infile


awk '/^DBconn/{match($0,"SERVICE_NAME=[^)]*[)]"); print substr($0,(RSTART+13),(RLENGTH-14))}'

use nawk if on Solaris