1 ×

String Replace (Dictionary)

StreamableKNIME Base Nodes version 4.3.1.v202101261649 by KNIME AG, Zurich, Switzerland

This node replaces the cells in a selected column by elements of a dictionary. The cell is compared against the keys in the dictionary file and - given that a matching key is found - the cell content is then replaced by the value of the respective dictionary entry.

The dictionary must be plain text file, whereas rows in the file correspond to entries in a dictionary. Each line should be of the format

    value, key1, key2, key3, ...

The value string corresponds to the replacement string (matching keys are replaced with this value).The keys are given by the strings after the value (key1, key2, ... in the example), i.e. there are multiple keys possible. If no key matches the input string, the cell content remains the same. Only exact matches are possible.

Note, the dictionary does not get saved to the archive when the flow is exported. The dictionary file needs to be saved/exported separately. In general it's advisable to use the Cell Replacer node as this has a dedicated dictionary port.

Options

Target Column: The column containing the to-be-replaced elements.
Dictionary Location: The plain text file containing the dictionary entries (see above).
Delimiter in Dictionary: The delimiter character used in the dictionary file. In the above example this is a single comma (',') but can be (almost) any character. Special characters available are '\t' for a tab and '\\' for a single backslash.
Append Column: If checked, the replaced values will be put into a separate new column, which is appended to the table (specify the name in the textfield). If unchecked, the target column is replaced.

Input Ports

: Arbitrary input data.

Output Ports

: Input data but with input target column replaced or with an additional column.

Best Friends (Incoming)

String Replace (Dictionary) (9 %) Streamable
String Replacer (7 %) Streamable
String Manipulation (6 %) Streamable
Column Filter (6 %) Streamable
~~Number To String~~ (5 %) Deprecated
Show all 246 recommendations

Best Friends (Outgoing)

String Replace (Dictionary) (11 %) Streamable
String Replacer (8 %) Streamable
String Manipulation (6 %) Streamable
Partitioning (5 %)
~~String To Number~~ (5 %) StreamableDeprecated
Show all 250 recommendations

Workflows

03_Visualizing_Git_Statistics_for_Guided_Analytics (KNIME Hub)
03_Visualizing_Git_Statistics_for_Guided_Analytics (KNIME Hub)
Node Workbench nodes (KNIME Hub)
Node Workbench nodes (KNIME Hub)
Workbench nodes (KNIME Hub)
Show all 7 workflows

Installation

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

KNIME 4.3

A zipped version of the software site can be downloaded here.

You don't know what to do with this link? Read our NodePit Product and Node Installation Guide that explains you in detail how to install nodes to your KNIME Analytics Platform.

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. Browse NodePit from within KNIME, install nodes with just one click and share your workflows with NodePit Space.

Developers

You want to see the source code for this node? Click the following button and we’ll use our super-powers to find it for you.