File Conversion or Filter - SYUTFC

This function allows the user to convert an ASCII text file (in comma delimited format or columnar / space delimited format) from one format to another user-defined format. Some of the functions the user can configure this utility to do is filter out duplicates in the input file based on user-defined keys, omit records or fields based on user-defined flags, create COMP fields in the output file, upshift or downshift fields, right or left justify fields, manipulate substrings within fields and more.

Enter the name of the file to be converted: Enter the comma or space delimited file name (This file will not be changed in any way. A separate file will be generated that is in the new format.)
Filter out duplicates? If you answer "Y" to this question, a file named "DUPLICTS" will be created along with the output file. "DUPLICTS" will be in the new file format and will hold the duplicate records based on the user's configuration of the key fields. The original record will be in the primary output file.
Name for file to be created: Enter the name of the primary output file. The output file is formatted according to how the user has set up two configuration files: CMAP and CDEF. These files are located in the RDF directory. CMAP tells the utility the how any record in the input file is formatted and how to treat the data it finds there. CDEF tells the utility the layout of the primary output file record. The CMAP file provided when BusinessPlus is installed has an example of all the capabilities of SYUTFC. The CDEF file also has an example setup. The utility works as follows: a record is read from the input file, the utility then uses CMAP to find the data it needs in that record and places the data it found in the output file according to the starting position and length indicated in CDEF. This process is then repeated for each record in the input file. If the user has chosen to filter out duplicates, the utility sorts the output file, after the above process has finished, and then sequentially scans the sorted file and puts original records in the primary output file and puts duplicates in the DUPLICTS file.