Num#

- script and chart function

Num#() converts a text string to a numerical value, in the number format set in the data load script or the operating system. Custom decimal and thousand separator symbols are optional parameters.

Syntax:

Num#(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 number format set in the operating system is used.
dec_sep	String specifying the decimal number separator. If omitted, the DecimalSep value set in the data load script is used.
thou_sep	String specifying the thousands number separator. If omitted, the ThousandSep value set in the data load script is used.

The examples below assume the two following operating system settings:

Number format default setting 1: # ##0
Number format default setting 2: #,##0

Example	Results	Setting 1	Setting 2
Num#( A, '#.#', '.' , ',') where A=35,648.375	String:	35,648.375	35,648.375
Num#( A, '#.#', '.' , ',') where A=35,648.375	Number:	35648.375	35648.375

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