Trim

Syntax

Trim(Source: String)

Parameters

Source. String.

Description

It returns a string with deleted spaces at the beginning and end of the string.

Comments

To remove spaces only at the beginning of the string, use the TrimStart function, to remove spaces only at the end of the string, use the TrimEnd function.

Example

Formula Result Application
= Trim("  Calculator   ")

«Calculator»

Expressions can be used in model formulas of modeling container, in formulas of time series database calculated series, in formulas of the modeling container that is a child one for time series database in expression editor.
= Trim("Calculator   ")

«Calculator»

See also:

Functions Available in Expression Editor │ Text FunctionsString.Trim