Pad
Description
Allows for padding of characters before or after an input column's value.
Calculation Editor
Options
| Input Parameter Values |
Input Values |
| Left or Right Side |
Left or Right |
| Strip Blanks |
Check Box |
| Padding Character |
Literal Value |
| Total Width |
Literal (Integer Value) |
| Only Rollup If |
Generic Criteria |
| Input |
Input Values |
Required |
| Input 1 |
Column or Literal |
✔ |
- Pad will only evaluate the sides that you select. It will not pad characters in the middle of an input value.
- It is possible to pad columns with spaces as the padding character as well.
- Strip Blanks will remove the blank characters in a column before doing the pad. For example, the business unit column frequently has leading spaces. If you want those spaces to be maintained in the pad, uncheck the "Strip Blanks" check box.
Example
- Input: 45032
- Design > Calculations > Pad
- Left or Right Side: Left
- Padding Character: 0
- Total Width: 8
- Output: 00045032