Oracle FAQ Your Portal to the Oracle Knowledge Grid
HOME | ASK QUESTION | ADD INFO | SEARCH | E-MAIL US
 

Home -> Community -> Mailing Lists -> Oracle-L -> Re: How to add ' (comma) at the begining and end of each line? Either Unix or Windows

Re: How to add ' (comma) at the begining and end of each line? Either Unix or Windows

From: Robert Eskridge <bryny_at_dfweahs.net>
Date: Thu, 16 Oct 2003 06:44:34 -0800
Message-ID: <F001.005D35FD.20031016064434@fatcity.com>


$ 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

OD> --
OD> Please see the official ORACLE-L FAQ: http://www.orafaq.net

-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

Original text of this message

HOME | ASK QUESTION | ADD INFO | SEARCH | E-MAIL US