DOS Batch - File Examples

The FTP command support the "-s:ftpscript.txt" option. The FTP commands listed in ftpscript.txt will automatically run after FTP starts. The FTP command can be started from a batch file.

• FTP -v -i -s:ftpscript.txt

This example shows how to enhance a program with persistent settings that can be changed using a menu.

I.e.:

• Choose 1 to change the 'Install version' from 'Client' to 'Server'.
• Choose 1 again to change the 'Install version' back to 'Client'.
• Choose 2 to change the 'Size of installation' from Full to 'Regular'.
• Choose 2 again to change the 'Size of installation' to 'Mini'.
• Choose 2 again to change the 'Size of installation' back to 'Full'.
• Choose I to begin the installation. Note: this example is just a simulation and will not install anything on your PC.

• simple and well structured
• settings changeable at runtime
• settings are persistent, the batch will remember all settings from the last run
• progress indication during simulated file installation

• Initialization of the command processor
• Version History for manual script change tracking
• Window title of choice
• Delayed exit for unattended completion

This batch creates a lookup list of all files on the C: drive.
When running the batch the first time type a hyphen in order to build the lookup list first.

• The lookup list will be appended to the batch file itself.
• Options: build/rebuild lookup list, or locate a file
• Regular expressions are supported, see FINDSTR for details.

This batch allows string substitution in a text file. It parses each line of a text file for a particular string and replaces it with another string.
I.e. To replace all occurrences of "Yellow Submarine" in "color.txt" with "uboot" and put the output on the screen run:
BatchSubstitute.bat "Yellow Submarine" uboot color.txt
Or
type color.txt|BatchSubstitute.bat "Yellow Submarine" uboot

Optionally pipe the output into a new file, i.e.
BatchSubstitute.bat "Yellow Submarine" uboot color.txt>newfile.txt
Or
type color.txt|BatchSubstitute.bat "Yellow Submarine" uboot>newfile.txt

• Lines starting with "]" character will end up empty
• OldStr must not start with "*"
• Lines must not contain any of the following characters within a quoted string: "&<>|^", as discussed in this post.

Did you ever pull the paper out of your printer to stop it from printing? Then surly next thing you did was power cycling the printer to empty the printer buffer and then cancelling the print job from the printer spooler on your PC. The print job sometimes remains a long time in the printer queue before finally disappearing and allowing the next print job to be processed. This is annoying on my box it takes up to 5 minutes. Even rebooting the PC doesn`t help as it doesn`t empty the printer spooler.

This little batch gets it done. It temporarily stops the spooler service and removes all files from the printer queue. Beware though that all printer jobs will be deleted, not only the ones that got canceled.

This simple menu framework parses itself for batch labels of certain signature and lists them as menu items. The self-parsing feature makes the menu generic. New menu items can be inserted by adding new function blocks without changing the menu infrastructure.

• simple and well structured
• easy to enhance
• easy to maintain

This batch sort`s text by handling the first number found in each line as real number not as text.

• In a text search 10 is less than 9, because the first letter 1 is less than 9
• In a number search 10 is greater than 9

• Rename the function
• Add proper description for the function and its arguments
• Fill in the function body
• Return desired values

A DOS batch that creates a well formatted HTML file listing the help output for all DOS commands.

• Shows progress indication while creating the command reference
• Outputs an command index with page links
• Outputs the command help text for each DOS command documented by "C:>help /?"

Date and Time functions are useful for:

• Calculations with date and time values
• Determine the age of files in days
• Determine the date difference in days

The example in this section demonstrates how to use the :ftime function to determine the age in days of all files in the temp directory.

Two variables are used

• tnow - stores the current day in julian days format by calling :jdate
• tfile - stores the file date in julian days format by calling :ftime

Using Delayed Expansion and exclamation marks around environment variables ensures that the `tfile`variable is substituted properly during each loop. Read more about this behavior in the SET command help (bottom half of the help text).

If you frequently find yourself calling FTP from the command line, each time having to login and change directory and change FTP modes, until you finally get where you want be in order to do some real work then you may wish to get there with a singe click.

This little batch can connect to your FTP server and logs you in before it gives you the prompt. You can easily add more FTP commands to it, like changing directories or switching to binary mode or whatever you like to be done before taking over control on the FTP prompt.

The FTP connection information is embedded within the batch itself. The batch connects to an FTP server by executing itself in FTP context using the FTP -s option. Once executing in FTP context it executes all FTP commands listed in the file. By omitting the final FTP "bye" command it will stop at the FTP prompt and wait for user input.

Optionally a FTP script can be provided as input stream, that way multiple FTP scripts can share the same login information. Example:

FtpLogin.bat <script1.ftp

Note: Since all files are passed into the FTP`s MGET command there might be a limit to the number of files that can be processed at once.

