This step allows you to cut a portion of a substring. If the designated field is out of range, it returns blank.
Options
This step has the following options:
Option | Definition |
|---|---|
Step name | The name of this step as it appears in the transformation workspace. |
In stream field | Name of the field whose substring to cut. |
Out stream field | When a field name is given here, the step creates a new field with the substring. Otherwise the original field gets replaced by the substring. |
Cut from | Designate where to begin cutting the substring. This value is 0-based, thus the first character in a string is 0. |
Cut to | Designate where to end cutting the substring. This value is exclusive (1-based), so using a 1 includes the first character. The maximum length of the new string is Cut to minus Cut from. |
Metadata injection support
All fields of this step support metadata injection. You can use this step with ETL metadata injection to pass metadata to your transformation at runtime.