IconString Replacer0 ×

StreamableKNIME Base Nodes version 3.6.0.v201807061308 by KNIME AG, Zurich, Switzerland

Replaces values in string cells if they match a certain wildcard pattern.

Options

Target column
Name of the column whose cells should be processed
Pattern type
Select the type of pattern which you want to use. If you select wildcard, then * and ? are (the only) meta-characters. They match an arbitrary number of characters or a single character, respectively.
If you select regular expression you can use the full functionality of Java regular expressions, including backreferences in the replacement text. See the Java API for details.
Pattern
Either a wildcard pattern or a regular expression, depending on the pattern type selected above.
Replacement text
The text that replaces that previous value in the cell if the pattern matched the previous value. If you are using a regular expression, you may also use backreferences (e.g. $1).
Replace whole string
The entire string (i.e. the entire cell content) is replaced when it completely matches the search pattern (including the meta characters * and ?).
Replace all substrings
All occurrences of the entered pattern are replaced in the target column. The meta characters * and ? are not allowed in the pattern in this case.
Case sensitive search
Check this if the pattern should be case sensitive
Use backslash as escape character
If you want to replace the wildcard characters * and ? themselves, you need to enable this option and escape them using a backslash (\* or \?). In order to replace a backslash you need to escape the backslash, too (\\).
Append new column
Creates a new column with the name entered in the text field instead of replacing the values in the original column.

Input Ports

Arbitrary input data.

Output Ports

Input table with replaced values or an additional column.

Best Friends (Incoming)

Best Friends (Outgoing)

Workflows

Update Site

To use this node in KNIME, install KNIME Base Nodes from the following update site:

Wait a sec! You want to explore and install nodes even faster? We highly recommend our NodePit for KNIME extension for your KNIME Analytics Platform.