Panel | ||||||||||
---|---|---|---|---|---|---|---|---|---|---|
| ||||||||||
PLEASE NOTE: This documentation applies to an earlier version. For the most recent documentation, visit 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. |