Shell Programming and Scripting

Hi,
I have a shell script to unload all the empname who have salary >50000 from the emp table into a text file(empname.txt) .
m_db unload "$dbc_file" -column_delimiter ',' -select "SELECT empname FROM emp where salary > 50000" >> empname.txt

Now my text file have data in the following format
cat empname.txt
kkk,
abc,
efg,
hij,
lmn,
...,
etc
I want to change all these values in the below mentioned format and each string should have single codes.

cat empname.txt
'kkk','abc','efg','hij','lmn','...','...',etc

How can I change this in the shell script?.If anybody knows please help me to resolve this.

You can try this.

Code:

cat empname.txt | sed "s/^/\'/" | sed "s/,/\',/" | tr -d "\n"

There's no need for cat; there's no need for multiple sed-s; there's no need to escape a single quote.

Code:

sed "s/[^,][^,]*/'&'/;\$s/,$//" empname.txt| tr -d '\n'

Thanks for all your suggestions .It works fine for me now