File manupulation !

Hi Gurus !

1. I wrote a shell script to create a sql script which will create a table with partitions ...
2. I have done it using awk script to create the script ... the script has 507 lines ... but it can increase in future ... so I would like to dynamically modify the script ...

Here is my problem ... at the end of the script :

tablespace sv_test storage(initial 1m next 1m pctincrease 0 maxextents 200),

In the above line I would like to replace the , with )

How can I do this in a shell script ?

Any help is highly appreciated !

Thanks
Vaithy

I don't fully understand what you're doing but sub()
takes a regular expression for the first argument, and a replacement string like this

Hi Jim,

Thanks for your reply ... Here is what I meant ... I have a file which looks like :

PARTITION sv_03000_p values ('03000')
tablespace sv storage(initial 1m next 1m pctincrease 0 maxextents 200),
PARTITION sv_03001_p values ('03001')
tablespace sv storage(initial 1m next 1m pctincrease 0 maxextents 200),
PARTITION sv_04005_p values ('04005')
tablespace sv storage(initial 1m next 1m pctincrease 0 maxextents 200),
PARTITION sv_04072_p values ('04072')
tablespace sv storage(initial 1m next 1m pctincrease 0 maxextents 200),
PARTITION sv_04221_p values ('04221'))
tablespace sv storage(initial 1m next 1m pctincrease 0 maxextents 200),

In the above text ... in each line there is a , at the end ... I want to replace the , with ) only at the last line of the script.
How can I do that in a shell script ?!

Thanks
Vaithy

sed -e '$s/,[ ]*$/)/' yourFile

That worked !!!

Thanks and appreciate your help.

Vaithy