This screen demonstrates the use of the "Substring of a field/record" option and how it may be used in breaking down a field/record after input from a file.
Using the example of the accounting file ACCMST and the chart of accounts field CHTACC described in the last section, the "virtual" field COMPNO can be derived from the "real" field CHTACC as follows:
|
A similar substringing operation could be performed on CHTACC to derive virtual fields DIVNUM and COSTCT simply by specifying a start position of 3 for DIVNUM and 5 for COSTCT.