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
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-
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
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
'''||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
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
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
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.