Split Column
Splits column(s) based on a specified delimiter
Last updated
Splits column(s) based on a specified delimiter
Last updated
The Split Node allows you to split text from one or multiple columns in your dataset into separate columns or arrays based on a specified delimiter.
Select one or multiple columns you want to split in the "Split text from" property. The selected columns should contain text data that will be split using a specified delimiter.
Specify the delimiter to split the text using the "By delimiter" property. You can choose between a text delimiter or a regular expression (regex) delimiter:
Text delimiter: Enter a simple text string that will be used to split the column values.
Regex delimiter: Enter a regular expression (regex) pattern that will be used to split the column values. Find out how to use Regex Using Regex and the list of supported tokens Regex: List of Tokes
In the "Set Into" property, choose one of the following options for the output format:
If you select "Array," the Split Node will create a new column containing arrays with the split parts of the original text.
If you select "Columns," the Split Node will create separate columns for each split part of the original text. You need to specify the number of columns to be created. By default, two columns will be created.
When this option is enabled, the Split Node will not differentiate between uppercase and lowercase characters in the delimiter.
