I currently have a spreadsheet with a list of "Nonactive" accounts (10 digits) in col A. Accounts are manually added/deleted from this list manually from time to time.
I have files that come into 4 networked servers (P8A, P8B, P8C, and P8D) in c:\combatch\subfolder\835. Right now, I use the DOS ts (text search) command to look for a string in all files, and delete the file if the string matches the one in the list, col A.
Is it possible to create a batch/macro to:
a. search all files in the 835 folders
b. list server and subfolder name in col B, filename in col C, timestamp in col D
c. compare the text search "GS*??*" & ?????????? with col A
if match found, then delete
d. cycle through filenames found in col C again, and put "Deleted" in col E if not found (obviously, since it was just deleted in step c)
So, basically, it's a macro to search, list, compare, delete, and verify/confirm. If it's not possible, then I'll see if I can make some DOS batch programs to do it. Thanks!