JPS63206866A - Table data processor provided with classification key - Google Patents

Abstract

PURPOSE:To retrieve form data of a specific group unit and process a specific form in accordance with the instruction of an end user by giving classification keys to pages of tables and processing a corresponding table as one group in accordance with a classification key field and the designation of processing contents. CONSTITUTION:When the end user sees the display form on a display device 3 to input a command from a keyboard 4 with a stylus pen, classification key information corresponding to the classification key field of a transaction destination or the like is taken out from a page key field attribute table 220 in a RAM 2 and is set to a classification key field attribute table 22. A CPU 1 refers to the table 22 in accordance with the instruction of table data processing from the keyboard 4 to collectively sort field data of pages of a table, where classification key data given to page data 21 corresponds to designated key data, based on a sort program 24 and processes these sorted data as designated. Thus, form data of a specific group unit is retrieved and a specific form processing is performed in accordance with the indication of the end user.

Description

[Detailed Description of the Invention] [Summary] In an office processing device (table data processing device) configured to allow an end user to easily perform computer processing of page-by-page form processing, tables can be processed in specific group units. In order to do this, a classification key is assigned to each table page, and by the end user specifying the classification key field and processing details, multiple tables corresponding to the contents of the specified classification key field can be grouped into one group. It is processed as follows.

[Industrial application field]

The present invention relates to a table-based table data processing device for end users, and particularly to a table data processing method using classification keys.

With the recent advances in hardware and software technology of computer systems, for example, the format of a form itself is displayed on the screen of a display device, and a specific processing type is instructed for a specific data part of the displayed form. As a result, a product that can perform the specified specific processing, such as sorting processing, is in the stage of being put into practical use as integrated software for office processing, but the group of documents can be processed by a specific group called "client". The current situation is that it is not possible to process it.

However, since end users generally have little knowledge about computers, they are free to specify arbitrary processing, such as the above-mentioned group-based processing, as if they were performing normal manual data processing on the form. What you can do is required.

[Prior art and problems to be solved by the invention] FIG. 4 is a diagram illustrating a conventional form processing system.

In conventional form processing, as shown in this figure, a table field data attribute table 23 is provided corresponding to table field data 21b of page data 21.
The end user uses the keyboard 4 to select the display 3.
The specific data displayed above (e.g. date) and the type of processing performed on that data (e.g. sorting)
By specifying the processing range (for example, a page), the central processing unit (CPU) 1 executes the sorting program 24 to perform sorting processing on the specified data.

Therefore, in the conventional method, from the end user's point of view, even if there are multiple pages of tables in one file,
It was only possible to give processing instructions such as sorting tables on a page-by-page basis, or to process all pages at once.

Furthermore, as described above, since the processing is performed on a page-by-page basis or on an all-page basis, the end user cannot instruct processing such as adding a line to an intermediate page, for example.

In other words, in conventional form processing, from the end user's perspective, there was no way to process form data in terms of groups. There was a problem that there was no way to instruct the user to sort the data.

SUMMARY OF THE INVENTION In view of the above-mentioned conventional drawbacks, it is an object of the present invention to provide a method that allows searching for form data in specific groups and performing specific form processing based on instructions from an end user.

[Means for solving problems]

FIG. 1 is a diagram showing an example of the configuration of a tabular data processing device equipped with a classification key according to the present invention.

In the present invention, there is provided a tabular data processing device for processing tabular data of a plurality of pages included in one file 21 on a page-by-page basis, comprising means 3.4 for specifying a classification key field of the table; Means for storing the classification key field attribute information of the table in the classification key field attribute table 22, and means 4 for specifying the type of processing for the key data of the designated classification key field are provided.
24. The specified type of processing is performed on the multiple pages of table data included in 24.1 for each page and for each key data unit of the classification key field specified above. or 25.

[Effect]

That is, according to the present invention, tables can be processed in specific group units in an office processing device (table data processing device) configured to allow an end user to easily perform computer processing of page-by-page form processing. Therefore, by assigning a classification key to each table page and allowing the end user to specify the classification key field and processing contents, multiple tables corresponding to the contents of the specified classification key field can be processed as a group. Because the end user only has to specify a specific classification key field for a form consisting of multiple pages, it can be used for each table belonging to the same group.
For example, it has the advantage of being able to perform sort processing or overflow processing when adding nine rows.

〔Example〕

Embodiments of the present invention will be described in detail below with reference to the drawings.

The above-mentioned FIG. 1 is a diagram showing a configuration example of a tabular data processing device equipped with a classification key of the present invention, FIG. 2 is a diagram schematically showing an embodiment of the present invention, and FIG. The figure is a flowchart of form processing in the tabular data processing device of the present invention, and the page key field attribute table 22 note 9 in Figures 1 and 2 is necessary for implementing the present invention. It is a method. Note that the same reference numerals indicate the same objects throughout the figures.

Hereinafter, a form processing method by a tabular data processing apparatus equipped with a classification key according to the present invention will be explained with reference to FIGS. 1 to 3.

