ReplaceMany / String Layer

Replace multiple text patterns using a mapping table. Similar to multiple str.replace() operations or a translation table. Each pattern is replaced with its corresponding value. Useful for:

Standardizing variations (color, colour -> color)
Multi-language text replacement
Code or category normalization
Bulk text corrections

Table

Select

column

The string column to perform replacements on. Each value may have multiple patterns replaced.

Mappings

[, ...]

List of pattern-replacement pairs. Must contain at least one mapping. Examples:

[grey->gray, colour->color] for standardization
[Jan->01, Feb->02] for month conversion
[Dr.->Doctor, Prof.->Professor] for expansion

Pattern

string

Text to find (Pattern). Treated as literal string, not regex. Examples:

Misspelled words
Alternative spellings
Legacy codes

ReplaceWith

string

Text to use as replacement (ReplaceWith). Examples:

Correct spellings
Standardized terms
New code values

AsciiInsensitive

bool

false

When true, matches ASCII letters regardless of case (e.g., Color matches COLOR, color). Affects only ASCII characters a-z and A-Z, not Unicode letters.

Name for the new column. If not provided, the system generates a unique name. If AsColumn matches an existing column, the existing column is replaced. The name should follow valid column naming conventions.