User Tools

Site Tools


syntax:functions:astext

Differences

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

Link to this comparison view

syntax:functions:astext [2015/01/30 03:19]
dmitry created
syntax:functions:astext [2015/04/18 02:51] (current)
elenap
Line 1: Line 1:
 ===== AsText(value) ===== ===== 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.+
syntax/functions/astext.txt · Last modified: 2015/04/18 02:51 by elenap