Data Transformation Engine Functions and Expressions Reference Guide

Chapter 3 - Function Reference FROMBASETEN
Functions and Expressions Reference Guide
111
FROMBASETEN
The FROMBASETEN function converts an integer to a text item that can be
interpreted as a number, using positional notation of the base specified.
Syntax
FROMBASETEN (single-integer-expression , single-integer-
expression)
Meaning
FROMBASETEN (positive_integer_to_convert ,
base_to_convert_to)
Returns
This function returns a single-text-item.
FROMBASETEN returns a text item that results from converting
positive_integer_to_convert to a text item that can be interpreted as a number
using positional notation of the base specified by base_to_convert_to.
If base_to_convert_to is less than 2 or greater than 36,
FROMBASETEN
evaluates to NONE. Resulting text item characters A-Z are interpreted as digits
having decimal values from 10-35, respectively. The characters returned are
uppercase.
Example
FROMBASETEN (18 , 2) returns the value 10010
FROMBASETEN (123 , 8) returns the value 173
Uses
Use
FROMBASETEN when you need to convert numbers to a base other than 10.
Related Function
TOBASETEN