JPH0449417A - File processor - Google Patents

Abstract

PURPOSE:To combine files with a simple difinition by providing this file proces sor with a working means for working the record of a file corresponding to a file name to the record of a 1st common word and a merging means for merging respective files based upon the worked record. CONSTITUTION:A key definition document memory 15 is a memory for storing a key definition document by source file classifications and a source file name and a key word are set up in each key difinition document. A file merging document memory 16 sets up correspondence file names to be merged and the word name of a commonword of respective files and stores instruction data relating to file merging. All records of respective set files are worked to the records of common words based upon set contents. Then plural files worked into the records of the common words is merged to one file. Thus, file merging can be attained by the simple definition without being conscious of the physical structure of files.

Description

DETAILED DESCRIPTION OF THE INVENTION [Field of Industrial Application] The present invention relates to a file processing device in an office computer or the like.

[Summary of the Invention] The file processing device of the present invention defines a correspondence between the file names of files to be merged and the word names of common words in each file, and merges each file based on this definition. be.

[Prior Art] Conventionally, in a file processing device using an office computer or the like, when attempting to merge multiple files and output them as one form in a general-purpose language such as C0BOL, the format and record of the form to be obtained are In addition to the order of , we design and code with consideration to whether or not each input file needs to be sorted, that is, whether each file contains the required records.

[Problems to be Solved by the Invention] As described above, in conventional file processing devices, when merging files, settings for merging must be made with the physical structure of the files in mind, and the settings are extremely difficult. It was a hassle.

An object of the present invention is to provide a file processing device that can perform file merging with a simple definition without being aware of the physical structure of the files.

[Means to solve the problem] The means of the present invention are as follows.

(1) Setting means for setting a correspondence between the file name of a file to be merged among a plurality of files and the word name of a common word in each file.

For example, it is the file merger memory 16.

(2) Processing means for processing the record of the file corresponding to the file name set by the setting means into a record of the set common word.

For example, it is a CPU II that processes records of a specified file according to the contents set in the file amalgamation memory 16.

(3) Merging means for merging each file based on the records processed by the above two means.

For example, it is the CPU 11 that merges processed files based on the settings in the file merge memory 16.

[Effect] The operation of the means of the invention is as follows.

When merging files, first, the association between the file name of the file to be merged and the word name of the common word in each file is set in the file merging document and stored in the file merging document memory. When the file merger document is set, all records of each designated file are processed into common word records based on the settings. Thereafter, the plurality of files processed into records of this common word are merged into one file.

By defining the correspondence between the files you want to merge and the common words in each file as described above, each file will be merged based on that definition, so you can easily define it without having to be aware of the physical structure of the files. It is now possible to merge files.

[Example 1] An example will be described below with reference to FIGS. 1 to 6.

FIG. 1 is a block diagram showing the overall configuration.

In the figure, reference numeral 11 indicates a CP that controls the entire circuit.
U allows variable length processing. This CPU II is connected via a path line 12 to an input section 13, a display section 14, a key definition document memory 5, a file merger document memory 6, an output definition document memory 7, a form creation section 18, and a sort flag memory 2.
0, file-based record structure memory 21, source file group 22, processed file 23, sort file group 24,
Merge file 25 is connected. Further, a form output unit 19 is connected to the form creation unit 18 .

The key definition book memory 5 stores key definition books for each source file shown in FIG. 2, and a source file name and a keyword are set in each key definition book. The setting contents of the key definition book memory 5 are referred to when determining whether or not sorting is necessary.

The file merger book memory 6 is used to set the correspondence between the file names to be merged and the word names of common words in each file when merging files.
As shown in the figure, processing contents, file name, word No. 1
, processing word name, file word name, and other instruction data regarding file merging are stored and set. Note that the shaded area in FIG. 3 is an item name storage column in which a predetermined item name is written in advance.

The output definition document memory 7 stores output definition documents, and in each output definition document, a word name to be output and an output X coordinate indicating the output position are set. The setting contents of the output definition book memory 7 are referred to by the form creation section 18. That is, the form creation unit 18 refers to the settings in the output definition memory 7 when creating a form, and outputs the created form data to the form output unit 19 to print it out.

A sort flag is set in the sort flag memory 20 when it is determined that sorting is necessary when determining whether or not sorting is necessary.

