JP3143910B2 - File processing device - Google Patents

Description

Description: TECHNICAL FIELD The present invention relates to a file processing device in an office computer or the like.

[Summary of the Invention] The file processing apparatus of the present invention automatically discriminates the sort type by determining the set keyword type and the current keyword type in the file.

[Prior Art] When file processing is performed in a conventional office computer or the like, a user (programmer) determines the necessity of sorting from the arrangement of data in a file on a disk and the arrangement of necessary data, and sorting is necessary. If there is, the procedure of determining which field in the data is to be used as a key is considered, and the computer is instructed by programming. That is, at the time when the user performs programming, the necessity / unnecessity of sorting is determined and instructed.

[Problem to be Solved by the Invention] As described above, conventionally, at the time of programming, a user judges whether sorting is necessary or not and gives an instruction. Therefore, if the file configuration is changed, the file is changed. For all the programs to be processed, there is a problem that sorting is necessary or not necessary, and a sort key or the like needs to be changed.

Such a cause is considered to be attributable to the fact that it is not possible to automatically determine whether sorting is necessary or not at the time of file processing, and the user must make a determination.

Then, at the time of file processing, if it is necessary to automatically determine whether sorting is necessary or not based on the type of set keywords and the arrangement of records on the file, it is possible to automatically sort according to the determination result Obviously, even if the configuration of the file is changed, the user does not need to instruct the program that processes the file to change the sort, necessity, or sort key.

SUMMARY OF THE INVENTION An object of the present invention is to provide a file processing apparatus which can automatically determine whether sorting is necessary or not based on a set type of a keyword and an arrangement of records on a file and automatically perform a sorting process in file processing. That is.

[Means for Solving the Problems] The means of the present invention are as follows.

Storage means for storing records sorted in a predetermined keyword order.

 An example is the source file group 24.

 Keyword setting means for setting an arbitrary keyword.

 An example is the input definition document memory 15.

Determining means for determining whether or not the predetermined keyword matches a type of keyword arbitrarily set by the keyword setting means;

For example, the sorting necessity judging unit 16 judges the necessity of sorting by referring to the setting contents of the input definition document memory 15.

When it is determined that they do not match by this determination means,
Sorting means for sorting records in keyword order based on the set keywords.

 An example is the sort processing unit 18.

Output means for outputting the records sorted by the sorting means in the order of the set keywords.

For example, a form creation unit 21 and a form output unit 22 that operate according to the settings in the output definition document memory 20.

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

When creating a form, a keyword which is a reference for creating the form is set by the keyword setting means. When this keyword is set, it is determined by the determination unit whether or not the set keyword matches the type of keyword determined in advance for the file. Only when this discriminating means determines that the two keywords do not match, the records of the file are sorted in the order of keywords based on the keyword set in the keyword setting means. When the sorting process is completed, the sorted records are output in the order of the set keywords to create a form.

By discriminating the type of keyword set as described above and the type of the current keyword in the file and automatically discriminating the type of sorting, even if the configuration of the file is changed, a user who processes the file can use the program. Eliminates the necessity of sorting, the necessity of sorting, and the necessity of giving an instruction to change the sort key or the like.

Embodiment An embodiment will be described below with reference to FIGS. 1 to 9.

FIG. 1 is a block diagram showing the overall configuration. In the figure, reference numeral 11 denotes a CPU for controlling the entire circuit, which can perform variable length processing. The CPU 11 has an input unit 13, a display unit 14, an input definition document memory 15, a sorting necessity determining unit 16, a definition number memory 17, and a sorting unit 1 via a bus line 12.
8. The output definition document memory 20, the form creation unit 21, the file-specific record structure memory 23, and the source file group 24 are connected. A work file 19 is connected to the sort processing unit 18, and a form output unit 22 is connected to the form creation unit 21.

The input definition document memory 15 stores an input definition document for each source file shown in FIG. 2, and a source file name and a definition key are set in each input definition document. The setting contents of the input definition document memory 15 are
Referred to by The sorting necessity judging section 16 has a register i therein, and stores an input definition document memory during file processing.
The necessity of sorting is determined by referring to the definition contents of No. 15, and if sorting is necessary, the definition number and the sorting direction (ascending / descending order) are set in the definition number memory 17 as shown in FIG.

The output definition document memory 20 stores the output definition documents shown in FIG. 3, and in each output definition document, a word name to be output and an output x coordinate indicating an output position are set. The settings in the output definition document memory 20 are referred to by the form creation unit 21. That is, the form creation unit 21 refers to the settings in the output definition document memory 20 at the time of form creation, and outputs the created form data to the form output unit 22.

