Calculation Formulas

Back to Calculation Formulas Overview
Back to Functions Overview

Function "Trim"

Trim(arg)

Function: Trims leading and trailing whitespace from the given text argument (or set of texts), i.e. returns a text (or set of texts) where all leading and trailing whitespace has been removed. (This functions interprets all characters with an ASCII-value of 32 (20h) or lower as whitespace.)

Return-Type: Text or Text Set

Arguments:
arg - Type Text or Text Set: If a single text is given, then this text is trimmed and the result is returned. If a set of texts is given, then all texts in the set will be trimmed and a set with these trimmed texts is returned.

Examples:
Trim("   this text has whitespace at beginning and end     ")