Developer

@PARSE_FORMATTED_DECIMAL

The PARSE_FORMATTED_DECIMAL function converts the given string into a decimal. It takes up to two optional parameters that are used for deciphering the format of the number stored in the string.The first parameter is the value to be converted and is required. This parameter is evaluated as a string, and a decimal is created from it using the optional parameters or the client’s locale. This string must be a valid representation of a decimal.

Parameters

    @PARSE_FORMATTED_DECIMAL (String [, Decimal Point, Thousands Separator])
  • String Required string parameter, contains the value to be parsed interpreted as a string and parsed into a decimal by the function.
  • Decimal Point Optional string parameter with a default value of the client’s locale decimal separator. This value may be set to any single character to be considered as a decimal separator.
  • Thousands Separator Optional string parameter with a default value of the client’s locale thousands separator. This value may be set to any single character to be considered as separating thousand and hundreds, millions and hundred thousands, etc.

Supported Return Types

Decimal