Very Computer

1. sed -e 's/\'a\'/\';\'/' ?

Hi,

my question is, how can I mask the single
quotation mark in my file for sed

I have a lot of SQL-Loader files of this kind:

cat t55.ctl
load data
infile 't55'
truncate
into table A_220_T55
fields terminated by ';' TRAILING NULLCOLS
(AAA_000_KEY    char ,
B_220_BBB_LFD_NR char ,
AAA_220_BBB     char )

there is given a delimiter ';'

The delimiter should be changed to a.

#!/bin/ksh
#set -x
for file in t*.ctl
do
sed -e 's/;/a/' $file >$file.new
mv $file.new $file
done

That's ok.

Now the delimiter should be rechanged from a to ;.
I'd tried

sed -e 's/\'a\'/\';\'/' $file >$file.new

It doesn't work.

How to mask the single quotation mark inside the sed command?

TIA,

Nele

2. Wanted: APPLIX

3. What is 'stty', 'term' & 'tty'

4. Linux Frequently Asked Questions with Answers (Part 3 of 6)

5. Simple 'sed', 'awk', 'cut' problem

6. Your GOD Loves You - YES YOU!

7. LinuxPPC99: 'INIT: ld ''x'' respawning too fast...'??

8. netscape 4.05 on Ultra5 - Solaris 2.6 --- display problems

9. Can 'require' override 'allow'/'deny' (Apache)

10. Limiting 'w', 'top' and 'ps'

11. 'IRQ timeout' message and 'DMA disabled' with 'ls -l'

12. Help: problems with 'w', 'who' and 'last'

13. How to hide from 'who', 'finger', 'ps' commands?