String Replacer

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.

Views

This node has no views

Workflows

• 0_MS-DIAL_MS-Finder_v6_JSSX 1v1KNIME 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 307 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