StripChars / String Layer
Remove specified characters from both ends of strings. Similar to Python's str.strip() or Rust's trim_matches(). If no characters specified, removes whitespace. Useful for:
- Cleaning data from unwanted characters
- Removing formatting symbols
- Standardizing text fields
- Processing copied or exported data
Table
0
0
Table
Select
columnThe string column to clean. Each value will have matching characters removed from both start and end.
Characters
stringSet of characters (Characters) to remove from both ends. Examples:
- .,!? for punctuation removal (Hello!!! -> Hello)
- []() for bracket cleanup ([Data] -> Data)
- 0 for leading/trailing zeros (0042 -> 42)
If empty, removes all whitespace (spaces, tabs, newlines)
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.