Data Transformation Engine Functions and Expressions Reference Guide

Chapter 3 - Function Reference FROMNUMBER
Functions and Expressions Reference Guide
113
Uses
Use
FROMDATETIME to convert a date/time item into a string for parsing or
concatenation. Also, use
FROMDATETIME when you want to access the
individual parts of a date or time, such as the month, day, year, and so on.
Related Functions
CURRENTDATE, CURRENTDATETIME, CURRENTTIME, DATETOTEXT,
TODATETIME
FROMNUMBER
The FROMNUMBER function converts a number to a text string of a specified format.
Syntax
FROMNUMBER (single-character-number-item
[ , single-text-expression] )
Meaning
FROMNUMBER (number_to_convert [ , number_format_string ] )
Returns
This function returns a single-character-text-item.
Returns the number specified by number_to_convert as a text item with the
format specified by number_format_string. If number_format_string is not
specified, number_to_convert will be returned in the same format as the
number_to_convert.
The date_time_format_string must conform to the number format strings as
described in Appendix B - Format Strings.
Examples
Greeting = "You are caller number " + FROMNUMBER
(SeqNo:.:History, "{#','###}") + "!"
If the value of SeqNo is 2348192, this rule evaluates to "You are caller
number 2,348,192!"
"$" + FROMNUMBER(CurrentRate Field:.:Schedule,
"{#','###'.'2##2}")