ReplaceAll / String Layer

Replace all occurrences of a pattern in text. Similar to Python's re.sub() without count limit or str.replace() with count=-1. Replaces every match, not just the first one. Useful for:

Complete text cleanup
Removing all instances of sensitive data
Standardizing all occurrences of terms
Global text transformations

Table

Select

column

The string column to perform replacements on. Every match in each string will be replaced.

Pattern

string

Pattern to find and replace. Can be regex or literal based on Literal setting. Examples:

[0-9] to replace all digits
(https?://)[^ ]+ to replace all URLs
[A-Za-z0-9._%+-]+@[A-Za-z0-9.-]+ to replace all email-like patterns

ReplaceWith

string

Text to insert in place of matches (ReplaceWith). Examples:

'*' for censoring data
[REMOVED] for content filtering
normalized versions of terms

Literal

bool

false

If true, treats Pattern as exact text rather than regex. Useful for:

Replacing specific words or phrases
When pattern contains regex metacharacters
Direct text substitution everywhere

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.