First, FIG. 1 shows an example of the configuration of a tabular data processing device equipped with a classification key according to the present invention, in which page data 21 provided on a memory (RAM) 2 stores tabular data of each page. Each page includes key data 21a as shown in FIG. 2(b).

and table field data 21b are stored.

In the page key field attribute table 220, addresses corresponding to key data of a plurality of classification key fields in the key data 21a and data lengths of the key data are stored, and when an end user is connected to the keyboard 4, Use a stylus pen or the like (not shown) to scan the form displayed on the screen of the display 3 (see Figure 2 (a).
)) By specifying the key data of a specific classification key field above, the address and data length of the key data of the specified classification key field are determined from the page key field attribute table 220 as the classification key field attribute. It is stored on the memory 2 as a table 22.

In the table field attribute table 23, as shown in FIG.
As shown in , the address and data length of the item data of each table row are stored.

A central processing unit (CPU) 1 executes, for example, a sort program 24 or a line addition program 2 based on an instruction of the type of form processing from an end user using a keyboard 4.
5 etc. and performs form processing.

Next, with reference to FIG. 2, the form processing of the present invention will be explained using an example of processing an accounts receivable ledger.

First, an end user looks at the form (a) displayed on the display 3 and uses a stylus pen (not shown) and inputting commands from the keyboard 4, etc.
"Business partner" (in this example, 1) is used as the classification key field.
), the first
From the page key field attribute table 220 shown in the figure,
The classification key information (key data address, data length) is extracted and set in the classification key field attribute table 22.

In addition, the page data is sorted in the order of the contents of the classification key field.
It needs to be sorted in advance.

Subsequently, the end user instructs processing of the table data using a specific function key (not shown) on the keyboard 4 (for example, a sort processing key).

As a result, the central processing unit (CPU) 1 executes the sorting program 24 on the memory 2, refers to the classification key field attribute table 22, recognizes the key data specified by the end user, and Diagram (a)
The processes shown in (steps 50 to 56) are performed.

In this case, in the present invention, "
Since "Is the key data the same?" is checked, it becomes possible to perform sorting processing by grouping tables having key data of the same classification key field.

In this example, "Dainippon Kogyo" (2 pages),
and [Fuji Sangyo J (1 page) Closed row sorting is performed only in the table.

Next, when adding data for "Dainippon Kogyo" as a new transaction has occurred, if the table is full up to the last line on page 2 of "Dainippon Kogyo", the conventional method cannot add data, but
In the present invention, as a result of executing the row addition program 25 (steps 60 to 63) shown in FIG. 3(b), in step 60, the key field attribute table 22 is similarly referred to, Since the "search for the last page of the same key" process is performed, that is, the closed process is performed based on the specific key data (for example, "Dainippon Kogyo") of the classification key "Transaction". 2, a page with the same key data can be inserted to generate a table on the third page, and additional data can be entered at the beginning of the table.

In this way, the present invention associates a classification key with a table created for each page in a table data processing device,
By instructing the classification key field and the type of processing for the form, the end user can group together tables that have key data of the same classification key field. It is unique in that it is performed in a closed room.

〔Effect of the invention〕

As described above in detail, the tabular data processing device equipped with the classification key of the present invention is an office processing device (table data processing device ), in order to be able to process tables in specific group units, a classification key is assigned to each page of the table, and the end user can use the classification key field.

By specifying the processing content, multiple tables corresponding to the specified classification key field contents are processed as a group, so forms with the same classification key data are treated as one group. This has the advantage that, for example, sorting processing or overflow processing when adding one line can be automatically performed on a group-by-group basis.

[Brief explanation of the drawing]

FIG. 1 is a diagram showing an example of the configuration of a tabular data processing device equipped with a classification key according to the present invention. FIG. 2 is a diagram schematically showing an embodiment of the present invention. FIG. 3 is a flowchart of form processing in the tabular data processing apparatus of the present invention. FIG. 4 is a diagram explaining a conventional form processing method. It is. In the drawing, 1 is the central processing unit (CPU), 2 is the memory (RAM)
. 21 is page data, and 21a is key data. 21b is table field data. 22 is a classification key field attribute table. 220 is a page key field attribute table. 23 is a table field attribute table. 24 is a sorting program, and 25 is a line addition program. 3 is the display, 4 is the keyboard. 50~, 60~ are processing steps. are shown respectively. (Ku) Miscellaneous 36 I/11 <b) Moxibustion flash 3 of the unexploded sun and moon surface M present 1 device 7"

Claims (1)

[Claims] A tabular data processing device for processing tabular data of multiple pages included in one file (21) page by page, comprising means (3, 4) for specifying a classification key field of the table.
and means for storing the classification key field attribute information of the specified table in a classification key field attribute table (22); and means (4) for specifying the type of processing for the key data of the specified classification key field. For the table data of multiple pages included in the above file (21),
A tabular data processing device equipped with a classification key, characterized in that the specified type of processing (24 or 25) is performed for each page and for each key data unit of the specified classification key field.