$trim
$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 “.
See Also