We have VERY old SNA server infrastructure with an A/S400 (just nod your head in agreement).
Every night a file gets copied to our local network share from the central HQ.
The file is a .spl printer spool file.
We now have another department that needs a copy of this data for other purposes.
We have started copying the spool file out of the nightly process.
The issue is that the file that is downloaded from the A/S400 always contains ALL historical data dating back 15+ years and the file now over 11MB and growing daily
We only need the most current data out of this file.
What the department has gotten in the habit of doing is
- open the saved file
- delete all data prior to today's date
- save the file
- import the edited file in to their application
What I want to do is to script opening the file an delete all data prior to today's date.
Is there a way any knows to do this from a Windows script?