Differences

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

--- syntax:functions:istext [2015/04/03 18:56] – elenap
+++ syntax:functions:istext [2021/08/28 20:46] (current) – craigt
@@ Line 1: / Line 1: @@
 ====== IsText(expression) ======
+Category:  Logical function
-Returns TRUE if result of //expression// is text, otherwise returns FALSE. For text cells with empty contents (e.g. ' ') returns TRUE (and so does [[IsEmpty]]).
+\\
+=====Description=====
+This function returns TRUE if the result of //expression// is text.  Otherwise, it returns FALSE.
-^  Example  ^  FieldA  ^  Result  ^
+Text cells with empty contents (e.g., ' ') will return TRUE as well.
-| IsText( [FieldA] )  |  200  |  FALSE  |
-| IsText( [FieldA] )  |  It's a number!  |  TRUE   |
+\\
+=====Arguments=====
+^Argument^Type^Description^
+|expression|Expression|Any expression that could potentially result in text.|
+**Return value type:** Boolean (TRUE/FALSE)
+\\
+=====Examples=====
+  istext('456') //Returns TRUE
+  istext(123) //Returns FALSE
+  istext('This is a number!') //Returns TRUE
+  istext('') //Returns TRUE
+\\
+===== See also =====
+  * [[syntax:functions:isboolean|IsBoolean(expression)]]
+  * [[syntax:functions:isempty|IsEmpty(expression)]]
+  * [[syntax:functions:iserror|IsError(expression)]]
+  * [[syntax:functions:isinteger|IsInteger(expression)]]
+  * [[syntax:functions:isnumber|IsNumber(expression)]]
+  * [[syntax:functions:isnumeric|IsNumeric(expression)]]