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 |