User Tools

Site Tools


syntax:functions:astext

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.txt · Last modified: 2015/04/18 02:51 by elenap