Function: Trim


Trims all leading and trailing spaces from a string.




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.

Intellectual Property Rights Notice | Technical Support