Trim Merge Method

Usage | Parameters | Examples | Remarks

The Trim merge method removes leading and trailing white space from text values.

Usage

Trim(TextToTrim)

Remove white space from both the beginning and end of the provided text

TrimStart(TextToTrim)

Remove white space from only the beginning of the provided text

TrimEnd(TextToTrim)

Remove white space from only the end of the provided text

Parameters

 TextToTrim  Text

The text that will have its white space removed.

Examples

Example 1

Set the default value of a zone to be the value another zone with any leading or trailing spaces removed.

Removing any white space from a default value

Example 2

Set the default value of a zone to be the value another zone with any leading spaces removed.

Removing any white space from a default value

Remarks

To remove all white space within a value (not just the leading and trailing spaces), consider using the Replace method as shown in the example below.

<<Replace([<<ZoneName>>],[\s],[])>>