9.16 CHECKNUMERIC
Note: Built-In Function Rules Usage Options
Checks a string only contains allowable values and converts the digital and decimal portions into numeric variables.
Arguments
|
No
|
Type
|
Req/ Opt
|
Description
|
Min Len
|
Max Len
|
Min Dec
|
Max Dec
|
|
1
|
A
|
Req
|
String to be converted
|
1
|
256
|
|
|
|
2
|
N
|
Opt
|
Max. no. of integers allowed
Range: 0 - 63
Default: 15
|
1
|
3
|
0
|
0
|
|
3
|
N
|
Opt
|
Max. no. of decimals allowed
Range: 0 - 63
Default: 9
|
1
|
3
|
0
|
0
|
|
4
|
A
|
Opt
|
List of allowable characters to be ignored e.g. $, %, C, R
|
1
|
50
|
|
|
|
Return Values
|
No
|
Type
|
Req/ Opt
|
Description
|
Min Len
|
Max Len
|
Min Dec
|
Max Dec
|
|
1
|
N
|
Req
|
Return integer portion
|
1
|
Unlimited
|
0
|
0
|
|
2
|
N
|
Opt
|
Return decimal portion
|
1
|
Unlimited
|
1
|
Unlimited
|
|
3
|
A
|
Opt
|
Return okay code (Y/N)
|
1
|
1
|
|
|
|
4
|
A
|
Opt
|
Return sign of the number (+ or -)
|
1
|
1
|
|
|
|
5
|
N
|
Opt
|
Return number of integers
|
1
|
3
|
0
|
0
|
|
6
|
N
|
Opt
|
Return number of decimals
|
1
|
3
|
0
|
0
|
|
Example
To get a packed decimal 9,2 result field #P92 from an alphanumeric field #A using 2 intermediate work fields called #P90 and #DEC.
USE BUILTIN(CHECKNUMERIC) WITH_ARGS(#A 7 2) TO_GET(#P90 #DEC)
CHANGE FIELD(#P92) TO('#P90 + #DEC')
