Split column¶
Split a column into several columns on each occurrence of the delimiter. The output columns are numbered: The first chunk will be in prefix_0, the second in prefix_1, and so on.
Examples¶
Split
col=a/b/c
using/
as the delimiter andchunk
as the output column prefixOutput:
chunk_0=a
,chunk_1=b
,chunk_3=c
Split
col=a/b/c
using/
as the delimiter,chunk
as the output column prefix, and keep 2 columns from the beginningOutput:
chunk_0=a
,chunk_1=b
Options¶
Delimiter
Separates values from each input column within the output.
Output columns prefix
Add a prefix to identify the output columns.
Output as
Output the result(s) of the split as separate columns or as an array (A-B
→ ["A",”B”]
).
Truncate
Limit the number of output columns and keep only the first N columns or the N last columns.
Keep empty chunks
Preserve empty chunks between consecutive delimiters. (App
, delimiter p
→ ["A", “”, “”]
)