Data Transformation Engine Functions and Expressions Reference Guide

Chapter 3 - Function Reference TONUMBER
Functions and Expressions Reference Guide
210
TONUMBER(text_to_convert, "{L+'$'#','###}")
The L+'$' indicates the leading dollar sign is positive. That leading sign and the
comma separators are removed when the text is converted to a number.
Input String Output Number
Explanation
$123,000,000 123000000
The $ and commas are removed.
TONUMBER(text_to_convert, "{####T-}"
Four number signs (#) are required for each whole number, regardless of the
actual number of digits in the number.
Input string Output Number
Explanation
12345- -12345
The output becomes a negative number.
67890 67890
No change occurs.
345- -345
The output becomes a negative number.
TONUMBER(text_to_convert, "{####T+'K'-}"
If an invalid character, such as an X, is encountered, nothing is returned.
If a K is encountered, it is treated as a positive indicator.
Input String Output Number
Explanation
11212- -11213
The output becomes a negative number.
67890X
The X is an invalid character. No number
is returned.
54354 54354
No change occurs.
34567K 34567
The K is recognized as a positive sign.
The character is removed and the number
is returned as a positive.
345- -345
The output becomes a negative number.