The file-by-file record structure memory 21 stores the file-by-file record structure in the source file group 22, and the file name, keyword, word NO0, word name, etc. are set as the data. The source file group 22 stores records sorted, for example, in ascending order based on the keywords.

Next, the operation of creating a form by merging files in the above embodiment will be explained with reference to the flowcharts of FIGS. 4 and 5. For example, as shown in Figure 6, files A, B, C
will be explained assuming that the data of "person in charge code", "district code", and "sales results" are merged in "order of person in charge code". In this case, in file A, "Affiliation - Responsible Person C".

"Area C" and "Sales" are set as file word names, and the files are sorted using "Affiliation - Person in charge C" as a keyword. This "Affiliation - Responsible Person C" consists of a 2-digit affiliation code and 6
It consists of a digit code for the person in charge. In File B, "Person in charge C0DEJ, r district C0DEJ,
rSales" is set as the file word name, and the file is sorted using "person in charge C0DEJ" as a keyword.

In file C, "Employee CDJ, ('Common charge CD
A file word name of ``J, r district CDJ, r performance'' is set, and ``sorted using employee CDJ as a keyword.''

By inputting an instruction to create a form by merging files from the input unit 13, the process shown in the flowchart of FIG. 4 is executed under the control of the CPU 11. The processing shown in this flowchart is executed under the control of the CPU II.

First, the CPU II displays the setting screen for the key definition document shown in FIG. 2 on the display section 14, and guides data input regarding the definition key. In this input screen, the user defines a keyword (step At). As shown in the example of FIG. 6, when creating a table of sales results in order of code of person in charge, "person in charge code" is defined as a keyword.

Note that in the case of this file merger, there is no need to define the file name. The above key definition document is stored in the key definition document memory 15.

When the setting of the above key definition document is completed, proceed to step A2 and display the file merger document setting screen shown in Figure 3 on the display section 1.
Display on 4. That is, the item names "Processing", "File Name", "Processing Word Name", and "File Word Name" indicated by diagonal lines in FIG. 3 are displayed to guide the data input. As mentioned above, when merging the data of "in charge code", "district code", and "sales results" for files A, B, and C in "in charge code order", click Enter "File Merger," enter the file names of rAJ, rBJ, and rcJ in the "File Name" field, and enter "File Merger."
In the "Processing word name" field, enter the common word names "in charge code", "district code", and "sales results".

For the item "File word name", the above "in charge code", "district code", and "sales record" are set for each file of A to C.

In other words, in file A, the 2-digit affiliation code and the 6-digit staff code are the same, so file A's “
As a file word for the "in-charge code", the affiliation code and the in-charge code are divided, and the 6-digit in-charge code is extracted from the top 3 digits. In addition, the district code of File A is "District C", and the sales record is "Sales".
Set the file word name to retrieve the data.

Similarly, the file word names for file B are set as "person in charge code", "district code", and "sales amount".

Furthermore, the file word name of file C is "Common charge CDJ, r district CDJ."

Set "Achievements". In addition, file C contains [Employee C
Although DJ is included, this data is not necessary for creating the form, so it is not taken out. The file names of the files you want to merge as above and each file A-C
Set the word name mapping for common words in .

This file merger document is stored in the file merger document memory 16.

After completing the above settings for the file merger document, set the output definition document. In this output definition document, the word name to be outputted, for example, "C0DEJ in charge, r district C0DEJ, r sales results" is set, and the output X coordinate is set. This output X coordinate specifies the position of the printing start digit of the output data, and is set by referring to, for example, an X coordinate guide displayed on the screen. This output definition document is stored and set in the output definition document memory 17.

Next, the file merging process shown in step A4 is executed according to the definition contents set in steps Al and A2. Details of this file merging process will be described later.

When the file merging process is completed, the form creation unit 18 operates to create a form based on the results of the file merging process according to the definitions in the output definition memory 17, and outputs it to the form output unit 19 for printing. .

Next, details of the file merging process in step A4 will be explained according to the flowchart of FIG. first,
The first file, ie, file A, is designated by referring to the setting contents of the file amalgamation memory 16 (step B1). Then, the current keyword in the specified file A is read from the file-by-file record structure memory 21, and the newly defined keyword is read from the key definition book memory 15 (Steps B2 and B3), and whether the two keywords match or not. It is determined whether or not (step B4). Through the processing of steps 82 to B4, it is determined whether the specified file is necessary or not, and if there is a mismatch, it is determined that sorting is necessary and a sort flag is set in the sort flag memory 20.Step B5) If so, it is determined that sorting is unnecessary and the sorting flag is reset (step Be). The keyword of the above file A is "affiliation-responsible code" and the newly defined keyword is "responsible code"; both keywords do not match, and the sort flag is set/sorted.

