sed3028a.zip

[rosetalk]

Hi,

I have downloaded you sed utility from http://www.cornerstonemag.com/sed/. What 
I want to do is to remove this string: 

and "TIMESTAMP" = TO_DATE('07-JUN-2002 17:45:42', 'DD-MON-YYYY HH24:MI:SS') 

As you can see the only thing that is dynamic is the date 07-JUN-2002 and the 
time 17:45:42. Thus, I need to use regular expressions.  

I tried to use this syntax sed 's/and "TIMESTAMP" = TO_DATE*DD-MON-YYYY 
HH24:MI:SS\')//' redo_sqls.sql > redo_out1.sql. I thought the * will ignore 
whenever is between TO_DATE and YYYY HH24:MI:SS') and replace the string with 
nothing. But this comand did not change the string as I think sed could not 
find the match. I need your expertise to see whether it is a bug or there is 
something wrong with my regular expression.

The command should change this statement

update "EPERFECT_PV"."SCHEDULE" set "SCHEDULEID" = '212', "DAY" = '1', "MONTH" 
= '6', "YEAR" = '2002', "SCHEDULEDATE" = TO_DATE('01-JUN-2002 00:00:00', 
'DD-MON-YYYY HH24:MI:SS'), "PERIODID" = '1', "STATUSID" = '0', 
"SCHEDULEACTIVITYID" = '0', "UNITID" = '0', "CREATEDBY" = 'eperfect_pv', 
"DATECREATED" = TO_DATE('04-JUN-2002 10:06:37', 'DD-MON-YYYY HH24:MI:SS'), 
"LASTUPDATEDBY" = 'eperfect_pv', "DATEUPDATED" = TO_DATE('10-JUN-2002 
14:57:02', 'DD-MON-YYYY HH24:MI:SS'), "TIMESTAMP" = TO_DATE('10-JUN-2002 
14:57:02', 'DD-MON-YYYY HH24:MI:SS') where "SCHEDULEID" = '212' and "DAY" = '1' 
and "MONTH" = '6' and "YEAR" = '2002' and "SCHEDULEDATE" = TO_DATE('01-JUN-2002 
00:00:00', 'DD-MON-YYYY HH24:MI:SS') and "PERIODID" = '1' and "STATUSID" = '0' 
and "SCHEDULEACTIVITYID" = '0' and "UNITID" = '0' and "CREATEDBY" = 
'eperfect_pv' and "DATECREATED" = TO_DATE('04-JUN-2002 10:06:37', 'DD-MON-YYYY 
HH24:MI:SS') and "LASTUPDATEDBY" = 'eperfect_pv' and "DATEUPDATED" = 
TO_DATE('07-JUN-2002 17:45:4!
2', 'DD-MON-YYYY HH24:MI:SS') and "TIMESTAMP" = TO_DATE('07-JUN-2002 17:45:42', 
'DD-MON-YYYY HH24:MI:SS');   

to this statement

update "EPERFECT_PV"."SCHEDULE" set "SCHEDULEID" = '212', "DAY" = '1', "MONTH" 
= '6', "YEAR" = '2002', "SCHEDULEDATE" = TO_DATE('01-JUN-2002 00:00:00', 
'DD-MON-YYYY HH24:MI:SS'), "PERIODID" = '1', "STATUSID" = '0', 
"SCHEDULEACTIVITYID" = '0', "UNITID" = '0', "CREATEDBY" = 'eperfect_pv', 
"DATECREATED" = TO_DATE('04-JUN-2002 10:06:37', 'DD-MON-YYYY HH24:MI:SS'), 
"LASTUPDATEDBY" = 'eperfect_pv', "DATEUPDATED" = TO_DATE('10-JUN-2002 
14:57:02', 'DD-MON-YYYY HH24:MI:SS'), "TIMESTAMP" = TO_DATE('10-JUN-2002 
14:57:02', 'DD-MON-YYYY HH24:MI:SS') where "SCHEDULEID" = '212' and "DAY" = '1' 
and "MONTH" = '6' and "YEAR" = '2002' and "SCHEDULEDATE" = TO_DATE('01-JUN-2002 
00:00:00', 'DD-MON-YYYY HH24:MI:SS') and "PERIODID" = '1' and "STATUSID" = '0' 
and "SCHEDULEACTIVITYID" = '0' and "UNITID" = '0' and "CREATEDBY" = 
'eperfect_pv' and "DATECREATED" = TO_DATE('04-JUN-2002 10:06:37', 'DD-MON-YYYY 
HH24:MI:SS') and "LASTUPDATEDBY" = 'eperfect_pv' and "DATEUPDATED" = 
TO_DATE('07-JUN-2002 17:45:4!
2', 'DD-MON-YYYY HH24:MI:SS');   

Thank you for you advice and attention.

Regards
Han Kiong