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

1. Input: 00045032000
2. Design > Calculations > Trim
   • Trim Delimiters: 0
   • Side: Both
3. Output: 45032