Split to Fields

Subject

The subject string to split

Evaluated for each input row

Separator

The separator to use

Evaluated for each input row

Split by Regex

If true, separator is interpreted as a regular expression.

Evaluated for each input row

Limit

The limit setting controls how many parts to produce, and how to handle trailing empty strings:

• If limit == 0 then the separator will be applied as many times as possible, the resulting parts list can have any length, and trailing empty strings are discarded.

• If limit > 0 then the separator is applied at most limit times. The resulting parts list’s length is no greater than the given limit, and the list’s last entry will contain all characters beyond the last matched separator.

• If limit < 0 or if limit is nil then the separator will be applied as many times as possible and the resulting parts list can have any length. Traling empty strings are preserved.

Evaluated for each input row

parts