Batch update

text file find and replace .txt file replace data as follows. (update in place). 1. All findings of ,'B', to ,'A', 2. All Julian Dates that end with a close bracket to the Following start of week (sunday or as selected) Julian Date. If the Julian Date is a Sunday do not change. If I -------------------------- 1. Find a "comma,quote,capital letter B,comma" to be replace with "comma,quote,capital letter A,comma". 2. Find a "comma followed by a Julian Date followed by an closed bracket followed by comma" replace with a "comma followed by the following (day to be selected default Sunday) Julian Date. find ,2004365), change to ,2005002), I will backup the file before processing therefore the file can be updated in place or a new file can be generated. Whatever is easier. Sample execute command below. silconv [login to view URL] sunday Thanks Wilfredo Feliberty Wilfredo Inc. 718 706-7802 Sample input Data Below. INSERT INTO HEADER_DCT VALUES ( 'HM','0948','HOST','33571','HOSTAUDIT',,2004365,1330,2004365,,,'CHANGE','ONSALES 1/9/05',,,,,,'1/01.01',,'F01',); CREATE VIEW ITEM_CHG AS SELECT F01,F27,F30,F31,F33,F35 FROM ITEM_DCT; INSERT INTO ITEM_CHG VALUES (0004119601012,'1',1.99,1,'B',2004361), (0004119601022,'1',1.99,1,'A',2004363), (0004119601041,'1',1.99,1,'B',2004365), Sample output Data Below INSERT INTO HEADER_DCT VALUES ( 'HM','0948','HOST','33571','HOSTAUDIT',,2004365,1330,2004365,,,'CHANGE','ONSALES 1/9/05',,,,,,'1/01.01',,'F01',); CREATE VIEW ITEM_CHG AS SELECT F01,F27,F30,F31,F33,F35 FROM ITEM_DCT; INSERT INTO ITEM_CHG VALUES (0004119601012,'1',1.99,1,'A',2005002), (0004119601022,'1',1.99,1,'A',2005002), (0004119601041,'1',1.99,1,'A',2005002), ## Deliverables Rent A Coder requirements notice: As originally posted, this bid request does not have complete details. Should a dispute arise and this project go into arbitration "as is", the contract's vagueness might cause it to be interpreted against you, even though you were acting in good-faith. So for your protection, if you are interested in this project, please work-out and document the requirements onsite. 1) Complete and fully-functional working program(s) in executable form as well as complete source code of all work done. 2) Deliverables must be in ready-to-run condition, as follows (depending on the nature of the deliverables): a) For web sites or other server-side deliverables intended to only ever exist in one place in the Buyer's environment--Deliverables must be installed by the Seller in ready-to-run condition in the Buyer's environment. b) For all others including desktop software or software the buyer intends to distribute: A software installation package that will install the software in ready-to-run condition on the platform(s) specified in this bid request. 3) All deliverables will be considered "work made for hire" under U.S. Copyright law. Buyer will receive exclusive and complete copyrights to all work purchased. (No GPL, GNU, 3rd party components, etc. unless all copyright ramifications are explained AND AGREED TO by the buyer on the site per the coder's Seller Legal Agreement). ## Platform Program should run in batch mode dos and windows XP.