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

column

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

Suffix

string

The exact text (Suffix) to remove from the end. Examples:

  • .pdf (report.pdf -> report)
  • _test (name_test -> name)
  • Ltd. (Company Ltd. -> Company)

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.