Show/Hide Toolbars

Take Command / TCC Help v. 22

@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