Skip navigation

Naming Temporary or Output Files

Developing a naming strategy for temporary files or output files lets you ensure that an instance of a script doesn't unintentionally overwrite another file. One naming approach is for the script operator to specify the filename in the script header. I usually try to avoid this option and instead include code in the script that automatically generates the filenames if for no other reason than to avoid the possibility of typos.

I typically use one of three methods to create unique filenames. The first method is file-path substitution. If your script takes input that includes file paths, you can use the file-path information to create a path-based filename after you strip out the slash (\) and colon (:) characters by using string substitution. Remember, you can't use these characters in a filename. This method is ideal for dealing with output files because it lets you easily identify what path location the report (i.e., output file) relates to. You can use a similar technique to deal with spaces and any other characters that you want to strip or replace in a path. The following sample code changes a path into a filename:

Set Path=\\servera\share37\wilma 
Set Path=%Path::\=-% 
Set Path=%Path:\=-% 
Set Pathfn=%Path%.txt 
Echo %Pathfn% 

The second method is to convert the date and time to a filename. This method is best if you want to name reports for the time of day that the script runs. To create a date-based filename, use this syntax:

For /F "tokens=2,3,4,5,6,7,8
  delims=/ " %%i in ("%DATE%")
  Do Set Dfn=D%%i-%%j-%%k.txt 
Echo %Dfn% 

To generate a combination date-and time-based filename, use this syntax:

For /F "tokens=2,3,4,5,6,7,8 
  delims=/: " %%i in ("%DATE% %TIME%")
  Do Set DTfn= 
  D%%i-%%j-%%k-T%%l-%%m-%%n.txt 
Echo %DTfn% 

The third method works well for temporary files in cases where intuitive filenames aren't important, because only the script will be creating, using, and deleting the files. I used this method in the ReplicationTest script. Generally, the only time you'd need to access such temporary files is for script-debugging purposes, so friendly filenames aren't really necessary.

The code below uses the RANDOM environment variable to create a random filename for the temporary files that ReplicationTest uses:

Set Ranfn=%RANDOM%.txt 
Echo %Ranfn% 
Hide comments

Comments

  • Allowed HTML tags: <em> <strong> <blockquote> <br> <p>

Plain text

  • No HTML tags allowed.
  • Web page addresses and e-mail addresses turn into links automatically.
  • Lines and paragraphs break automatically.
Publish