Skip to end of metadata
Go to start of metadata

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.

Article Number

 2014058

Versions

 All supported Loftware versions.

Environment

All supported installation environments.