UNIX Text File Manipulation

I have several UNIX text files that need to be manipulated. I would like a parameter file to edit what I want in the file and the program would read the parameter file and write a log file. Example of text file to be edited: !echo "Creating ad_queue..." CREATE TABLE ad_queue ( Ad_no numeric(9) NOT NULL PRIMARY KEY, Publication char(4) NOT NULL, Zone char(4) NOT NULL, Queued_date huge date NOT NULL, Queued_time time NOT NULL, Queueing_operator char(14) NOT NULL, Try_count smallint NOT NULL, Try_date huge date NOT NULL, Try_time time NOT NULL, Server_select char(1) NOT NULL, In_process char(1) NOT NULL, Error_Message_Text text ); !echo Creating ad_queue indices ... !echo "`date`: ad_queue_hash" CREATE UNIQUE HASH INDEX ad_queue_hash on ad_queue (Ad_no); COMMIT WORK; I need the file to be in Oracle syntax: CREATE TABLE ad_queue ( Ad_no NUMBER(9) NOT NULL PRIMARY KEY, Publication VARCHAR2(4) NOT NULL, Zone VARCHAR2(4) NOT NULL, Queued_date VARCHAR2(12) NOT NULL, Queued_time VARCHAR(6) NOT NULL, Queueing_operator VARCHAR2(14) NOT NULL, Try_count NUMBER(9) NOT NULL, Try_date VARCHAR2(12) NOT NULL, Try_time VARCHAR2(6) NOT NULL, Server_select VARCHAR2(1) NOT NULL, In_process VARCHAR2(1) NOT NULL, Error_Message_Text CLOB ); CREATE INDEX ad_queue_hash on ad_queue (Ad_no); A parameter file for what to search and replace with would work best, maybe something like this: ####################### Look_for_line..............................char Replace_with..............................VARCHAR2 I have several conditions. The input file should remain intact and a new file with changes should be written.