replace-column-values

Replaces values in source column with some or all matches of a pattern replaced by a replacement, or puts the modified values in a new column instead.

Search for values using a pattern (text or regular expression). If pattern is a text value, only the first occurrence in each value (column-row, cell) will be replaced. Replacement values are added to target column.

Note: within each value, only the first instance is replaced.

How is this adaptor different from "replace-value"? It allows you to create a new target column to hold the modified data, rather than simply replacing the values in the source column. However, it also only replaces the first instance of the pattern value.

Arguments

Inputs:

data: A datatable to be searched.

source: The name of a column in data to be searched.

pattern: A text or a regular expression to be replaced. Regular expressions must be wrapped with "/" character (e.g. /.*/). Note that within each value, only the first instance of each pattern will be replaced.

replacement: Text that replaces the substring specified by the specified pattern parameter.

target: The name of the column to which replacement values are added. If unspecified, defaults to source column.

Output:

data: A datatable with replacement text in place of pattern text, with target column added (or source column modified).