The following node is available in the Open Source KNIME predictive analytics and data mining platform version 2.7.1. Discover over 1000 other nodes, as well as enterprise functionality at http://knime.com.

String Replacer

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

Dialog Options

Target column
Name of the column whose cells should be processed
Wildcard pattern
A wildcard expression (i.e. containing * and ? as meta characters) that is tested against all cells in the selected target column. The meta character * matches a variable range of characters whereas ? matches exactly one character.
Replacement text
The text that replaces that previous value in the cell if the pattern matched the previous value.
Replace whole string
The entire string (i.e. the entire cell content) is replaced when it matches the search pattern (including the meta characters * and ?).
Replace all substrings
All occurrences of the entered string 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
Append new column
Creates a new column with the name entered in the text field instead of replacing the values in the original column.

Ports

Input Ports
0 Arbitrary input data.
Output Ports
0 Input table with replaced values or an additional column.
This node is contained in KNIME Base Nodes provided by KNIME GmbH, Konstanz, Germany.