Please enable JavaScript to view this site.

A-Shell Development History

Language enhancement: the new VALX(a$) function is an extended version of the VAL(a$) function. It supports all of the same behavior as VAL(a$), plus it automatically skips over any amount of non-numeric text preceding the number, and also recognizes common types of numeric formatting such as thousands separators, currency symbols, and parentheses for negatives. This makes it particularly handy for importing values from spreadsheets and reading numeric cells in XTREE.

Examples

Expression

val(expr)

.valx(expr)

123

123

123

123 (leading spaces)

123

123

$123

0

123

123,456.78

123

123456.78

($1,234.56)

0

-1234.56

sale price: USD 0.99

0

0.99