Trim
Description
Trim characters before or after a value.
Calculation Editor
Options
| Input Parameter Values | Input Values |
|---|---|
| Trim Delimiters | Literal (Required) |
| Side | Both, End, Start |
| Only Rollup If | Generic Criteria |
Input
| Input | Input Values | Required |
|---|---|---|
| Input 1 | Column or Literal | ✔ |
Remarks
Trim will only evaluate the sides that you select. It will not trim characters in the middle of an input value.
Example
- Input: 00045032000
- Design > Calculations > Trim
- Trim Delimiters: 0
- Side: Both
- Output: 45032