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
1
length("Ninox is great!")
Result: 15
​
1
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.

latitude

Last modified 1yr ago