Truncate text

Reference documentation for using the Truncate text expression

Written By Ben Lehmann

Last updated 9 months ago

Purpose

Extracts a specified portion of text

Parameters

One text field, Two number fields

Returns

Text

Description

The expression allows you to extract a specific portion of the Text field, starting at a defined position and ending at a specified length. This function is very flexible, as it enables you to control both where the truncation begins (the Start Position) and where it ends (the End Position).

Comments

The expression will return the input text, either unchanged or modified depending on the applied text function.

The expression does not require both the Start Position and End Position field to be populated for the expression to be valid.

The expression will account for whitespaces between words within the Text field, this will mean that the positions will include whitespaces.


v3.0