Description
This step allows you to cut a portion of a substring. If the designated field is out of range, it returns blank.
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. |