ARGLEN: Measuring the Length of a String

How to:

The ARGLEN function measures the length of a character string within a field, excluding trailing spaces. The field format in a Master File specifies the length of a field, including trailing spaces.

In Dialogue Manager, you can measure the length of a supplied character string using the .LENGTH suffix.


Top of page

x
Syntax: How to Measure the Length of a Character String
ARGLEN(length, source_string, output)

where:

length

Integer

Is the length of the field containing the character string, or a field that contains the length.

source_string

Alphanumeric

Is the name of the field containing the character string.

output

Integer



Example: Measuring the Length of a Character String

ARGLEN determines the length of the character string in LAST_NAME and stores the result in a column with the format I3:

ARGLEN(15, LAST_NAME, 'I3')

For SMITH, the result is 5.

For BLACKWOOD, the result is 9.


iWay Software