String operations
Description
With the String Operations transform, you can perform the following string operations on an incoming Hop field:
-
Trim (remove leading and/or trailing spaces).
-
Convert to upper or lowercase.
-
Pad (add leading or trailing extra characters).
-
Convert to initial capitalization.
-
Ignore escape characters.
-
Remove or return only numeric digits.
-
Remove special characters..
Options
Option | Description |
---|---|
Transform name | Name of the transform. |
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. |