length

To return the count of all characters in a string or all items in an array

This function returns the number of characters (with spaces) of a given text or the number of items in a given array.

You can use this function for calculations with the size of an array, compare strings, or check if fields contain a certain number of characters.

Together with the functions substr() or index(), this function could also help you to return the number of characters from a specific starting point.

Syntax

length(string)

length([any])

Return

number

Examples

length("Ninox is great!")

Result: 15

length(["A", "B", "", "D", null])

Result: 5

See also

count, which returns the number of concrete items in an array.

index, which returns the first position of appearance of the match in the string.

substr, which returns a substring out of a given text.

text, which converts a value to a string and possibly reflects the format options.