Altair® Monarch®

 

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"