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.