length(
TEXT
)

The length( function counts the number of characters in a text value (also called a string).


Parameters

This function has one parameter:

text – The item of text you want to know the length of.


Description

The length( function counts the number of characters in a string. The result is an integer. If the string is empty, the result will be zero.

length("abc") ☞ 3
length("") ☞ 0
length(1234) ☞ 4
length("Ⓒ") ☞ 1

Note: The length returns the number of characters, not the length in bytes. For ASCII characters these are the same, but for many Unicode characters this will be different. For example, in the final example above the character count is 1, but the actual number of bytes is 2. For most applications the actual number of bytes is unimportant.


Error Messages

length( function must have one (and only one) parameter. – Variations like length() or length("abc","def") are not allowed.


History

VersionStatusNotes
10.0No ChangeCarried over from Panorama 6.0