SplitN / String Layer

Split strings into a limited number of parts using a delimiter. Similar to Python's str.split(maxsplit=n) but keeps all parts. Creates a list column with at most MaxSplit + 1 parts. Useful for:

Limiting the number of split parts
Processing hierarchical data with known depth
Extracting first N fields from structured text
Parsing nested categories

Table

Select

column

The string column to split. Each value will be split at most MaxSplit times, regardless of how many delimiters exist.

Delimiter

string

Character or string (Delimiter) that marks split points. Common examples:

Slash (/) for URL paths (domain/category/subcategory)
Dot (.) for hierarchical names (company.department.team)
Greater than (>) for breadcrumbs (Home>Products>Electronics)

MaxSplit

u32

Maximum number of splits (MaxSplit) to perform. Examples with delimiter '/':

1: a/b/c/d -> [a, b/c/d]
2: a/b/c/d -> [a, b, c/d]

Stops splitting after reaching the limit.

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.