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

column

The string column to slice. Each value will be sliced according to the specified position and length.

0

Starting 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

0

Number 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

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.