PLEASE NOTE: This documentation applies to Pentaho 8.3 and earlier. For Pentaho 9.0 and later, see String Operations on the Pentaho Enterprise Edition documentation site.
Description
Apply operations, such as trimming, padding, and others to the string value.
Option | Definition |
|---|---|
Step name | The name of this step as it appears in the transformation workspace. |
In stream field | Designate the field to transform. |
Out stream field | Designate the name of the field to be created. |
Trim type | Designate the trim type: none, left, right, or both. |
Lower/Upper | Designate upper or lowercase. |
Padding | Designate left or right padding. |
Pad char | Designate the padding character. |
Pad Length | Designate how long the padding will be. |
InitCap | Transform to initial capitalization. |
Escape | Define to Escape or Unescape XML, HTML, use CDATA or Escape SQL. |
Digits | Designate whether to return remove, or do nothing to digits. |
Remove Special character | Designate a special character to remove. |