LeftValues function

Contents > Functions reference (alphabetical list) > Text functions > LeftValues function

LeftValues function

Format


LeftValues(text;numberOfValues)

Parameters

text - any text expression or text field

numberOfValues - any numeric expression or field containing a number

Important See Design functions for information about literal text parameters.

Data type returned

text

Description

Returns a text result containing the specified numberOfValues from the list of values in text, counting from the left.

Values are text items separated by carriage returns. A value can be empty, a single character, a word, a sentence, or a paragraph. When you press Return you start creating a new value. The last value will be recognized with or without a carriage return.

Each returned value ends with a carriage return, allowing lists to be easily concatenated.

Examples

LeftValues("Plaid¶Canvas¶Suitcase";2) returns

Plaid

Canvas

LeftValues(list;1) returns

Sophie

when the text being evaluated contains

Sophie

Bill

Related topics

Functions reference (category list)

Functions reference (alphabetical list)

About formulas

About functions

Defining calculation fields

Using operators in formulas

Contents > Functions reference (alphabetical list) > Text functions > LeftValues function