Split fields to rows

Description

The Split Fields To Rows transform splits a row containing a delimited field into multiple new rows, one per split value.

Usage

The original row is not delivered to following transforms.

The original field is left in each new row to assist in debugging or error handling.

It can be removed via a Select Values transform if needed.

The original field must be a string field.

A new field name must be specified.

If the value type/format of the new row is not specified, the new field will use the same type/format as the original field.

Examples

Delimiter Regular Expression to split on a comma, or a space, or a comma + space (* n): [,\s]\s*
Enclosure to keep commas inside quoted values: delimiter , and enclosure " turns hi,"hello, world","hey" into three rows: hi, hello, world, hey.

Options

Option Description

Option	Description
Transform name	Name of the transform.
Field to split	The field you want to split.
Delimiter	The delimiter or separator used. Special characters (e.g. CHAR ASCII HEX01) can be set with the format $[value], e.g. $[01] or $[6F,FF,00,1F].
Enclosure	Optional enclosure string. Delimiters inside a pair of enclosure characters are not treated as split points, and the enclosure characters are removed from the output values. For example with a comma (,) delimiter: `hi,"hello, world","hey"` becomes three rows using enclosure `"`. Doubled enclosure characters inside a quoted value are treated as one literal enclosure. Trailing empty values are preserved, matching the behaviour without an enclosure. An unterminated enclosure is logged and the remainder of the field is kept as one value. This option is ignored when Delimiter is a Regular Expression is enabled.
Delimiter is a Regular Expression	The regular expression to match the delimiter.
New field name	The name of the new field.

Transform name

Name of the transform.

Field to split

The field you want to split.

Delimiter

The delimiter or separator used. Special characters (e.g. CHAR ASCII HEX01) can be set with the format $[value], e.g. $[01] or $[6F,FF,00,1F].

Enclosure

Optional enclosure string. Delimiters inside a pair of enclosure characters are not treated as split points, and the enclosure characters are removed from the output values. For example with a comma (,) delimiter: hi,"hello, world","hey" becomes three rows using enclosure ". Doubled enclosure characters inside a quoted value are treated as one literal enclosure. Trailing empty values are preserved, matching the behaviour without an enclosure. An unterminated enclosure is logged and the remainder of the field is kept as one value. This option is ignored when Delimiter is a Regular Expression is enabled.

Delimiter is a Regular Expression

The regular expression to match the delimiter.

New field name

The name of the new field.