JPH0449416A - File processor - Google Patents

Abstract

(57) [Summary] This bulletin contains application data before electronic filing, so abstract data is not recorded.

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 automatically discriminates the type of sorting by determining the type of keyword set and the type of the current keyword in the file.

[Prior Art] When processing files on a conventional office computer, etc., the user (programmer) determines the necessity of sorting based on the arrangement of data in files on the disk and the arrangement of required data. If so, they come up with procedures such as which fields in the data should be used as keys for sorting, and instruct the computer through programming. In other words, the user determines and instructs whether sorting is necessary or not at the time of programming.

[Problem to be solved by the invention] As mentioned above, conventionally, at the time of programming,
The user determines whether sorting is necessary or not and gives instructions, so if the file structure is changed, all programs that process that file will be asked whether sorting is necessary or not.
There was a problem that it was unnecessary and required changes to the sort key, etc.

This is due to the need for sorting during file processing.
It is thought that it is not possible to automatically determine whether something is unnecessary, and the user must make the decision themselves.

When processing a file, you can determine the sorting requirements based on the type of keyword set and the order of records on the file.
If unnecessary files are automatically determined and sorted according to the results of the determination, even if the file structure is changed, the user will be able to determine whether or not the files need to be sorted and whether they need to be sorted by the sort key in the program that processes the file. It is clear that there is no need to instruct changes such as.

An object of the present invention is to provide a file processing device that can automatically determine whether sorting is necessary or not based on the type of set keyword and the arrangement of records on the file, and automatically perform the sorting process. That's true.

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

Storage means for storing records sorted in predetermined keyword order.

For example, it is the source file group 24.

Keyword setting means to set arbitrary keywords.

For example, it is the input definition document memory 15.

Discrimination means for determining whether or not the predetermined keyword matches the type of keyword arbitrarily set by the keyword setting means.

For example, it is a sorting necessity determining section 16 that refers to the settings in the input definition document memory 15 and determines whether or not sorting is necessary.

When this determining means determines that they do not match, a sorting means sorts the records in keyword order based on the set keyword.

For example, it is the sort processing section 18.

An output means that outputs records sorted by this sorting means in the order of set keywords.

For example, the form creation section 21 and the form output section 22 operate according to the settings in the output definition memory 20.

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

When creating a form, the keyword setting means sets a keyword that becomes a standard for creating the form. When this keyword is set, the determining means determines whether or not this set keyword matches the type of keyword predetermined for the file. Only when this determining means determines that the two keywords do not match, the records of the file are sorted in keyword order based on the keyword set in the keyword setting means.

When this sorting process is completed, the sorted records are output in the order of the set keywords to create a form.

By automatically determining the sorting type by determining the keyword type set above and the current keyword type in the file, even if the file configuration is changed, the user There is no need to instruct whether sorting is necessary or not, or to change the sort key.

[Example] An example 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 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, an input definition document memory 15, a sort necessity determination section 16, a definition number memory 17, a sort processing section 18, an output definition document memory 20,
Form creation unit 21, file-by-file record structure memory 23,
Source file group 24 is connected. Further, a work file 19 is connected to the sort processing section 18, and a form output section 22 is connected to the form creation section 21.

The input definition document memory 15 stores input definition documents 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 determining section 16.

This sorting necessity determining unit 16 has a register i therein, and determines whether or not sorting is necessary by referring to the definition contents of the input definition document memory 15 during file processing, and if sorting is necessary, the definition number memory 17 is stored. As shown in FIG. 4, the definition number and sort direction (ascending/descending) are set.

The output definition document memory 20 stores the output definition documents shown in FIG. 3, and each output definition document is set with a word name to be output and an output X coordinate indicating the output position. The setting contents of this output definition document memory 2o are referred to by the form creation section 21. That is, the form creation unit 21 refers to the settings in the output definition memory 20 when creating a form, 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 the file name, keyword, word No. 1, word name, etc. are set as the data. Ru. For example, for file name A, "product code", "quantity", and "amount" are set as word names, and "product code" is set as a keyword. In addition, for file name B, "person in charge code", "product code", "sales amount", and "quantity" are set as word names, and "person in charge" code and "product code" are set as keywords. It is set. The source file group 24 is
Records sorted, for example, in ascending order based on the keyword K are stored.

