StringToNumberEx
StringToNumberEx converts a string to a number, using the passed decimal separator and thousands separator. If the input string is an invalid number string, the value returned will be an invalid floating point value.
This function is valid in TM1® TurboIntegrator processes only.
Syntax
StringToNumberEx(String, DecimalSep, ThousandsSep);|
Argument |
Description |
|---|---|
|
String |
The string that you want to convert to a number. |
|
DecimalSep |
The decimal separator to be used in the output number. |
|
ThousandsSep |
The thousands separator to be used in the output number. |
Example
nRET = StringToNumberEx('12453.45', ' . ', ' , ');