Next, all records of the specified file are processed in the file merger memory 16 based on the settings, and the processed file 23
(Step B7). At this point, for file A in the source file group 22, as shown in FIG. 6, the "in charge code" is separated from the "affiliation - in charge C" and extracted, and the "district C" and "sales" are read out. Processed file 23 contains "in charge code" and "district code" respectively.

Write it as "sales results". That is, each record of file A is processed into a common word record and written into the processed file 23.

Next, the presence or absence of a sort flag is checked from the stored contents of the sort flag memory 20 (step B8). Since the flag is set for file A, the process proceeds to step B9, where file 8 stored in the processed file 23 is sorted by the newly defined keyword "in charge code", and the file is added to the sorted file group 24. Store it as A'.

Next, it is determined whether another file is specified by the file merger memory 16 (step B11), and if another file is specified, the next file, in this case file B, is specified (step B12). ). Thereafter, the process returns to step B2, and the current keyword "in charge code" in file B is read out, and the keyword "in charge code" defined in the key definition book memory 15 is read out and compared for matching (steps B8 and B4). In this case, since both keywords match, the flag in the sort flag memory 20 is reset (step B6), all records of file B are processed based on the file merger memory 16 (step B7), the processed file 23 write to.

Next, the presence or absence of a sort flag for file B is checked from the stored contents of the sort flag memory 20 (step B8). Since the flag is not set for file B, proceed to step BIO and process file 2.
Without sorting file B stored in 3.
The file is transferred as is to the sort file group 24 as file B'.

The process then proceeds to step B12 via step Bll, specifies the next file C, and returns to step B2.

In this file C, the current keyword and the newly defined keyword are different, so the sort flag is set in the sort flag memory 20, all records are processed based on the file merger memory 16, and the sort process is performed. , are stored in the sort file group 24 as file C'.

This completes the processing for all files set in the file amalgamation memory 16, so the process advances to step B13 via step Bll. In step B13, files A'B'C' stored in the sort file group 24 are merged over the keyword "in charge code" defined in the key definition memory 15 as shown in FIG. and write it to the merge file 25. As a result, the data of files A', B', and C' are "responsible codes"
The files are sorted into one file and stored in the merge file 25.

This completes the file merging process in step A4, and the process proceeds to step A5 in FIG. In this step A5, the form creation unit 18 creates a form from the data stored in the merge file 25 according to the definition contents of the output definition memory 17,
It is output to the form output unit 19 and printed out.

As shown above, multiple files are merged into file memory 1
The merge process is performed according to the settings in step 6, and the files are combined into one file, and a form is created according to this file.

[Effects of the Invention] As detailed above, according to the present invention, it is possible to define a correspondence between the file names of files to be merged and the word names of common words in each file, and to merge each file based on this definition. , it is possible to merge files with a simple definition without having to be aware of the physical structure of the files.

[Brief explanation of the drawing]

FIG. 1 is a block diagram showing a circuit configuration of a file processing device according to an embodiment of the present invention, FIG. 2 is a diagram showing an example of setting a key definition document, and FIG. 3 is a diagram showing an example of setting a file merger document.
FIG. 4 is a flowchart showing the overall processing operation for creating a form, FIG. 5 is a flowchart showing details of file merging processing, and FIG. 6 is a diagram showing a specific example of file merging. 11...CPU, 12...Pass line, 13...Input section, 14...Display section, 15...Key definition document memory, 16...File merger document memory, 17...Output Definition book memory, 18... Form creation section, 19... Form output section, 20... Sort flag memory, 22... Source file group, 23... Processing file, 24... Sort file group , 25...Merge file.

Claims (1)

[Claims] Setting means for setting a correspondence between a file name of a file to be merged among a plurality of files and a word name of a common word in each file, and a record of a file corresponding to the file name set by the setting means. What is claimed is: 1. A file processing device comprising: processing means for processing a record into a record with a set common word; and merging means for merging each file based on the record processed by the processing means.