Filter
Top Products
Example Frames
148 PT Program Generator (PPG) v5.0
Searching for a Partial Match
A partial match for data in a file may be searched for using the wild card char-
acters “
~” and “*” and a Verify node. By inserting “~,” on the front and
appending a * to the end of a register containing the desired partial match
data and searching the file with that register, the first record with the begin-
ning characters in the second field of the register will be found if one exists.
For example: to look up
Part # in a comma delimited Default File with Loca-
tions
and Prices by Part # such as:
Loc1,0001,1.00
Loc1,0010,2.00
Loc2,0100,10.00
Loc2,1000,100.00
Loc3,1001,250.00
enter 1000 at a prompt. To look up the Price for Part # 1000, insert “~,” in
front of the register and append a “*” to the end of the register so the result is:
~
,1000*
Use that register in a Verify node as the Comparison type against the Default
File to determine whether there is a match.
To search for a partial match, complete the following steps:
1. Input Item ID into
Default Register overwriting.
2. Copy insert “
~,” into the Default Register.
3. Copy append “*” to the
Default Register
Copy: END Copies the constant value “end” to the end of the file being checked.
Verify: END Looks for the constant “end” in the file and stores the index value of the
matching record in a register named INDEX.
Math: INDEX-1 Subtracts 1 from the index value.
Modify: DEL END Deletes the “end” record so that the constant doesn’t corrupt the file.
Output:
POSITION
Positions the cursor at column 8 in the first line, directly after
RECORDS=.
Output: TOTAL Displays the index value at the cursor position on the portable screen.
Input: TO EXIT Waits for a function or data key to be pressed before returning to the
Main frame.
2342.book Page 148 Thursday, July 22, 2004 8:35 AM