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.
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 City
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 each
Hmmm - we call that symbol a 'quote' (and I have used quotes to quote quote,
if you follow... G)
Various ways - if your data is in a text file - use an edit macro
If it is a field in an Oracle table which you are extracting to a file - try
this:
select * (other fields) ,
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 end of each
line? Ei
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
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-L
Let's not forget about ed
ed your_file EOF
,s!^!'!g
,s!\$!',!g
w
q
EOF
if memory serves correctly.
Ron Thomas
Hypercom, Inc
[EMAIL PROTECTED]
Each new user of a new system uncovers a new class of bugs. -- Kernighan