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
Reply
Content aside
- 5 mths agoLast active
- 153Views
-
1
Following