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"
© 2024 Altair Engineering Inc. All Rights Reserved.