The fields to cut

The fields to cut table in the Strings cut step

Use The fields to cut table to specify what fields to cut and where to cut them.

The table contains the following columns:

Column	Description
In stream field	Name of the field containing the string to cut. Use Get fields to populate the table with fields from the incoming PDI data stream.
Out stream field	(Optional) A new outgoing PDI field containing the resulting substring. If you do not specify a value for this field, the In stream field is replaced by the resulting substring.
Cut from	The character location at the starting point of the substring. This value is zero-based. The first character of the entire input string has an index of 0.
Cut to	The character location after the ending point of the substring, such that the substring cuts up to but not including the value entered. The value is zero-based but is exclusive. For example, setting Cut to to a value of 1 returns the first character in In stream field.

The maximum length of the resulting string is Cut to minus Cut from.