The file-specific record structure memory 23 stores the record structure of each file for the source file group 24 as shown in FIG. 5, and as the data, a file name, a keyword, a word No., a word name, etc. are set. Is done. For example, for the file name A, “product code”, “quantity”, and “amount” are set as word names, and “product code” is set as a keyword K. For the file name B, "person in charge code", "product code", "sales amount", and "quantity" are set as word names, and the "person in charge" code and "product code" are used as keywords K. Is set. Source files 24
Stores, for example, records sorted in ascending order based on the keyword K.

FIG. 6 shows a variable-length record format in each file of the source file group 24.
A plurality of "word data" can be stored. In this case, a record delimiter “(” is inserted at the head position of each record, and a delimiter “;” is inserted between “key data” and “word data”.

Next, the operation of the above embodiment will be described with reference to the flowcharts of FIGS.

By inputting a form creation instruction from the input unit 13,
Under the control of the CPU 11, the processing shown in the flowchart of FIG. 7 is executed. First, the CPU 11 displays the input definition document setting screen shown in FIG. 2 on the display unit 14, and guides the data input relating to the source file name and the definition key (step A1). In this input screen, the user defines a source file name and a keyword. Now, for example, if the sales ranking table shown in FIG. 9C is created for the source file B, “B” is designated as the source file name as shown in FIG. (D) "and" person in charge code (U) ". (D) indicates that the sort is in descending order, and (U) indicates that the sort is in ascending order. This input definition document is stored and set in the input definition document memory 15.

When the setting of the input definition document is completed, the setting screen of the output definition document shown in FIG. 3 is displayed on the display unit 14 to guide data input relating to the word name to be output and the output x coordinate (step A2). In this input screen, the user sets a word name and an output x coordinate. This output x coordinate is
This specifies the position of the print start digit of the output data, and is set, for example, with reference to an x-coordinate guide displayed on the screen. FIG. 3 shows a setting example when a sales ranking table including “sales amount”, “person code”, and “product code” is created. This output definition document is stored in the output definition document memory 20.
Is stored and set.

When the setting of the output definition document is completed, the sorting necessity determining unit 16 automatically determines the necessity of sorting by determining the type of the set keyword and the type of the current keyword in the file. In this case, the sort flag is turned on, and if no sorting is required, the sort flag is turned off (step A3). The details of the sorting necessity determination process will be described later.

Thereafter, ON / OFF of the sort flag is checked to determine whether or not sorting is necessary (step A5). If sorting is necessary, a sorting process is executed (step A6), and a form is output (step A7). ). If it is determined in step A5 that sorting is not necessary,
Proceed to A7 to output the form.

Next, the details of the sort determination processing by the sort necessity determination unit 16 in step A3 will be described with reference to FIG. First, the sorting necessity determining unit 16 turns off the sorting flag (step B1), and sets “0” to an internal register i (step B2). Next, the first word of the definition key, "sales amount" in the example of FIG. 2, is read from the input definition document memory 15 (step B3), and the word number corresponding to this read word is read from the file-specific record structure memory 23 (step B4). ), The ascending / descending order for this word number is set in the definition number memory 17 (step B5). In the example of FIG. 5, the word number of “sales amount” in the file B is “3”, and since the “sales amount” is specified in the input definition document memory 15 in descending order, the word number “ 3 is set in the definition number memory 17 to indicate that the order is descending.

Thereafter, the sorting necessity determining unit 16 increments the content of the register i by “+1” (step B6), determines whether the value of i is equal to or greater than the number of definition keys, and if so, proceeds to step B8. If not, proceed to step B9. At this point, the value of i is "1" and the number of defined keys of file B is "2".
The decision result in the step B7 is NO, and the process proceeds to a step B8 to read the word "person in charge" next to the definition key in the input definition document of FIG.

Thereafter, returning to step B4, the corresponding word number "1" of the "person in charge" in the file B is read from the file-based record structure memory 23, and the ascending / descending order, in this case, the ascending order is defined for this word number. Memory 17
(Step B5). Then, the content of the register i is incremented by "+1" to "2" (step B6), and it is determined whether or not the value of i is equal to or greater than the number of definition keys (step B7). Since the number of definition keys in the input definition document memory 15 is “2”, the determination result in step B7 is YES, and the process proceeds to step B9.

In this step B9, it is determined whether or not the number of keys of the record is equal to or larger than the number of defined keys. Since the number of record keys and the number of definition keys of file B are both "2",
The decision result in B9 is YES, and the process proceeds to step B10 to set "1" in the register i. And the definition number memory
The head number "3" is read from 17 (step B11), and it is checked whether or not the read number "3" matches the contents of the register i (step B12). That is, it is checked whether or not the order of the definition keys and the order of the record keys match. In this case, since the content of the register i is "1", the result of the determination in step B12 is NO, that is, it is determined that the order of the definition keys and the order of the record keys do not match. Turn ON.

