Arrays and Temporary Files

Don't overuse temporary files. If you can write your code without resorting to using temporary files, do so.

Be sure that you won't have multiple script instances trying to simultaneously utilize the same temporary file path.

Plan to clean up temporary files both before and after running a script. The "before" cleanup is important in case the last run was interrupted before the cleanup phase. Appending data to an already partially created temporary file can give you some strange duplicate or corrupted results. If you have multiple temporary files that you want to clean up, you can name your temporary files with similar names and use a global If Exist and delete statement to delete the files all in one operation.The following statement performs such a global deletion:

If Exist %temp%~DFS*.txt Del %temp%~DFS*.txt

Remember that if you use *.*, you'll need to use the Del command with the /Q switch.

The code at callouts B and F in Listing 1 in the main article shows the before and after deletion sections that use the multi-file delete code.

Determine whether you want to write your temporary files to the same location as your script, the %Temp% folder, or an alternative temporary location.

Remember that if you're logged in as a user and run a script that writes to the %Temp% folder, you'll actually be writing to the %USERPROFILE%Local SettingsTemp location. If you aren't logged in and the script runs as a scheduled task, the %Temp% location will be %SystemRoot%TEMP.

Be careful when you're trying to delete a file that might be locked by another operation. Note that the blat temporary file %temp%blatout.txt in the DFSReportBuilder.bat script (which you can download at InstantDoc ID 92798) isn't deleted when the script ends because it can be locked by the blat.exe tool's use of the file. You can choose to not bother with deleting the temporary file immediately, which is what I did, or you can use the Sleep command to delay the attempted deletion of the temporary file by a few seconds. The code at callout A in Listing 1 in the main article shows the single deletion section for the blat source text file.

While you're testing your scripts, you might be tempted to open and view text files while they are being written. Doing so typically won't cause a problem unless the application you use locks the file and prevents a deletion or modification. Also, if you open any text file in Microsoft Excel, you'll notice that the open file is generally locked and won't accept writes or allow deletions until Excel is closed.