Skip to content

TSTool / Command / DeleteTableColumns


Overview

The DeleteTableColumns deletes specified columns from a table. The list of column names to delete is is determined from the DeleteColumns parameter, except that any columns specified by the KeepColumns are not deleted.

Command Editor

The command is available in the following TSTool menu:

  • Commands(Table) / Manipulate Table Values

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

DeleteTableColumns command editor

DeleteTableColumns Command Editor (see full-size image)

Command Syntax

The command syntax is as follows:

DeleteTableColumns(Parameter="Value",...)

Command Parameters

Parameter                           Description Default          
TableID
required
The table identifier for the table to process. Can specify with ${Property}. None - must be specified.
KeepColumns
required
The names of columns to keep, separated by commas. Can use ${Property} to specify column names. Each column name can also contain * wildcard. None - must be specified.
DeleteColumns
required
The names of columns to delete, separated by commas. Can use ${Property} to specify column names. Each column name can also contain * wildcard. None - must be specified.

Examples

See the automated tests.

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

# Simple table for testing
"string1","double1","integer1"
"String1",1.0,1
"String2",2.0,2
"String3",3.0,3

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

ReadTableFromDelimitedFile(TableID="Table1",InputFile="testtable.csv")
DeleteTableColumns(TableID="Table1",DeleteColumns="double1,integer1")

Troubleshooting

See the main TSTool Troubleshooting documentation.

See Also