TM1 Function for TI, StringToNumberEx
Converts a string value into a number, based on a specified decimal and thousand separator.
What is the StringToNumberEx function?
StringToNumberEx converts a string value into a number, based on a specified decimal and thousand separator.
Where can the StringToNumberEx function be used?
TurboIntegrator
Which TM1 Server version is this function available for?
Version 11 and 12
What is the syntax for StringToNumberEx?
StringToNumberEx(String, DecimalSep, ThousandsSep);
String = any String
DecimalSep = Decimal separator to be used in the output
ThousandsSep = Thousands separator to be used in the output
A demonstration on how to use StringToNumberEx
Use StringToNumberEx to convert a string variable into a number to 4 decimal places. Decimal character will be set to a full stop, while the thousands operator will be set to a comma.