@NUMERIC[[+|-]string] : Returns 1 if string is numeric, and 0 otherwise.
To be numeric, the following must be true:
1. | The first character may be a + or - sign, |
2. | The next character must be a decimal digit (0 to 9) or the decimal separator. |
3. | The remainder of string must be composed entirely of decimal digits (0 to 9), the thousands separator, and no more than a single decimal separator, with no thousands separators following the decimal separator. |
Examples:
function |
value |
%@numeric[12345] |
1 |
%@numeric[-12345] |
1 |
%@numeric[.12345] |
1 |
%@numeric[$12.34] |
0 |
%@numeric[5.00.125] |
0 |
%@numeric[+5.00.125,5] |
0 |
%@numeric[.00.125] |
0 |
%@numeric[-5,.00.125] |
0 |