A script to Find and replace a text in the file

Hello,

Here is my file ; it is an sql file.

select @i_date_v := min(from_unixtime(logging_time, '%D-%M-%Y')) FROM 1_event_2008070600;
select @mm1_succ_1 := count(*) FROM 1_event_2008070600 where indicator=100;
select @mm1_fai_1 := count(*) FROM 1_event_2008070600 where indicator in (101,208);
SET @const := 207360;

select @mm1_succ_2:= count(*) FROM 2_event_2008070600 where indicator=100;
select @mm1_fai_2 := count(*) FROM 2_event_2008070600 where indicator in (101,208);


I need following;

You will see '1_event_2008070600' and '2_event_2008070600' . These are formatted like 1_event_YYYYMMDD00 and 2_event_YYYYMMDD00 (here 00 are zeros)

I need to change only those words as yesterday (system date -1);

for example;

if today is 07.08.2008 (8th July 2008) then code should be as below;
select @i_date_v := min(from_unixtime(logging_time, '%D-%M-%Y')) FROM 1_event_2008070700;
select @mm1_succ_1 := count(*) FROM 1_event_2008070700 where indicator=100;
select @mm1_fai_1 := count(*) FROM 1_event_2008070700 where indicator in (101,208);
SET @const := 207360;

select @mm1_succ_2:= count(*) FROM 2_event_2008070700 where indicator=100;
select @mm1_fai_2 := count(*) FROM 2_event_2008070700 where indicator in (101,208);


if today (system date) is 07.09.2008 (9th July 2008) then code should be as below;
select @i_date_v := min(from_unixtime(logging_time, '%D-%M-%Y')) FROM 1_event_2008070800;
select @mm1_succ_1 := count(*) FROM 1_event_2008070800 where indicator=100;
select @mm1_fai_1 := count(*) FROM 1_event_2008070800 where indicator in (101,208);
SET @const := 207360;

select @mm1_succ_2:= count(*) FROM 2_event_2008070800 where indicator=100;
select @mm1_fai_2 := count(*) FROM 2_event_2008070800 where indicator in (101,208);

after that I will save the script in crontab
Start Free Trial