maximum length (Max). When defined, a formula will be performed if the length of
the original data falls between MIN and MAX.
When missing, the following fields of current Formula are always processed.
Example:
LEN,
9
,
48
,
means the length of original data must be within 9 and 48.
Match
Format:
MATCH,
P0
,"
C0
"
,
P1
,
"
C1
"
,
...
,
Pn
,
"
Cn
"
,
a pair of Pn and Cn forms a Match field (n indicates a sequential integer number).
To define a Match field, two parameters are required. The first is character position
(Pn) and the second is a string (Cn). Character position
means the number of
characters, counting from the first character to the one to be positioned in the data
record.
For example, in the following data
BARCODE
'B' has position 1.
'A' has position 2.
...
'E' has position 7.
When Match field is defined, the original data string starts at the position specified by
the first parameter P and will be compared with string "C". If the match is identical,
processing of the current Formula continues.
The position parameter P could be a wild character
*
for any position or
#
for the
last position in the original data. If
#
is used,
#-
N
is valid. Here N is a digit parameter.
The string parameter C can include
*
for any digit or
#
for any letter.
Examples:
MATCH,
3
,"
AB
",#,"
?
",
Checks if the original data has 'A' at position 3, 'B' at position '4' and last character is
'?'.
MATCH ,
10
,
"
*
A*
",
Checks if the original data includes a string with a digit as first character and "A*"