Money#() converts a text string to a money value, in the format set in the load script or the operating system, unless a format string is supplied. Custom decimal and thousand separator symbols are optional parameters.
Syntax:
Money#(text[, format[, dec_sep [, thou_sep ] ] ])
Return data type: dual
Arguments:
| Argument | Description |
|---|---|
| text |
The text string to be evaluated. |
| format |
String describing the expected input format to use when converting the string to a numeric interval. If omitted, the money format set in the operating system is used. |
| dec_sep |
String specifying the decimal number separator. If omitted, the MoneyDecimalSep value set in the data load script is used. |
| thou_sep |
String specifying the thousands number separator. If omitted, the MoneyThousandSep value set in the data load script is used. |
The Money# function generally behaves like the Num# function but takes its default values for the decimal and thousand separators from the script variables for money format or the system settings for currency.