Shell Programming and Scripting

I wish to convert the following in shell. Help me SED or AWK

ID= 12345,23456,67859 , 90225 , 67583

I can extract the right hand side of "=" using cut command "cut -d "=" -f2

after extracting that right side i would need like this

'12345','23456','67859','90225','67583'

1 ) the whitespace to be removed
2 ) single quotes to be introduced.

Kindly help

Gopal

Code:

echo "ID= 12345,23456,67859 , 90225 , 67583" | tr -d 'a-zA-Z= ' | sed "s/\([^,]*\)/'\1'/g"

Hi,

Try this one,

Code:

awk -F"=" '{split($2,a,",");for(i=1;i<=length(a);i++){a[i]=sprintf("%c%s%c",047,a[i],047);t=t","a[i];}
gsub(/^,| /,"",t);print t;}' file

Cheers,
Ranga