Technical data

Chapter 11 Using Built-in Functions in Analytic M odels

Example

LEFT("StringF

un", 6) returns String.

LEN

Syntax

LEN(Text)

Description

The LEN FUNCTION returns the number of characters in text string.

Returns

Thenumberofcharactersintextstring.

Example

LEN("StringF

un") returns 9.

LOWER

Syntax

LOWER(Text)

Description

The LOWER FUNCTION returns text converted to lower case.

Returns

Text converted to lower cas e.

Example

LOWER("Strin

gFun") returns stringfun.

MATCH

Syntax

MATCH(Text E

xpression or Text Cube, Pattern, {Case Sensitive}, {Match Type})

Description

The MATCH function returns True if Text Expression or Tex t Cube matches Pattern.

Pattern can be any of the following:

• A text value i

n quotes (for e xample, "hello").

• A data cube wi

th a Text format.

• The VALUE fun

ction, as in VALUE("Name").