StripPrefix / String Layer

Remove a specific prefix from strings if present. Similar to Python's removeprefix() or Rust's strip_prefix(). Removes only one occurrence at the start. Useful for:

  • Removing standard prefixes (Mr., Dr., etc.)
  • Cleaning URL protocols (http://)
  • Standardizing product codes
  • Processing prefixed identifiers
Table
0
0
Table

Select

column

The string column to clean. Values without the prefix remain unchanged.

Prefix

string

The exact text (Prefix) to remove from the start. Examples:

  • https:// (https://example.com -> example.com)
  • PRD- (PRD-001 -> 001)
  • Re: (Re: Hello -> Hello)

Case-sensitive matching

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.