Money#() evaluates an expression numerically as a money value, in the format set in the data load script or the operating system, unless a format string is supplied and optional decimal and thousands separators.
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 how the resulting date string is to be formatted. If omitted, the date 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 just like the num# function but takes its default values for decimal and thousand separator from the script variables for money format or the system settings for currency.