SplitExact / String Layer

Split strings into a controlled number of parts using a delimiter. Similar to Python's str.split(maxsplit=n). Creates a list column with a precise number of parts. Useful for:

Parsing fixed-format data (first_name last_name)
Extracting specific fields from structured text
Breaking down formatted identifiers
Processing columns with known number of components

Table

Select

column

The string column to split. Each value will be split into exactly MaxSplit + 1 parts.

Delimiter

string

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

Space ( ) for name parts
Hyphen (-) for phone numbers
Dot (.) for version numbers
Underscore (_) for structured IDs

MaxSplit

u32

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

1: John Smith Doe -> [John, Smith Doe]
2: John Smith Doe -> [John, Smith, Doe]

Remaining delimiters are kept in the last part.

Inclusive

bool

false

If true, includes the delimiter in output parts. Examples with delimiter ',' and max_split=1:

false: a,b,c -> [a, b,c]
true: a,b,c -> [a,, b,c]

Useful for maintaining exact formatting

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.