NumberToStringEx
NumberToStringEx converts a number to a string, using the passed string format, decimal separator, and thousands separator.
This function is valid in TM1® TurboIntegrator processes only.
Syntax
NumberToStringEx(Value, NumericFormat, DecimalSep, ThousandsSep);
Argument |
Description |
---|---|
Value |
The real value that you want to convert to a string. |
FormatString |
A TM1 numeric format string that defines the format for the function output. Numeric formats are described inIBM® Cognos® TM1 Perspectives, TM1 Architect, and TM1 Web documentation. |
DecimalSep |
The decimal separator to be used in the output string. |
ThousandsSep |
The thousands separator to be used in the output string. |
Example
sRet=NUMBERTOSTRINGEX(7895.23,'#,0.#########', ',','.');
ASCIIOUTPUT('number_to_string.txt',sRet);
Will return in ascii file;
7.895,23