Use this function to test if a string contains a valid numeric value. The system returns one (1) if the string is a valid number and zero (0) if not.
Parameter |
Description |
String |
Enter a valid string. The default is the value of the current field. |
The system returns true or false depending on whether the string parameter contains a valid numeric value.
Leading or trailing spaces are removed before the string is evaluated. A numeric value contains only numbers, a sign (leading or trailing), and a single decimal point.
Here are some examples:
(Assume the current field value is -101.564)
Function |
Result |
Explanation |
Numeric ( ) |
1 |
Defaults to the current field and determines a true statement, such as if the field contains a valid numeric value. |
Numeric ("123T456") |
0 |
Determines a false statement, such as if the field does not contain a valid numeric value. |
IF Numeric ("4633392") result = "Yes"; ELSE result = "No"; END Return(Result) |
"YES" |
The specified value is numeric therefore the variable result will be assigned Yes.
|
© Copyright 2017, Oracle and/or its affiliates. All rights reserved. Legal Notices