Altair® Monarch®


Function: InTrim


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.




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"