FIG. 6 shows a variable length record format in each file of the source file group 24, and is capable of storing a plurality of "key data" and "word data" respectively. In this case, a record delimiter "(" is inserted at the beginning of each record, and a delimiter ";" is inserted between "key data" and "word data".

Next, the operation of the above embodiment will be explained according to the flowcharts of FIGS. 7 and 8.

By inputting instructions for creating a form from the input section 13,
The processing shown in the flowchart of FIG. 7 is executed under the control of the CPU 11. First, the CPU 1 displays the input definition document setting screen shown in FIG. 2 on the display unit 14, and guides data input regarding the source file name and definition key (step At). In this input screen, the user defines source file names and keywords. For example, if we were to create the sales ranking table shown in Figure 9(C) for source file B, we would specify rBJ as the source file name and set the keyword ``sales amount (D )” and “Person in charge code (U
)". Note that (D) above indicates that the sorting is in descending order, and (U) indicates that the sorting 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, and the data input regarding the word name and output
Step A2). In this input screen, the user sets the word name and output X coordinate. This output X coordinate is
This is used to specify the position of the print start digit of the output data, and is set by, for example, referring to the X coordinate guide displayed on the screen.

FIG. 3 shows an example of settings for creating a sales ranking table consisting of "sales amount,""person in charge code," and "product code." This output definition document is stored and set in the output definition document memory 20.

When the setting of the above output definition document is completed, the sorting necessity determining unit 16 automatically determines whether sorting is necessary by determining the type of keyword set and the type of keyword currently in the file, and if sorting is necessary. If so, turn on the sort flag, and if sorting is not necessary, turn the sort flag off.
F (step A3). The details of the process for determining whether or not sorting is necessary will be described later.

After that, check the ON/OFF status of the sort flag to determine whether sorting is necessary or not (step A5).
, if sorting is necessary, execute the sorting process (step A6), and output the form (step A7). If it is determined in step A5 that there is no need for sawing, the process immediately proceeds to step A7 to output a form.

Next, details of the sorting determination process by the sorting necessity determining section 16 in step A3 will be explained with reference to FIG. The sorting necessity determining unit 16 first sets the sorting flag to 0FFL.
(Step B1), and sets "0" to internal register i (Step B2). Next, input definition memory 15
Then, read out the first word of the definition key, in the example of FIG.
Then, the ascending/descending order for this word number is set in the definition number memory 17 (step B5). In the example shown in FIG. 5, the word number of "sales amount" in file B is "3", and since this "sales amount" is specified in descending order in the input definition memory 15, the word number "sales amount" is "3". 3'' is set in the definition number memory 17 to the effect that it is in descending order.

Thereafter, the sorting necessity determining unit 16 determines whether the contents of register i are r+IJL (step B8), the value of i is equal to or greater than the number of definition keys, and if it is, the process proceeds to step B8.
If not, proceed to step B9. At this point, the value of l is "1" and the number of definition keys of file B is "2", so the judgment result in step B7 is No, and step B
Proceeding to step 8, the next word "person in charge code" of the definition key in the input definition document shown in FIG. 2 is read out.

After that, return to step B4, read out the word number "1" corresponding to the "person in charge code" in file B from the file code structure memory 23, and define ascending/descending order, in this case, ascending order for this word number. Number memory 1
7 (step B5). Then, the content of register i is incremented by "+1" to "2" (step B6), and it is determined whether the value of i is greater than or equal to the number of definition keys (step B7).
).

Since the number of definition keys in the input definition document memory 15 is "2", the judgment result in step B7 is YES, and step B
Proceed to step 9.

In this step B9, it is determined whether the number of keys of the record is greater than or equal to the number of defined keys. Since the number of record keys and the number of definition keys of file B are both "2", the determination result in step B9 is YES, and the process proceeds to step BIO, where "1" is set in register l. Then, the first number "3" is read from the definition number memory 17 (Step B11), and it is checked whether this read number "3" matches the contents of register i (Step B12).
.

That is, it is checked whether the order of definition keys matches the order of record keys. In this case, the content of register i is "1", so the determination result in step B12 is N
In other words, it is determined that the order of the definition keys and the order of the record keys do not match, and the process proceeds to step B17 to turn on the sort flag.

