Length

See Also: String Functions, String, String command, SizeOfString, SizeOfWString, VariantStringLength

Purpose

Length returns the number of code points in a string.

Return Type

Integer

Syntax

(Length( {string-value} ))

What It Does

Length returns the number of code points in {string-value}, including leading and trailing spaces, if present. Note that some characters (especially diacritics) are built up of multiple code points.

String  sMeasure

Integer iLength

Move " 2 4 6" to sMeasure

Move (Length(sMeasure)) to iLength

In this example, the length of string variable sMeasure (6) is moved to iLength

Notes

• When an ASCII or TEXT database table column is passed to the length function, the defined length of the column is returned rather than the number of characters that are stored there. This is because string-type database columns are padded with spaces to the full defined length of the column. You can use trim to remove the extra spaces:

Integer iLength

Move (Length(Trim(Customer.Name))) to iLength