Slice / String Layer
Extract a substring by position and length. Similar to Python's str[start:start+length] or Rust's string slicing. Works with UTF-8 characters, not bytes. Useful for:
- Extracting specific portions of formatted text
- Getting substrings from fixed-width fields
- Processing structured string data
- Working with positional data formats
Table
0
0
Table
Select
columnThe string column to slice. Each value will be sliced according to the specified position and length.
Offset
i64Starting position (Offset
) for the slice. Examples:
- 0: start from beginning
- 3: start at fourth character
- -5: start at fifth character from end
Handles UTF-8 character positions correctly
Length
u64Number of characters (Length
) to include in slice. Examples:
- 0: take all characters to end
- 5: take five characters
Returns fewer characters if string is too short
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.