Select DAT

Summary

The Select DAT allows you to fetch a DAT from any other location in TouchDesigner, and to select any subset of rows and columns if it is a table.

Parameters

DAT /dat - The path of the DAT being referenced.

Include First Row /firstrow - Forces the first row to be selected even if it is not specified by the Extract Rows settings.

Include First Column /firstcol - Forces the first column to be selected even if it is not specified by the Extract Cols settings.

Extract Rows /extractrows - This parameter allows you to pick different ways of specifying the rows selected.

• All - All rows selected.
• by Name - Rows selected using Start Row Name and End Row Name parameters.
• by Index - Rows selected using Start Row Index and End Row Index parameters.
• by Start Name, End Index - Rows selected using Start Row Name and End Row Index parameters.
• by Start Index, End Name - Rows selected using Start Row Index and End Row Name parameters.
• by Specified Values - Rows selected by specifying the row values explicitly.

Start Row Name /rownamestart - Specify the row name to start the selection range from.

Start Row Index /rowindexstart - Specify the row index to start the selection range from.

End Row Name /rownameend - Specify the row name to end the selection range.

End Row Index/rowindexend - Specify the row index to end the selection range.

Selected Row Values /rownames - Specify actual row names that you want to select. You can use pattern matching, for example row[1-4] will select all the rows names row1 thru row4.

Row Select Condition /rowexpr - Specify an expression that will be evaluated. If the expression evaluates to true, the row will be selected. You can access the cell value with the local variable $V, and the row and column with $R and $C.

From Column /fromcol - When extracting rows by Specified Names, this parameter selects which column to use when matching cell values to Selected Row Values to determine which rows are selected.

Extract Cols /extractcols - This parameter allows you to pick different ways of specifying the columns selected.

• All - All columns selected.
• by Name - Columns selected using Start Col Name and End Col Name parameters.
• by Index - Columns selected using Start Col Index and End Col Index parameters.
• by Start Name, End Index - Columns selected using Start Col Name and End Col Index parameters.
• by Start Index, End Name - Columns selected using Start Col Index and End Col Name parameters.
• by Specified Values - Columns selected by specifying the column values explicitly.

Start Col Name /colnamestart - Specify the column name to start the selection range from.

Start Col Index /colindexstart - Specify the column index to start the selection range from.

End Col Name /colnameend - Specify the column name to end the selection range.

End Col Index /colindexend - Specify the column index to end the selection range.

Selected Col Values /colnames - Specify actual column names that you want to select. You can use pattern matching, for example colvalue[1-4] will select all the columns named colvalue1 thru colvalue4.

Col Select Condition /colexpr - Specify an expression that will be evaluated. If the expression evaluates to true, the column will be selected. You can access the cell value with the local variable $V, and the row and column with $R and $C.

From Row /fromrow - When extracting columns by Specified Names, this parameter selects which row to use when matching cell values to Selected Col Values to determine which columns are selected.

Output /output - Determines what format will be used for output from the DAT.

• Input Data /data - Passes through data from first input without manipulation.
• Strings /string - Evaluates input data as strings, including expanding any variable values to full strings.
• Expressions /expr - Evaluates input data as expressions.

Variables

Local variables available are:

• $NR - number of input rows.
• $NC - number of input columns.
• $V - value of the cell, can be accessed when selecting by expression.
• $R - current input row, can be accessed when selecting by expression.
• $C - current input column, can be accessed when selecting by expression.