Adds characters to the beginning or end of a string field to meet a specified length. The original string is preserved within the padded result.
Configuration Options
- Select Fields: Choose one or more fields to transform.
- Direction:
- Left: Pads characters at the beginning of the string.
- Right: Pads characters at the end of the string.
- Character: The string to use for padding. Can be one or more characters.
- Length: The total length of the final string, including the original string and padding.
Example
| Input Field (ID) | Direction | Character | Length | Output |
|---|---|---|---|---|
| 123 | Left | 0 | 5 | 00123 |
| ABC | Right | - | 6 | ABC-- |