StripSuffix / String Layer
Remove a specific suffix from strings if present. Similar to Python's removesuffix() or Rust's strip_suffix(). Removes only one occurrence at the end. Useful for:
- Removing file extensions (.txt, .pdf)
- Cleaning unit suffixes (kg, cm)
- Standardizing company names (Inc., Ltd.)
- Processing versioned identifiers
Table
0
0
Table
Select
columnThe string column to clean. Values without the suffix remain unchanged.
Suffix
stringThe exact text (Suffix
) to remove from the end. Examples:
- .pdf (report.pdf -> report)
- _test (name_test -> name)
- Ltd. (Company Ltd. -> Company)
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.