AWK handling of single quote

braindrain · #1 (**permalink**) 04-27-2006

Hi,
Can someone let me know how I can acheive the following.

I have ~ delimited file and I need to convert into something like SQL insert statements.

SrcFile :
1~sjdsdj~asasas~
2~aaaaa~qwqwqwq~qwq
.....

I tried

Code:

AWK -F"~" '{print "INSERT INTO XX VALUES("$1 " ,\' "$2" \' , \' "$3 }' SrcFile

However AWK always treat '(single quote) as differently & i guess since single quote appear more than once. Any idea how i can make awk to treat single quote as text character or is this possible in SED?

'{print "INSERT INTO XX VALUES("$1 " ,\' "$2" \' , \' "$3 }'
|------------------------------------|xxxxxxx|--|xxxxxx|

jim mcnamara · #2 (**permalink**) 04-27-2006

sqlldr will handle this for you - it looks like you're using Oracle.

Code:

OPTIONS (DIRECT=false)
LOAD DATA
INFILE 'myfile'
APPEND
INTO TABLE MYTABLE
FIELDS TERMINATED BY '~'
TRAILING NULLCOLS
(FLD1, FLD2, FLD3)

a ctl file like this one will do what you show.

braindrain · #3 (**permalink**) 04-27-2006

Hi Jim,
Sure, this will work, Infact my stop gap approach is this. However we are looking to acheive this in shell scripting, as we gonna apply this to disparate databases.

thx

vgersh99 · #4 (**permalink**) 04-27-2006

Code:

nawk -F"~" -v q="'" '{print "INSERT INTO XX VALUES("$1 " ," q "$2" q "," q $3 }' SrcFile

you'll have to figure out the ballancing of the double-quotes inside the 'print' - I think I got it right, but......

More UNIX and Linux Forum Topics You Might Find Helpful
Thread	Thread Starter	Forum	Replies	Last Post
how to print single quote in awk	gauravgoel	UNIX for Dummies Questions & Answers	6	08-20-2008 04:48 PM
escaping single quote	javeed7	Shell Programming and Scripting	3	04-02-2008 05:36 AM
single quote	dreams5617	Shell Programming and Scripting	2	12-01-2007 03:37 AM
single or double quote in SED	asami	Shell Programming and Scripting	2	07-17-2006 03:03 AM
Replacing a single quote	rjsha1	Shell Programming and Scripting	3	12-23-2005 10:55 AM

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


	Powered by