String Replacer

This node replaces strings in a selected target column. In the configuration dialog, a pattern and a replacement text are specified. If the pattern doesn't match, the result string equals the input string. You can choose to modify strings in-place or add the result strings to a new column.

Options

Target column

Select the column in which the strings should be replaced.

Pattern type

Select the type of pattern which you want to use.

• Literal matches the pattern as is.
• Wildcard matches * to zero or more arbitrary characters and matches ? to any single character.
• Regular expression matches using the full functionality of Java regular expressions, including backreferences in the replacement text. See the Java API for details.

Use backslash as escape character

Only relevant for wildcard matching. If checked, the backslash character can be used to escape special characters. For instance, \? will match the literal character ? instead of an arbitrary character. In order to match a backslash you need to escape the backslash, too (\\).

Case sensitive

If checked, the matching will distinguish between upper and lower case letters.

Pattern

A literal string, wildcard pattern or 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 it. If you are using a regular expression, you may also use backreferences (e.g. $1 to refer to the first capture group, named capture groups can also be used with (?<group>) and ${group} to refer to them).

Replacement strategy

Select what to replace in case a string matches a pattern.

• Whole string replaces the entire string with the replacement string, requiring an exact match of the whole string.
• All occurrences replaces all occurrences of the pattern with the replacement string. Note that when e.g. matching on the RegEx-pattern '.*', an empty string at the end of the input is also matched and replaced. To avoid that, use e.g. the pattern '^.*' to indicate that the match has to start at the beginning.

Append new column

If enabled, the strings will not be replaced in-place but a new column is appended that contains the original string with the replacement applied.

New column name

The name of the created column with replaced strings, only relevant if Append new column is enabled.

Views

This node has no views

Workflows

• 00_bindingsiteexplorationKNIME Hub
• 01_caption_preprocessingKNIME Hub
• 01_Fault_Tolerant_Workflow_OrchestrationKNIME Hub
• 01_Fault_Tolerant_Workflow_OrchestrationKNIME Hub
• 01_Topic Detection Analysis_TrainingKNIME Hub
• Show all 643 workflows

Links

• Remove multiple words from a stringby AnotherFraudUser on 2021-03-18

  forum.knime.com/p/118879
• Remove all characters until last number at beginning of stringby AnotherFraudUser on 2020-06-08

  forum.knime.com/p/93658
• String Manipulationby AnotherFraudUser on 2020-05-14

  forum.knime.com/p/91188
• String replace (Dictionary) problemby danielesser on 2020-06-06

  forum.knime.com/p/93591
• Column Row edit / change character - delete “../”by AnotherFraudUser on 2020-06-15

  forum.knime.com/p/94362
• Show all 8 links

Developers