Split Fields
Description
Split Fields divides a single string field into multiple new fields based on a specified delimiter. Use this step when your data contains combined values that need to be separated — for example, splitting a full name into first and last name, breaking apart a comma-separated list into individual columns, or extracting components from a delimited code. You define the output field names, types, and formats for each split segment.
Configurations
| Field Name | Description |
|---|---|
| Step name | Name of the step as it appears in the workflow workspace. This name has to be unique in a single workflow. |
| Field to split | The name of the field you want to split |
| Delimiter | Delimiter that determines the field. Special characters (e.g. CHAR ASCII HEX01) can be set with the format $[value], e.g.$[01] or $[6F,FF,00,1F]. |
| Enclosure | Specify the field enclosure. |
| Fields table | This table is where you define the properties for each new field created by the split. For each new field, you must define the field name, data type, and other properties. |