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
columnThe string column to clean. Values without the prefix remain unchanged.
Prefix
stringThe 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
AsColumn
nameName 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.