Strings cut
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
As of Pentaho 8.3, 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.