If the decision result in the above step B12 is YES, that is, if the first order of the definition key and the record key match, the process proceeds to step B13 to further determine whether or not the numbers set in the definition number memory 17 are in ascending order. I do. As a result of this determination, if the order is not ascending, the process proceeds to step B17. If the order is ascending, the process proceeds to step B14, where the content of the register i is incremented by "+1", and it is determined whether or not the value of the register i is larger than the number of definition keys I do. If the value of the register i is larger than the number of definition keys, the order of the definition keys and the order of the record keys match, and both are in ascending order, that is, the file data whose definition contents are stored in the source file. And the sort conditions match, it is determined that sorting is not necessary, and the determination process ends with the sort flag turned off.

If it is determined in step B15 that the value of the register i is not larger than the number of definition keys, the next number is read from the input definition document memory 15, and the process returns to step B12. Hereinafter, the same processing is repeated, and if the definition contents and the sort condition of the file data match, the sort flag is kept in an OFF state, and if not, the sort flag is turned on.
And terminate the processing.

If it is determined in step B9 that the number of record keys is smaller than the number of defined keys, step B1
Proceeding to step 8, the process up to step B24 is performed. In steps B18 to B24, substantially the same processing as in steps B10 to B16 is performed. That is, while it is determined in step B15 whether the value of the register i is larger than the number of definition keys,
In step B23, the only difference is that it is determined whether or not the value of the register i is greater than the number of record keys. The other processing is exactly the same. Step B18 above
Also in the processing from B24 to B24, it checks whether or not the contents of the input definition document and the file data sort conditions match, and turns off the sort flag if the definition contents and the file data sort conditions match. The state is maintained, and if they do not match, the sort flag is turned on and the processing is terminated.

When the sort flag is turned on by the above sort necessity determination processing, the sort processing unit 18 executes the sort processing shown in step A6 of FIG. FIG. 9 shows sorting and form output when a sales ranking table is created from data stored in file B.

FIG. 9 (a) shows the stored data of the file B. This file is sorted by the first keyword "person in charge code" as shown in FIG. "Product code" which is two keywords
Are sorted by

When the sort necessity determination unit 16 determines that sorting is necessary, that is, when the sort flag is turned on, the sort processing unit 18 transfers the contents of the file B from the sort file group 24 to the work file 19. Then, the "sales amount" defined in the input definition document shown in FIG. 2 is sorted as the first keyword, and if the sales amounts are the same, the "person in charge code" is sorted as the second keyword. FIG. 9 (b) shows the result of this sorting.

When the above sort processing is completed, the form creation unit 21 operates to perform the form output processing shown in step A7 of FIG.
That is, the form creation unit 21 reads data from the work file 19 in the order of “sales amount”, “person in charge code”, and “product code” based on the settings in the output definition document memory 20,
The data is output to the form output unit 22 and printed out. FIG. 9 (c) shows an output result of this form (sales ranking table). When the sorting necessity determination unit 16 determines that sorting is not necessary, the form output process is immediately executed without performing the above-described sorting process.

As described above, the necessity of the sorting is determined based on the definition contents set in the input definition document memory 15, and if the sorting is necessary, the form is output after the sorting. If there is no need to sort, that is, if the storage data of the designated file matches the definition contents of the input definition document memory 15, the form is output immediately.

[Effects of the Invention] As described above in detail, according to the present invention, the type of the set keyword and the type of the current keyword in the file are determined, and the necessity of sorting is automatically discriminated as to whether it is unnecessary. It is possible to output the form efficiently without any sort processing, and even if the file structure is changed, the user instructs the program that processes the file whether sorting is necessary or not, sort key etc. This eliminates the need to perform the form output, and the form output can be easily performed.

[Brief description of the drawings]

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 an input definition document, FIG. 3 is a diagram showing a setting example of an output definition document, 4th
FIG. 5 is a diagram showing a storage configuration of a definition number memory; FIG. 5 is a diagram showing an example of data storage in a file-based record structure memory;
FIG. 6 is a diagram showing a variable-length record format of a source file, FIG. 7 is a flowchart showing a form creation process, FIG.
FIG. 19 is a flowchart showing details of the sort determination processing, and FIG.
The figure is a diagram showing a specific example of sorting and form output for a specified file. 11 ... CPU, 12 ... bus line, 13 ... input section, 14 ...
Display unit, 15: Input definition document memory, 16: Sort necessity determination unit, 17: Definition number memory, 18: Sort processing unit,
19 …… Work file, 20 …… Output definition memory, 21…
… Form output unit, 23 …… Record structure memory by file,
24 Source files.

Claims (1)

(57) [Claims] 1. A storage means for storing records sorted in a predetermined keyword order, a keyword setting means for setting an arbitrary keyword, and an arbitrary setting by the predetermined keyword and the keyword setting means. Discriminating means for discriminating whether or not the types of keywords match; and sorting means for sorting records in order of keywords based on the set keyword when the discriminating means determines that they do not match; Output means for outputting the records sorted by the means in the order of the set keywords.