NthLine / String Layer

Extract the nth line (0-based index) from multi-line strings. Similar to Python's str.splitlines()[n] or getting a specific line in file processing. Returns null if the specified line doesn't exist or for empty strings.

Common applications:

Extracting specific record fields
Reading structured text data
Processing fixed-format logs
Getting specific configuration lines
Analyzing multi-line protocols
Extracting data from formatted reports

Note: Uses 0-based indexing (first line is at position 0).

Table

Select

column

The string column containing multi-line text. Examples with n=1:

'Line1\nLine2\nLine3' → 'Line2'
'Header\nData\nFooter' → 'Data'
'First\nSecond' → 'Second'
'Single line' → null (no second line)

N

u32

Zero-based index of the line to extract. Examples:

0: first line
1: second line
2: third line

Returns null if line number exceeds available lines

AsColumn

name

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.