Skip to content

TSTool / Command / DeleteTableRows


The DeleteTableRows command deletes specified rows from a table using one of the following approaches:

  • Condition
    • delete rows where a column value matches a condition
  • Row Number
    • delete specific row numbers
    • delete all rows

Because the deletion is a destructive action, one of the above conditions is required to be specified.

Command Editor

The following dialog is used to edit the command and illustrates the syntax of the command.


DeleteTableRows Command Editor for Condition Parameter (see also the full-size image)


DeleteTableRows Command Editor for Row Number Parameter (see also the full-size image)

Command Syntax

The command syntax is as follows:


Command Parameters

Parameter                           Description Default          
The table identifier for the table to process. Can specify with ${Property}. None - must be specified.
Condition A condition to match rows to be deleted. Can use ${Property} to specify row number. See additional information in the Tables appendix. Condition or row number must be specified.
DeleteRowNumbers The row number(s) to delete:
  • Comma-separated list of row numbers (1+)
  • last to delete the last row
  • * to delete all rows.

Can use ${Property}.
Condition or row number must be specified.


See the automated tests.

A simple comma-separated-value data as follows can be read with ReadTableFromDelimitedFile:

# Simple table for testing

The command file to read the above file and remove the first and last rows is as follows:



See Also