Re: How to add ' (comma) at the begining and end of each line? Either Unix or Windows
Use the 'search and replace' functionality of ultraedit with 'regular expressions' enabled. First select 'replace all' for replacing % with ' Then select 'replace all' for replacing $ with ' - Original Message - To: "Multiple recipients of list ORACLE-L" <[EMAIL PROTECTED]> Sent: Thursday, October 16, 2003 19:50 Unix or Windows > Hi List > > I have 1000 lines in my data file. I want to add > '(comma) at the begining and end of each line. > > For example, > > abf > jd > djkhk > jd3 > > Shold be convrted to > > 'abf', > 'jd', > 'djkhk', > 'jd3', > > Any help will be really appreciated. > > Thanks > Sami > > __ > Do you Yahoo!? > The New Yahoo! Shopping - with improved product search > http://shopping.yahoo.com > -- > Please see the official ORACLE-L FAQ: http://www.orafaq.net > -- > Author: Oracle DBA > INET: [EMAIL PROTECTED] > > 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: [EMAIL PROTECTED] (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). > -- Please see the official ORACLE-L FAQ: http://www.orafaq.net -- Author: <[EMAIL PROTECTED] INET: [EMAIL PROTECTED] 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: [EMAIL PROTECTED] (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).
RE: How to add ' (comma) at the begining and end of each line? Either Unix or Windows
A windows solution for /f %d in (C:\yourfile.txt) do echo ,%d,>>C:\yourfilewithcomma.txt bob Hi List I have 1000 lines in my data file. I want to add '(comma) at the begining and end of each line. For example, abf jd djkhk jd3 Shold be convrted to 'abf', 'jd', 'djkhk', 'jd3', Any help will be really appreciated. Thanks Sami __ Do you Yahoo!? The New Yahoo! Shopping - with improved product search http://shopping.yahoo.com -- Please see the official ORACLE-L FAQ: http://www.orafaq.net -- Author: Oracle DBA INET: [EMAIL PROTECTED] 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: [EMAIL PROTECTED] (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). -- Please see the official ORACLE-L FAQ: http://www.orafaq.net -- Author: Bob Metelsky INET: [EMAIL PROTECTED] 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: [EMAIL PROTECTED] (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).
RE: How to add ' (comma) at the begining and end of each line? Either Unix or Windows
perl -i.orig -p -e "s/^/'/ ; s/$/',/" filename The original version of the file will be retained as "filename.orig". -Original Message- Sent: Thursday, October 16, 2003 9:20 AM To: Multiple recipients of list ORACLE-L Either Unix or Windows Hi List I have 1000 lines in my data file. I want to add '(comma) at the begining and end of each line. For example, abf jd djkhk jd3 Shold be convrted to 'abf', 'jd', 'djkhk', 'jd3', Any help will be really appreciated. Thanks Sami __ Do you Yahoo!? The New Yahoo! Shopping - with improved product search http://shopping.yahoo.com -- Please see the official ORACLE-L FAQ: http://www.orafaq.net -- Author: Oracle DBA INET: [EMAIL PROTECTED] 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: [EMAIL PROTECTED] (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). -- Please see the official ORACLE-L FAQ: http://www.orafaq.net -- Author: Norris, Gregory T [ITS] INET: [EMAIL PROTECTED] 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: [EMAIL PROTECTED] (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).
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
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: [EMAIL PROTECTED]
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: [EMAIL PROTECTED] (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).
How to add ' (comma) at the begining and end of each line? Either Unix or Windows
Hi List I have 1000 lines in my data file. I want to add '(comma) at the begining and end of each line. For example, abf jd djkhk jd3 Shold be convrted to 'abf', 'jd', 'djkhk', 'jd3', Any help will be really appreciated. Thanks Sami __ Do you Yahoo!? The New Yahoo! Shopping - with improved product search http://shopping.yahoo.com -- Please see the official ORACLE-L FAQ: http://www.orafaq.net -- Author: Oracle DBA INET: [EMAIL PROTECTED] 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: [EMAIL PROTECTED] (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).
