String Replacer (Dictionary)

This node replaces strings in selected columns. The dictionary table provides the patterns to search for and the values to replace matches with. If no pattern matches, the result string equals the input string. You can choose to modify strings in-place or add the result strings in new columns.

Input ports

1. Type: Table
   Data Table
   The data table contains the string columns to perform the replacement on.
2. Type: Table
   Dictionary Table
   The dictionary table has a pattern column and a replacement column that will be used to perform the replacements

Output ports

1. Type: Table
   Data Table with updated columns
   The dictionary table has a pattern column that defines what to search for and a replacement column that defines what to replace matches with.