length

Type

Text Function

Purpose

The length function counts the number of character positions in a text value.

Syntax

length( TEXT VALUE)

Returns

An integer value.

Usage

The length function counts all characters, including leading and trailing spaces.

Examples

length( "Sapphire International Ltd." )

Returns: 27

length( "Columbus Island" )

Returns: 15

length( COMPANY NAME)

Returns: The number of characters in the COMPANY NAME field for every record that is processed. If the COMPANY NAME field contains the value Club ParaDEASE, Inc., the function returns20.