|Hello, newbie here, I've gone through several threads and haven't found my exact scenario, could be I'm not versed well enough or it might not be possible to do in batch.|
What I am wanting to do is to schedule a nightly file copy from one server to another. Simple enough to do in Windows Scheduler with a date parm but on the destination the file has to be renamed as such.
Source File name:
(it will always start with "A" and then have YYMMDD then a 6 digit number sequence and a .OCC suffix
Destination File name:
First a B is added after the A at the front of the file, then the YYMMDD then the suffix ## would be the last two digits in the ## sequence in the Source File. The .OCC is dropped as well as the first 4 digits of the sequence
in this example the file would be named: AB101005.32
Two more examples:
A101005140931.OCC -> AB101005.31
A100930105370.OCC -> AB100930.70
It would have about 2-3 files to copy each night at midnight.
any thoughts or tips? THANKS!!