TRIMMED

Syntax:

TRIMMED(C data)

Return Value:

C result

Description:

This function removes any trailing spaces from a field that you want to manipulate ina formula. Note that this only works within one formula - trailing spaces will always be added to a character result when it is stored in a longer character variable.

Example:
        " Hello World "  CONCAT " Hello World " = " Hello World  Hello World "
TRIMMED(" Hello World ") CONCAT " Hello World " = " Hello World Hello World "