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
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.