Function: Trim

Description

Trims all leading and trailing spaces from a string.

Syntax

Trim(string)

Arguments

string can be a constant, a character field, an expression that results in a string or a function that returns a string.

Return value

This function returns a character string.

Calculated field example

If the Firstname field contained the value "  Tristan  ", the following calculated field expression would return "Tristan": Trim(Firstname)

Filter/Find example

Records with a Firstname field value of "   Isabella" or "Isabella   " can be selected or found using the expression: Trim(Firstname)="Isabella"