Number of input and output field

Number of input field	:	One
Number of output field	:	Two or more

This transformation function is used to split a field value into two or more fields. The splitting is based on the delimiter string specified in the parameters. For an ASCII-number delimiter, use the keyword char(decimal_ascii_number), for example char(21).
If Accept Unmatched Record Length is not selected (checked), and the number of split values is greater than or less than the number of fields specified in the output record, the input value is treated as invalid data and will be removed from the stream.