Function: InTrim
Description
This function trims to a single space any sequence of two or more consecutive spaces within a string. It also removes any leading or trailing spaces from the string.
Syntax
InTrim(string)
Arguments
string is the string in which you want to trim consecutive spaces greater than one space. 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 string.
Calculated field example
If a Contact field contained " John Smith ", the following calculated field expression would return "John Smith": InTrim(Contact)
Filter/Find Example
Records with the value "John Smith" can be selected or found with the expression: Intrim(Contact)="John Smith"
© 2024 Altair Engineering Inc. All Rights Reserved.