Shell Programming and Scripting

WS=123hi4
wd=WAST,RDP

"where WS='123hi4' and wd in ('WAST','RDP')"

#  sed "s/=\(.*\)/=\'\1\'/;s/,/\',\'/" infile | tr "\n=" "  " | awk '{print "\"where "$1"="$2" and "$3" in ("$4")\""  }'
"where WS='123hi4' and wd in ('WAST','RDP')"

local $/;
my $str=<DATA>;
if($str=~/([^=]*)=([^=]*)\n([^=]*)=/){
	print "where $1='$2' and $3 in(";
}
my $post=$';
my @tmp= $post=~/([^,]+)/g;
map {$_="'".$_."'"} @tmp;
print join ",", @tmp;
print ")";
__DATA__
WS=123hi4
wd=WAST,RDP