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.