Split
| Block Group: | String Operations |
| Icon: | no icon |
The Split block separates an input string into pieces, as defined by a delimiter, and returns the pieces as rows in an output table.
For information on using dataflow blocks, see Dataflow.
Input/Output Properties
The following properties of the Split block can take input and give output.
- input (string)
- separator (string)
input specifies the string to separate into pieces.
separator specifies the character or string that separates the pieces. The default is a comma (,). If separator is empty, a comma is used.
Output Property
The following property of the Split block can give output but cannot take input.
- output (table)
output returns a table that contains the pieces of the input string as rows, in a column named value. If input is null, output returns null.
Example
The following image shows an example of the Split block. In this example, pieces are delimited by commas (,). The output table is also shown in the image.
