Differences

This shows you the differences between two versions of the page.

--- syntax:functions:len [2015/03/29 21:45] – elenap
+++ syntax:functions:len [2021/08/02 02:59] – craigt
@@ Line 1: / Line 1: @@
-===== Len(text) =====
+====== Len(text) ======
+Category:  Text function
-Calculates the number of characters (length) of a //'text'// value. Can be used with specific 'text' or a [filed] - see Example 2
+\\
+=====Description=====
+This function returns the number of characters (length) in the //text// value.
-^  Example  ^  Result  ^
+\\
-|  len('Telecommunications')  |  18  |
+=====Use cases====
-|  len([revenue])  |  (returns number of characters in each row)  |
+This function can be used to determine if there are unexpected non-printing characters in a text string.
+\\
+=====Arguments=====
+^Argument^Type^Description^
+|text|Text|The text string evaluated to determine the number of characters it contains.|
+**Return value type:** Number
+\\
+=====Remarks=====
+The number of characters returned //includes// unseen, non-printing characters (space, line feed, tab, etc.)
+//text// is implicitly converted to text values if required
+\\
+=====Examples=====
+  len('Telecommunications') = 18
+  len('Computer sciences') = 17  //Includes the space
+  len(' Genetics ') = 10  //Includes leading and trailing spaces
+  len('Psychology' & char(9)) = 11  //char(9) = tab, included in the length
+  len(1000000) = 7  //Implicit conversion of a numeric value to text
+  len('') = 0  //An empty string has a length of 0
+  len([MyClass]) = 12  //Using a field name; [MyClass] = 'Astrophysics'
+\\
+===== See also =====
+  * [[syntax:functions:ifempty|IfEmpty(value, new_value)]]
+  * [[syntax:functions:isempty|IsEmpty(value)]]
-**See also**
-  * [[syntax:functions:isempty]]
-  * [[syntax:functions:ifempty]]