Changing the text file format

kavithakuttyk · #1 (**permalink**) 06-11-2009

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.

BubbaJoe · #2 (**permalink**) 06-11-2009

You can try this.

Code:

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

vgersh99 · #3 (**permalink**) 06-11-2009

Quote:

Originally Posted by BubbaJoe

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'

kavithakuttyk · #4 (**permalink**) 06-11-2009

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

More UNIX and Linux Forum Topics You Might Find Helpful
Thread	Thread Starter	Forum	Replies	Last Post
Format a text file	jhardy	Shell Programming and Scripting	2	03-17-2009 02:32 PM
changing the format of CSV file	ashis.tewari	Shell Programming and Scripting	5	12-09-2008 07:38 AM
Changing display and format of file	wahi80	UNIX for Dummies Questions & Answers	1	08-02-2008 08:12 PM
Conver Excel file to another format ( text)	ZINGARO	HP-UX	6	07-23-2008 01:52 PM
Changing the column for a row in a text file and adding another row	aYankeeFan	Shell Programming and Scripting	9	05-02-2005 09:42 PM

Thread Tools	Search this Thread
Show Printable Version Email this Page	Search this Thread: Advanced Search
Display Modes	Rate This Thread
Switch to Linear Mode Hybrid Mode Switch to Threaded Mode	Rate This Thread:


	Powered by