Formula to Trim Characters From Both Sides of a Field

Description

Sometimes there is a need to trim character(s) from both the left and right side of a field.

For example, the following FIELD has a consistant value that comes in formatted as follows;

Q###.###

The customer would like to trim off the "Q", the trailing zeroes, and the decimal.

Solution

This can be accomplished using a formula, and nesting as many rtrim and ltrim functions as needed

In the example above, the correct formual would be as follows;

rtrim('.',rtrim('0',ltrim('Q',FIELD)))

Refer to the LLM User Guide or Online help for more information on Formulas.