LEFT - Extract the first number of characters from a string (Reports & Settings Report Generator function)

From Catalyst
Revision as of 13:04, 22 September 2016 by ThrashBot (talk | contribs) (Updated from revision control)
(diff) ← Older revision | Latest revision (diff) | Newer revision → (diff)
Jump to: navigation, search

Syntax

$LEFT{string, len}

Description

Return the string from the start of another string.

Parameters

string
A text parameter that can not be omitted.
The source string.
len
A numeric parameter that can not be omitted.
The maximum number of characters.

Returns

A text value. Return the leftmost len characters, if len is greater than the string length then all the string will be returned.