JPH06161841A - Record converting device - Google Patents

Abstract

PURPOSE:To attain longitudinal/lateral conversion of file data only with simple designation. CONSTITUTION:Record selecting conditions showing which record is extracted from the data of an objective file designated by an input part 12 are stored in a record selecting condition memory 18, and the designation of output editing such as which items are outputted in which order, whether a comma is added at the time of outputting or not and what title is added or the like is stored in an output item memory 20. When there is any unprocessed item in the output item memory 20, all the records corresponding to the record selecting conditions stored in the record selecting condition memory 18 are read from the file data in an external storage device 16, and one output record is prepared, written out to a work memory 22 and preserved. Next, one item No. to be a record key is counted up and the next output item is processed later.

Description

Detailed Description of the Invention

[0001]

BACKGROUND OF THE INVENTION 1. Field of the Invention The present invention relates to a record conversion device for vertically and horizontally converting a record of file data in an information processing device for output.

[0002]

2. Description of the Related Art Conventionally, an information processing apparatus for creating forms and building a database has been known.

Such an information processing apparatus reads the file data record by record from an external storage device such as a disk, processes the necessary items, and then outputs or prints out the basic pattern of the processing. Has become.

Therefore, if the file data as shown in FIG. 2A is stored in the external storage device, it is generally output in the same format.

[0005]

However, FIG. 2A shows the problem to be solved by the invention.
It was not possible to output the file data as shown in FIG. 4 in a format as shown in FIG. 4, that is, in a format in which limited model names are arranged side by side and item names are output as row data over one page or a plurality of pages. .

Alternatively, even if output is possible, it is necessary to create a complicated program exclusively for the form to be output.

That is, it is reasonable that the format of the file data is one record for one model as shown in FIG. 2A, but the output format is the format shown in FIG. There are cases where it is good, and there are cases where it is desired to output in the format of FIG. However, at present, since the format of FIG. 4 is difficult to realize, in reality, there are few information processing apparatuses having such an output function.

An object of the present invention is to enable general file data to be output in a format in which the vertical and horizontal sides are converted by a simple designation without a complicated program dedicated to the form to be output.

[0009]

The means of the present invention are as follows. The record storage means stores a plurality of records including a plurality of items. The record creating means extracts, for each item of the plurality of items, the data of the item from each record stored in the record storing means, and creates a new record including only the data of the corresponding item.

[0010]

The operation of the means of the present invention is as follows. The record creating means extracts, for each item of the plurality of items, the data of the item from the plurality of records of the plurality of items stored in the record storage means, and outputs a new output including only the data of the corresponding item. Create a record for.

[0011]

DETAILED DESCRIPTION OF THE PREFERRED EMBODIMENTS An embodiment of the present invention will be described below with reference to FIGS.

FIG. 1 is a diagram showing the configuration thereof, and reference numeral 10 in the figure is a CPU for controlling the whole. 12 is an input unit for instructing record selection conditions and output items,
Reference numeral 14 is a program memory that stores a control program. Reference numeral 16 is an external storage unit that stores file data, and 18 is a record selection condition memory that stores record selection conditions. Reference numeral 20 is an output item memory for storing the output items and output editing instructions from the input unit 12, and 22 is the program memory 14 for the CPU 10.
It is a work memory used during operation according to the control program of. Reference numerals 24 and 26 are a display unit and a printer as output units, respectively.

It is assumed that the external storage unit 16 stores, for example, file data in which one model has one record, as shown in FIG.

Next, the operation in the above configuration will be described.
This will be described with reference to the flowchart of FIG.

First, the input section 12 specifies a record selection condition as to which record is to be extracted from the data of a symmetrical file, and stores the content in the record selection condition memory 18 (step S1).

Further, the input section 12 designates output editing such as which items are output in what order, whether a comma is added at the time of output and what the title name is, and the contents are stored in the output item memory 20. (Step S2).

That is, step S1 and step S2 described above.
Is the condition setting for execution, and the following step S
After 3, the file data is processed.

That is, first, in order to determine the end of processing, it is determined whether or not all the designated output items stored in the output item memory 20 have been processed (step S).
3). If there are still unprocessed items, step S4
Otherwise, the process branches to step S7.

If there are any unprocessed items, then, as shown in FIG.
From the file data of the external storage device 16 as shown in FIG. 2, all the records matching the record selection condition stored in the record selection condition memory 18 are read, and the output record as shown in FIG. Create one case (step S4). That is, for example, if the unprocessed item is “cost” and the records of the models A to D are selected, the cost data is read from the records of the models A to D, and the data of FIG. Item No. Create record 1. Then, the output record created in step S4 is written and saved in the work memory 22 for later use (step S5). Next, the item number that becomes the record key. Is incremented by 1 (step S6), the process returns to step S3 to process the next output item.

When all the designated output items have been processed as described above, it is next judged whether or not there are any output records to be processed stored in the work memory 22 (step S7). To do.

However, if there is an output record, it is necessary to read one output record from the work memory 22 (step S8) and print out as shown in FIG.
Output editing such as adding a title or commas is performed (step S9). After the printer 26 prints out (step S10), the process returns to step S7.

As described above, the data of the item is extracted for each item of the plurality of items from the plurality of records of the plurality of items stored in the external storage unit 16, and only the data of the corresponding item is extracted. Since a new output record consisting of is created, it is possible to output general file data in a format in which the vertical and horizontal formats are converted by a simple specification without the complicated program dedicated to the form to be output. Become.

Although the above embodiment has described the case where the printer 26 prints out, the same applies to the case where the display output is performed on the display unit 24.

[0024]

According to the present invention, general file data can be output in a vertically and horizontally converted format by a simple designation without a complicated program dedicated to the form to be output.

That is, according to the present invention, since general file data can be output in the form of vertical / horizontal conversion by simply specifying,
It is effective for outputting a form that compares many items in a specific record group. Especially, since the file is not limited, it can be widely used.

[Brief description of drawings]

FIG. 1 is a block configuration diagram of a record conversion apparatus according to an embodiment of the present invention.

FIG. 2A is a diagram showing an example of file data,
FIG. 9B is a diagram showing an example of an output record after vertical / horizontal conversion.

FIG. 3 is a flowchart for explaining the operation of the embodiment.

FIG. 4 is a diagram illustrating an example of print output.

[Explanation of symbols]

10 ... CPU, 12 ... Input section, 14 ... Program memory, 16 ... External storage section, 18 ... Record selection condition memory, 20 ... Output item memory, 22 ... Work memory, 24
... Display unit, 26 ... Printer.

Claims (1)

[Claims] 1. A record storage unit for storing a plurality of records including a plurality of items, and data for each item of the plurality of items extracted from each record stored in the record storage unit, And a record creating means for creating a new record consisting only of the data of the item to be recorded.