[Top][All Lists]
[Date Prev][Date Next][Thread Prev][Thread Next][Date Index][Thread Index]
sed3028a.zip
From: |
rosetalk |
Subject: |
sed3028a.zip |
Date: |
Wed, 21 Aug 2002 17:25:11 +0800 (SGT) |
User-agent: |
SingNet WebMail |
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
- sed3028a.zip,
rosetalk <=