TM1 Function for TI, StringToNumberEx

Converts a string value into a number, based on a specified decimal and thousand separator.

Available In

TurboIntegrator

Definition

StringToNumberEx converts a string value into a number, based on a specified decimal and thousand separator.

Syntax

StringToNumberEx(String, DecimalSepThousandsSep);

String = any String
DecimalSep = Decimal separator to be used in the output
ThousandsSep = Thousands separator to be used in the output

Video Demo

Use StringToNumberEx to convert a string variable into a number to 4 decimal placesDecimal character will be set to a full stop, while the thousands operator will be set to a comma.