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. |