TD_​StrApply

fastpath function used to apply predefined string operation on a specified target column range.

Options

Accumulate

Specifies the input table columns to copy to the output table. By default, the function copies no input table columns to the output table.

EscapeString (strings seperated by new line)

Specifies the names of a string that will be used as an escape string while applying stringLike operation.

IgnoreTrailingBlank

Specify whether to ignore trailing blanks in the column strings. Used if the stringOperation is StringLike only.

InPlace

Specify whether to use the same column name for the resulted target columns.

IsCaseSpecific

Specify whether to consider uppercase letters(e.g. 'A') and lowercase letters(e.g. 'a') as same or different.

OperatingSide

Specify the operating side to consider while performing operations like stringPad, getNchars. Supported OperatingSide are {LEFT,RIGHT}.

OutputColumns (strings seperated by new line)

Specifies the names to give to the output columns which will contain output of the string opeation on the columns values.

StartIndex

Specifies the start index of the target column string. Used only if the string operation is SubString.

Output Schema

Output Schema, if Volatile is true then use user login as the schema.

Output Table

Output Table

VAL Location

VAL Location

String (strings seperated by new line)

Specifies the names of a string that will be used as an input parameter while applying string operation.

StringLength

Specifies the length of a string.

StringOperation

Specify the string method which will be used on the target columns. Supported StringOperation are {TOUPPER,TOLOWER,STRINGTRIM,STRINGCON,SIGMOID,STRINGPAD,STRINGLIKE,STRINGINDEX,INITCAP,TRIMSPACES,CHARTOHEXINT,STRINGREVERSE,UNICODESTRING,SUBSTRING,GETNCHARS}.

TargetColumns

Specifies the input table columns for which string operation needs to be performed.

Volatile

Specifies whether the table should be a VOLATILE table. If true, then the table is automatically deleted, otherwise it is users responsibility to remove or clean it up for space.

Nodes

• String Configuration8 ×
• Boolean Configuration4 ×
• Column Filter Configuration2 ×
• Python Script2 ×
• Single Selection Configuration2 ×
• Show all 14 nodes

Extensions

• FeatureKNIME Base nodes
• FeatureKNIME Database
• FeatureKNIME Quick Forms

Links

• No links available