Differences

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

--- syntax:functions:astext [2015/01/29 22:19] – created dmitry
+++ syntax:functions:astext [2015/04/17 22:51] – elenap
@@ Line 1: / Line 1: @@
 ===== AsText(value) =====
-Converts the //value// to text.
+This function converts the //value// to text.
+This is useful when you wish to validate the contents of a field or retrieve the text value of a field.
-Boolean is converted into TRUE and FALSE.
+  * Boolean is converted into TRUE and FALSE.
+  * Text remains itself.
+  * Errors are converted into text with error message.
+  * Empty cells are converted into empty strings (i.e. '').
+  * Numbers are converted into their text representation.
+  * This function never produces errors, only text
-Text remains itself.
+^  Example  ^  Result  ^
+| astext( 'January' )  |  January  |
+| astext( 125 )  |  125  |
+| astext( 2 + 2 = 4 )  |  TRUE  |
+| astext( 2 + 2 = 5 )  |  FALSE  |
+| astext( 1 / 0 )  |  Error: Division by zero  |
-Errors are converted into text with error message.
-Empty cells are converted into empty strings (i.e. '').
+=== See also ===
+  * [[syntax:functions:asnumber| AsNumber(value)]]
-Numbers are converted into their text representation.
-This function never produces errors, only text.