This batch executed the FTP script embedded within the batch. All variables in the FTP script will be resolved.

The FOR loop extracts the FTP script into a temporary file. It the ECHO command is being CALLed for each line in order to resolve the variables.

Variables can be used within the FTP script the same way as in a batch script, including any string manipulation and command line arguments like %1 %2 %~n0 %* and so on.

All batch lines start with semicolon so that they will be ignored by the FOR loop. Semicolon is the default end-of-line (EOL) character used by the FOR command.

Embed FTP script into a batch script. Add this line at the beginning of the FTP script:

The "FTP -s:ftpscript.txt" option executes a FTP script wheres "%~f0" resolved to the name of the running batch file. "GOTO:EOF" ends the batch script and makes sure the FTP script doesn`t run as part of the batch.
Good: You end up with only one file that contains the batch script and the FTP script combined.
Minor flaw: The batch command in the first line causes an "Invalid command." error when executed in FTP context, however the FTP execution will continue.

• Single file to distribute combining batch and FTP script

Note: Since all files are passed into the FTP`s MPUT command there might be a limit to the number of files that can be processed at once.

If you have multiple FTP scripts that all use the same login information to your FTP site then you may wish to manage the login information separately from your FTP scripts in a single place. That way if the username, password or hostname for the FTP connection changes you only need to edit a single place instead of having to edit all FTP scripts one by one.

This automatic login script (also described in detail earlier) can be used to execute different FTP scripts that share the same login information stored within the batch file.

Example: FtpLogin.bat script1.ftp

Note: The FTP scripts passed into the batch must have the login sequence removed.

Note: The FTP script executes even if the connection sequence fails potentially causing `Not connected` and other errors. This is no different from regularly executing FTP with -s option.

Embedding SQL script within a batch script is just as easy. The following batch script executes itself in SQL context. The trick is the GOTO command in the first line of the script. When executing GOTO START in batch context than the command processor will jump to the label ":START" and execute the batch script. The batch script will then run the OSQL.EXE using the batch file itself as SQL file argument to be executed. When subsequently executing the GOTO START line in SQL context, the query language processor will jump to the label "START:" and execute the SQL queries. In fact the file can be opened and executed in Query Analyzer as is, since the batch script in the file looks like a comment to the query language processor.

Now we can embed SQL queries into a batch file. But how can we pass arguments from the batch script into SQL? This can be done using a temporary table. Temporary tables live as long as the connection to the SQL Server. But how can we fill a temporary table with runtime data and execute the embedded SQL script without creating two separate SQL Server connections by calling OSQL.EXE twice? The trick is that OSQL allows to use the -i and -q option at the same time whereas:

• -q specifies a query string to be executed
• -i specifies a filename with SQL syntax to be executed

It`s nice not to have to type "perl -s Batch4Parl.pl" into the command line and rather being able to just double click a Perl script in Explorer. The trick of renaming the Perl .pl to a batch .bat file and wrapping a batch script around the Perl script is well known under Perl monks. However the solution I have seen so far needed batch code before and after the Perl script where as the solution presented below only needs some lines of DOS at the top. The added DOS script is generic and works independent from the name of the file.

When running the batch the DOS command interpreter will read the first lines and execute the file itself in Perl context.

This example works just as the previews one but will wait 4 seconds before the application finally closes. This is just enough time to inspect the screen output before the window vanishes. The delay can probably be done much easier in Perl, but somebody just starting on Perl might find this still useful.