Oracle FAQ | Your Portal to the Oracle Knowledge Grid |
![]() |
![]() |
Home -> Community -> Mailing Lists -> Oracle-L -> Re: How to add ' (comma) at the begining and end of each line? Either Unix or Windows
$ cat data.txt
abf
jd
djkhk
jd3
$ awk "{print \"'\" \$0 \"',\";}" data.txt
'abf',
'jd',
'djkhk',
'jd3',
$
OD> Hi List
OD> I have 1000 lines in my data file. I want to add OD> '(comma) at the begining and end of each line.
OD> For example,
OD> abf OD> jd OD> djkhk OD> jd3
OD> Shold be convrted to
OD> 'abf', OD> 'jd', OD> 'djkhk', OD> 'jd3',
OD> Any help will be really appreciated.
OD> Thanks
OD> Sami
OD> __________________________________ OD> Do you Yahoo!? OD> The New Yahoo! Shopping - with improved product search OD> http://shopping.yahoo.com
-rje
-- Please see the official ORACLE-L FAQ: http://www.orafaq.net -- Author: Robert Eskridge INET: bryny_at_dfweahs.net Fat City Network Services -- 858-538-5051 http://www.fatcity.com San Diego, California -- Mailing list and web hosting services --------------------------------------------------------------------- To REMOVE yourself from this mailing list, send an E-Mail message to: ListGuru_at_fatcity.com (note EXACT spelling of 'ListGuru') and in the message BODY, include a line containing: UNSUB ORACLE-L (or the name of mailing list you want to be removed from). You may also send the HELP command for other information (like subscribing).Received on Thu Oct 16 2003 - 09:44:34 CDT
![]() |
![]() |