Data Transformation Engine Functions and Expressions Reference Guide

Chapter 3 - Function Reference TEXTTONUMBER
Functions and Expressions Reference Guide
204
TEXTTONUMBER
The TEXTTONUMBER function converts an object defined as text to an object
defined as a character number item.
Syntax
TEXTTONUMBER ( single-text-expression )
Meaning
TEXTTONUMBER ( text_to_convert_to_number )
Returns
This function returns a single-character-number.
The text_to_convert_to_number must be in integer or ANSI-formatted (floating
point) presentation. The resulting number looks like the input argument,
however, nonsignificant zeroes to the right of the decimal separator will be
truncated. If the input argument is in error (for example, it is not a
recognizable as a valid number), the result is NONE.
When specified as in ANSI-formatted presentation, the text string must meet
the following requirements:
! The decimal point can be a period ., a comma , or NONE.
! The leading sign can be a plus sign +, a minus sign -, or NONE.
! No thousands separator is allowed.
Examples
TEXTTONUMBER (OrderQty) returns OrderQty as a character number item.
Uses
Use
TEXTTONUMBER to convert text to a number. The TONUMBER function
provides greater flexibility as to specifying the format of the text item that is to
be converted to a number.
Related Functions
DATETOTEXT, FROMNUMBER, NUMBERTOTEXT, TEXTTODATE, TEXTTOTIME,
TIMETOTEXT, TONUMBER