HP Data Entry and Forms Management System (VPLUS) Reference Manual (32209-90024)

188 Chapter5
Reformatting Specifications
Relation of Forms to Output Records
Data from the batch file illustrated in Figure 5-3. can be reformatted in many different
ways. For example, Figure 5-4. shows how this same data could be combined into two
output records with data from forms A and B appearing in both records. Note that when
the same field appears more than once, it must be given a unique field name for each
occurrence (this is not specifically shown in Figure 5-4.)
Figure 5-4. Reformat Data from 3 Forms into 2 Output Records
data:
form A
form B
form C
form A
form B
form C
fields:
F1 - F6 (A)
1
2
rec #
GLOBALS
INPUT FORMS SEQ
OUTPUT REC. DEF
form A (Ref. Id)
form B
form C
* = start-of-record marker
REFORMAT FILE
BATCH FILE
OUTPUT FILE
rec #
1
2
3
4
5
6
3
4
field 1 form A*
field 6 form A
field 1 form C
field 4 form C
field 1 form A*
field 5 form C
field 10 form C
“Literal”
field 1 form B
field 8 form B
OUTPUT FIELD 1A
OUTPUT FIELD 8B
F1 - F4 (C)
F1 - F6 (A)
F1 - F4 (C)
F1 (A)
F5 - F10 (C)
“Literal”
F1 - F8 (B)
F1 (A)
F5 - F10 (C)
“Literal”
F1 - F8 (B)
(8 fields)
(10 fields)
(6 fields)