RE: How to add ' (comma) at the begining and end of each line? Ei

2003-10-16 Thread Ron Thomas
Let's not forget about ed ed your_file < -Original Message- > > 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

RE: How to add ' (comma) at the begining and end of each line? Ei

2003-10-16 Thread Jared Still
Open the file in vi, run the following command: %s/^\(.*\)$/\'\1\',/ On Thu, 2003-10-16 at 07:54, Khedr, Waleed wrote: > small C, java, Perl, etc program can get it done quickly. > > -Original Message- > Sent: Thursday, October 16, 2003 10:20 AM > To: Multiple recipients of list ORACLE-

Re: How to add ' (comma) at the begining and end of each line? Ei

2003-10-16 Thread Mladen Gogala
I'll refrain from answering. My non-rtfm answer would neither be sed nor awk. If I responded , my response would be something like: #!/usr/bin/perl -w while (<>) { s/^/'/; s/$/'/; print; } On 10/16/2003 11:04:40 AM, Stephen Lee wrote: Since there has been an AWK reply, there should be a

RE: How to add ' (comma) at the begining and end of each line? Ei

2003-10-16 Thread Gints Plivna
Or text editor that can work with columns Or MSExcel > -Original Message- > From: Khedr, Waleed [mailto:[EMAIL PROTECTED] > Sent: Thursday, October 16, 2003 5:55 PM > To: Multiple recipients of list ORACLE-L > Subject: RE: How to add ' (comma) at the begining and

RE: How to add ' (comma) at the begining and end of each line? Ei

2003-10-16 Thread Robson, Peter
'''||data_field||'''', ***etc from table; peter > -Original Message- > From: Khedr, Waleed [mailto:[EMAIL PROTECTED] > Sent: Thursday, October 16, 2003 3:55 PM > To: Multiple recipients of list ORACLE-L > Subject: RE: How to add ' (comm

RE: How to add ' (comma) at the begining and end of each line? Ei

2003-10-16 Thread Stephen Lee
Since there has been an AWK reply, there should be a SED reply too. (Perl? What's Perl?) sed "s/^/'/; s/\$/'/" your_file sed 's/^/'\''/; s/$/'\''/' your_file > -Original Message- > > Hi List > > I have 1000 lines in my data file. I want to add > '(comma) at the begining and end of e

RE: How to add ' (comma) at the begining and end of each line? Ei

2003-10-16 Thread Stephen Lee
Oh, and I almost forgot a ksh example (Perl? What's Perl?) cat your_file | while read LINE; do echo "'$LINE'"; done Or while read LINE; do echo "'$LINE'"; done < your_file -- Please see the official ORACLE-L FAQ: http://www.orafaq.net -- Author: Stephen Lee INET: [EMAIL PROTECTED] Fat Cit

RE: How to add ' (comma) at the begining and end of each line? Ei

2003-10-16 Thread Khedr, Waleed
small C, java, Perl, etc program can get it done quickly. -Original Message- Sent: Thursday, October 16, 2003 10: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.