$trim

Trims leading and trailing blanks from a character string in a field.

Syntax

$trim(string)

Parameters

string

a character string, or any expression that evaluates to a character string

Return Value

Character string.

Comments

Use $trim to remove leading and trailing spaces from a character string in a field.

For output purposes, the implicit length of the result returned by $trim is the same as the length of string.

Example

$trim(LastName)

Evaluates to "Smith" if LastName is stored as " Smith ".

 

Related Topics