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
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.