String Operations
Description
String Operations performs a variety of text transformations on string fields, including trimming whitespace, padding with characters, converting case (uppercase, lowercase, InitCap), and removing special characters. Use this step for bulk data cleaning and standardization — for example, trimming trailing spaces from imported data, converting names to proper case, or padding account numbers to a fixed length. You can apply multiple operations to different fields within a single step.
Configurations
| Field Name | Description |
|---|---|
| Step name | Name of the step as it appears in the workflow workspace. This name has to be unique in a single workflow. |
| 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. |