Name

filterCSV — This routine will read a CSV file and create a copy that contains only the selected records.

Syntax

String filterCSV ( String inputName , String reselect , String outputName ) 

The command has the following arguments:

inputName

The name of the input CSV file.

reselect

The query string to apply to the input records.

outputName

The name of the file to save the records in to. If the file already exists then its contents will be overwritten.

Description

This routine will read a CSV file and create a copy that contains only the selected records. This is useful for interactively filtering selected treatments out of a schedule.csv file as a model is being loaded.

Return value

The name of the output file that the data has been saved in to (the same value as the outputName parameter).