Extract First and matching word from string in UNIX

Shell Programming and Scripting
1

Thank you

2 
 awk '{a=$1;} gsub(/\(/, " (") gsub(/\)/, " )") {for(i=2;i<=NF;i++) {if(substr($i,1,5)=="$dwh.") a=a" "substr($i,6)}} {print a}' file.sql
3

Fixed some on krishmaths code (removed extra bracket and gsub)

awk '{a=$1;gsub(/[()]/," ");for(i=2;i<=NF;i++) {if(substr($i,1,5)=="$dwh.") a=a" "substr($i,6)};print a}' file.sql

awk '{
	a=$1
	gsub(/[()]/," ")
	for(i=2;i<=NF;i++) {
		if(substr($i,1,5)=="$dwh.") a=a" "substr($i,6)}
	print a
	}' file.sql

EDIT: modified some

awk '{a=$1;gsub(/[().]/," ");for(i=2;i<=NF;i++) if($i=="$dwh") a=a" "$(i+1);print a}' file.sql