If the determination result in step B12 is YES, that is, the initial order of the definition key and record key match, the process proceeds to step B13, where it is further determined whether or not the numbers set in the definition number memory 17 are in ascending order. do. As a result of this judgment, if the order is not in ascending order, the process proceeds to step B17, and if it is in ascending order, the process proceeds to step B14 and the contents of register i are changed to "+".
1'' and determines whether the value of register i has become greater than the number of defined keys. If the value of register i is greater than the number of definition keys, the order of definition keys matches the order of record keys, and both are in ascending order, that is, file data whose definition contents are stored in the source file. Since this is a case where the sorting conditions match, it is determined that sorting is not necessary, and the determination processing is ended with the sorting flag turned OFF.

Further, if it is determined in step B15 that the value of register i is not greater than the number of definition keys, the next number is read from the input definition document memory 15, and step B12
Return to Thereafter, the same process is repeated, and if the definition content and the file data sorting conditions match, the sort flag is kept in the OFF state, and if they do not match, the sort flag is turned ON and the process ends.

In addition, if it is determined in step B9 that the number of record keys is less than the number of defined keys, step 8
The process advances to 1g and processes up to step B24 are performed. In steps B1g to B24, steps BIO to B
Almost the same processing as 1B is performed.

That is, while step B15 judges whether the value of register i is greater than the number of definition keys, step B15 judges whether the value of register i is greater than the number of definition keys.
23, the only difference is that it is determined whether the value of register i is greater than the number of record keys, and the other processing is exactly the same.

In the processing of steps 818 to B24 described above, it is checked whether the contents of the input definition document and the sorting conditions of the file data match, and if the contents of the definition and the sorting conditions of the file data match, the sorting is performed. Keep the flag OFF, and if there is a mismatch, turn the sort flag OFF.
Press N to end the process.

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

FIG. 9(a) shows the stored data of file B.
As shown in FIG. 5, this file is sorted by the first keyword, "person in charge code," and when the person in charge codes are the same, it is sorted by the second keyword, "product code."

Therefore, the sorting processing unit 18
When it is determined that sorting is necessary, that is,
When the sort flag is turned ON, the contents of file B are read from the source file group 24 to the work file 19, and the "sales amount" defined in the input definition sheet shown in FIG.
Sort by keyword, and if the sales amount is the same,
Sort by using "person in charge code" as the second keyword. FIG. 9(b) shows the result of this sorting.

When the above sorting process is completed, the form creation section 21 operates and performs the form output process shown in step A7 in FIG. That is, the form creation unit 21 generates "sales amount", "person in charge code",
Data is read from the work file 19 in the order of "product code" and output to the form output section 22 to be printed out.

FIG. 9(C) shows the output result of this form (sales ranking table). Further, if the sorting necessity determining unit 16 determines that there is no need for sorting, the form output process is immediately executed without performing the above sorting process.

As described above, it is determined whether or not sorting is necessary based on the definition contents set in the input definition document memory 15, and if sorting is necessary, the form is output after sorting. Further, if there is no need for sorting, that is, if the data stored in the specified file matches the definition contents of the input definition document memory 15, the form is immediately output.

[Effects of the Invention] As detailed above, according to the present invention, it is possible to automatically determine whether sorting is necessary or not by determining the type of keyword set and the type of keyword currently in the file. It is possible to efficiently output forms by eliminating the need for sorting processing, and even if the file structure is changed, the user can instruct the program that processes the file to change whether or not sorting is necessary, sort keys, etc. There is no need to do this, and the form can be output easily.

[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 settings for an input definition document, and FIG. 3 is a diagram showing an example of settings for an output definition document. Fourth
The figure shows the storage configuration of the definition number memory, and FIG. 5 shows an example of data storage in the file-by-file record structure memory.
Figure 6 is a diagram showing the variable length record format of the source file, Figure 7 is a flowchart showing the form creation process, Figure 8 is a flowchart showing details of the sorting determination process, and Figure 9 is sorting and form output for the specified file. It is a figure showing a specific example. 11...CPU, 12...Pass line, 13...
Input section, 14... Display section, 15... Input definition document memory, 16... Sorting necessity determining section, 17... Definition number memory, 18... Sorting processing section, 19... Work File, 20... Output definition memory, 21... Form output section, 23... Record structure memory for each file,
24... Source file group.

Claims (1)

[Claims] Storage means for storing records sorted in the order of predetermined keywords; keyword setting means for setting arbitrary keywords; a discriminating means for discriminating whether or not the types of keywords set match; a sorting means for sorting the records in keyword order based on the set keywords when the discriminating means determines that they do not match; 1. A file processing device comprising: output means for outputting records sorted by a sorting means in order of set keywords.