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.