NUMS Function

Determines whether each element in a dynamic array is a numeric value.

Syntax

NUMS(dynArray)

Syntax Elements

dynArray A DataBasic expression that evaluates to a dynamic array.

Return Value

A dynamic array with the same structure as dynArray, but with each numeric value replaced by 1 or 0.

An element is set to 1 (true) if it evaluates to a number or a numeric string (see Numeric Data for the format of a numeric string).

An element is set to 0 (false) if it evaluates to a non-numeric string.

A empty string is considered to be numeric.

Example

ARY = 27:@AM:"42":@AM:"":@AM:@AM:"Status Quo"
NEWARY = NUMS(ARY)

Sets NEWARY to "1AM1AM1AM1AM0".