syntax:functions:astext
This is an old revision of the document!
AsText(value)
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.
- 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
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 |
See also
syntax/functions/astext.1429325474.txt.gz · Last modified: 2015/04/17 22:51 by elenap