Money#

- script and chart function

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 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.

The examples below assume the two following operating system settings:

Money format default setting 1: kr # ##0,00
Money format default setting 2: $ #,##0.00

Example	Results	Setting 1	Setting 2
Money#(A , '# ##0,00 kr' ) where A=35 648,37 kr	String:	35 648.37 kr	35 648.37 kr
Money#(A , '# ##0,00 kr' ) where A=35 648,37 kr	Number:	35648.37	3564837
Money#( A, ' $#', '.', ',' ) where A= $35,648.37	String:	$35,648.37	$35,648.37
Money#( A, ' $#', '.', ',' ) where A= $35,648.37	Number:	35648.37	35648.37

Did this page help you?

If you find any issues with this page or its content – a typo, a missing step, or a technical error – let us know how we can improve!

Leave your feedback here