JPH03250256A - Table creation device - 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 table creation in a table creation device.

[Conventional technology]

The search function in conventional table creation devices is to search for the same content using ['' (space) or "same".1. "
Lines that are omitted with "same content" are not identified as same content lines and are processed, making it impossible to process the same content line unit.

[Problem to be solved by the invention]

The above-mentioned conventional technology does not perform processing for each row of the same content, but in order to perform editing processing such as searching and sorting for each row of the same content,
Before executing the editing process, in order to make items with the same content, it is very time-consuming to input or copy the same data into the rows of the processing unit, or add a temporary column so that they can be regarded as rows with the same content. It took. In addition, after the editing process, data with the same content may be marked with "same as above" or "〃" to make the table easier to read.
In order to create item data such as, it was necessary to modify each item, which was time-consuming. Also, after the editing process, the arrangement of the line data changes and no longer matches the position of the line before the process.
It was very inconvenient to use, such as having to set up a new cable.

An object of the present invention is to eliminate the process of modifying data with the same content, to realize editing processes such as searching and sorting for each line of the same content with simple operations, and to omit the data with the same content after the editing process. The purpose is to be able to automatically reset lines.

[Means to solve the problem]

The above purpose is [” (space), “same as above”.

This problem can be solved by the system recognizing multiple lines including item data such as "rn", "r same value" (hereinafter referred to as same value continuous expression data) and item data set by the user as one processing unit. .

[Effect]

According to the present invention, item data such as "" (space), "same as above", or "〃" in the sense of the same content line is recognized as the same value continuous expression data, and processing is performed in units of the same content line. By doing this, it is possible to perform editing processes such as searching and sorting on a line-by-line basis with the same content, and it is also possible to omit the same content data or automatically reset the key line after the editing process. can be done.

〔Example〕

Hereinafter, an embodiment of the present invention will be described based on a search function using the drawings. FIG. 2 is a block diagram showing the configuration of a table creation device to which the present invention is applied.

11 Input section for inputting commands etc. Display section 21 for displaying table information such as characters 1 Storage section 39 for storing created table data etc. Printing section 4 for printing created table data etc.
．． It is composed of a control section 5 including a microprocessor or the like for controlling each of the above-mentioned sections.

Next, the table used in the search process will be explained using FIG. 7. The table used in the search process has a block table usage count of 20. Block management table 30. Block table 40. Search fee item data table 50.
It consists of a work table 60. Each table will be explained below.

- Block table usage number 20 This is a storage area that stores the usage number of the block table 40.

-Block management table 30 This table manages the arrangement of each block stored in the block table 40, and has a number 31 for each block.

・Block table 40 Search column number 41 for each same content line unit, start line number 42 for each same content line unit, end line number 43 for each same content line unit
, the number of constituent lines 44 for each same content line, the search fee item data length 45 for each same content line, and the search fee item data storage location 46 for each same content line.

-Search fee item data table 50 This is a table that stores search fee item data for each line of the same content, and has a storage area 51 that stores data and attributes for each character.

- Work table 60 When searching for row data in a table, it has a storage area 61 that temporarily holds row data.

The search process will be explained using FIG. First, the options shown in FIG. 3 are displayed on the screen, waiting for an input from the operator, and if there is an input, the search condition input 101 updates the contents of the search condition table 10 in FIG. will be explained later using FIG. 4) (step 101).

Then, a step is taken to determine whether the search unit 11 in FIG. 102), the determination result is YES (the search unit 1
1 is the same content row unit), the same content row unit is determined from the content of the item data of the search column, and the determined result is included in the search column item data of each same content row unit in the same content row unit table 40. Column number 41, starting line number 42 for each identical content line unit, ending line number 43 for each identical content line unit
, the number of constituent lines in each same content line unit 44, the search fee item data length in each same content line unit 45, the search side item data storage position in each same content line unit [46], and the search in the same content line unit. Search column item data in the column item data table 5
Store with the head stuffed to 0. In addition, the block number 3 of each same content line unit in the same content line unit management table 30
1 stores the block numbers 31 of each same content row unit in ascending order of numbers as an initial value (step 103
), and performs an internal search process for the same content line unit (the same content line unit search internal process 104 will be explained later using FIG. 8) (step 104), and if the result of the determination in step 102 is No. (If the search unit 11 is one line), then the search internal processing is performed line by line. The process examines the data and extracts row data that matches the search condition statement (step 105), and then proceeds to step 106. In step 106, it is determined whether to "do" or "not" resetting the cable line, and the result of the determination is YES (the key line resetting is
If so, the line resetting process (the line resetting process 107 will be explained later with reference to FIG. 9) is performed (step 107), and the process ends.

If the result of the determination is No (“do not” reset the line), the process ends.

The search condition input 101 will be explained using FIG. 4. First, in FIG. 3, the setting value of the search unit is stored in the search unit 11 of the search condition table 10 in FIG. 5 (step 201).

Branching step 202), 1 according to the search unit 11
If it is a row unit, the search condition statement set in FIG. 3 is stored in the search condition statement 22 in FIG. 5 (step 203). Whether or not to reconfigure the key line set in FIG. 3 is stored in the key line resetting presence/absence 23 in FIG. 5 (step 20
4). Upon execution input (step 205), the process ends. If the search unit 11 is specified in the same content line unit, the same content data (the same content data includes the same content data as the item data in the previous line such as "same as above") Set a plurality of (six in this example) left item same content data that has the same content as the item data in the left column such as "same left", and Data 1 to 3 (12 to 14) are stored in the same content data 1 to 3 (15 to 17) in the left item of FIG. 5 (step 206), and the setting values of the same content processing method in FIG.
Stored in the same content processing method 18 in the figure (step 207
), and if the same content processing method 18 is "omitted", a plurality of omitted data ([same as above]) in FIG. (item data that the user can arbitrarily set) such as omitted data 1 to 3 (19 to 2) in Figure 5.
1) (step 209), and step 2
Proceed to 03. If the same content processing method 18 is "do not omit" or "replace", the process directly advances to step 203, performs the processing from step 203, and ends.

Next, the same-content line-by-line determination process 103 for determining the same-content line unit from the contents of the item data of the search column will be explained using FIG.

First, the search start line number is stored as an initial value in the search line number (step 301). Compare the search line number and the search end line number (step 302), if the search line number is less than or equal to the search end line number.

The process advances to step 303, and if the search line number exceeds the search end line number, the process ends.

If the search line number is the first row of each same content line unit (step 303), and the result of the determination is YES (the search line number is the first line of each same content line unit), add 1 to the block table usage number 20. (step 304), stores the start line number and search column number of each same content line unit in the block table 40, and stores the storage position in the block management table 3.
0 (step 305). Set the number of constituent lines of each same content line to one line (step 306), store the item data of the search column in the search column item data table 50, set the search fee item data length 45 of the same content line unit, and set the search column item data The storage position 46 is stored in the block table 40 (step 307). Next, add 1 to the search line number (step 308), and return to step 302. Steps 6 and above are repeated until the search line number becomes larger than the search end line number.

On the other hand, if the result of the determination in step 303 is NO (the search line number is not the first line of each same content line unit), the search fee item data of the search line number is the search fee of the first line of the same content line unit. The content data is the same as the item data, or ['' (space).

"Same", rn", upper item that the user can set multiple items same - same value of content data Equal to any of the continuous expression data, or "same left", user can set multiple items same - same content data For continuous value expression data,
It is determined whether it is equal to the item data in the left column (step 309), and the result of the determination is YES (equal to either).
Then, add 1 to the number of constituent lines 44 of each identical content line unit (step 310), and end line number 43 of each identical content line unit.
The search line number is stored in (step 311).

The process then proceeds to step 308. If the result of the determination in step 309 is No (not equal to either), the process moves to step 304.

Next, the internal same content line unit search process 104 will be explained with reference to FIG.

First, the number of used block tables, 20, is stored as an initial value in the number of blocks (step 401).

Next, step 40 is performed to determine whether the number of blocks is 1 or more.
2) If the result of the determination is YES (the number of blocks is 1 or more), the process proceeds to step 403. If the determination result is No (the number of blocks is less than 1), block management table 3
0, the row data that does not satisfy the search condition statement 22 is deleted from the original table, the row data of the work table 60 is stored in the original table (step 409), and the process ends. In step 403, it is determined whether the search fee item data in units of identical content lines satisfies the search condition statement 22, and if the result of the determination is YES (the search condition statement is satisfied), step 4
If the result of the 1 determination is No (the search condition statement 22 is not satisfied), the block management table 30 stores the storage amount outside the search condition (FF in this embodiment) (Step 408), Step 407 Proceed to step 40
4, the same content processing method 18 determines whether to "omit" or "replace", and the result of the determination is YES (if the same content processing method 18 is "omitted" or "replace")
), the search fee item data other than the first line of the same content line unit is replaced with omitted data or the first line data of the same content line unit (step 405).

If the result of the determination in step 404 is No (the same content processing method 18 is ``not omitted j'', the process advances to step 406. In step 406, the row data for each line of the same content is stored in the work table 6o, and the number of blocks is 1 is subtracted from (step 407), and the process returns to step 402. The above process is repeated until the number of blocks becomes O.

Next, the K line resetting process 107 will be explained using FIG. 9.

First, erase all the lines on the original table (step 501).
). Then, the table frame key line of the table after processing is set (step 502). It is determined whether the search unit 11 is the same content line unit (step 503), and if the result of the determination is YES (the search unit 11 is the same content line unit), a horizontal scale is used to separate the same content line unit and the same content line unit. After setting the line (step 504), the process ends. If the determination result in step 503 is No (the search unit 11 is one line),
A horizontal line is set for each line (step 5o5), and the process ends.

Next, a case will be described in which the above processing is applied to an actual table.

For the table shown in FIG. 10, the user sets the search conditions shown in FIG. is “〃”, search condition statement 22 is [column 1 < S-0
03J, the K-line resetting 23 is set to "Yes") and the search process is performed.First, when the content line unit indexing process 202 is performed, as shown in FIG. ．． Block management table 30, block table 40, and select column item data table 5
0 stores information determined for each line of the same content 6
The information determined for each row of the same content in the first row in FIG. The number of constituent lines 44 of the same content line unit is 3 lines, and the search fee item data length 45
indicates that the search fee item data storage position 46 is the first.

Next, based on the block table 40 stored in the same content line unit indexing process 103, an internal search process 104 for the same content line unit is performed. In the same content line unit search internal process, it is first checked whether the search fee item data of the same content line unit satisfies the search condition statement 22, and if it does, the line data is stored in the work table 60. death,
If the search condition is not satisfied, the storage amount outside the search condition (FF in this embodiment) is stored in the block management table 30.

The above process is repeated for 20 minutes, the number of times the block table is used.

Then, based on the block management table 30, search condition statement 2
2 is deleted from the original table, and the row data of the work table 60 is returned to the original table.

Next, in a line resetting process 107, the table frame line of the searched table is reset, and a horizontal line for each line of the same content is set based on the stored block table 4o. 13 shows the state of the block management table 30 after the search, FIG. 14 shows the state when the row data that satisfies the search condition statement 22 is stored in the work table 60, and FIG. 15 shows the state of the block management table 30 after the search. The row data is deleted based on the results, and the row data in Figure 14 is returned to the original table. Figure 16 shows the table frame and the horizontal lines for each row of the same content. This is the state at that time.

As described above, according to this embodiment, it is possible to search for lines of the same content.

Also, in editing processing such as sorting and numbering, by utilizing the processing method for each line of the same content of this embodiment, sorting and numbering can be performed.

[Effects of the Invention] As described above, the table creation device of the present invention has the following advantages:
” (space), “Ditto J, r”J.

By recognizing item data such as "same as left" as continuous expression data of the same value and processing the same content line by line, it is possible to perform editing processes such as searching and sorting for the same content line by simple operation. After the editing process, data with the same content can be omitted, and the line can be automatically reset.

[Brief explanation of drawings]

FIG. 1 is a flow diagram for explaining the operation according to the present invention;
FIG. 2 is a block diagram showing the configuration of the table creation device, FIG. 3 is a diagram showing a screen for inputting search conditions, FIG. 4 is a flow diagram for explaining the operation according to the present invention, and FIG. 5 is a diagram showing the screen for inputting search conditions. FIG. 6 is a flowchart for explaining the operation according to the present invention; FIG. 7 is a diagram showing a table used in the search; FIGS. Flowcharts for explaining operations according to the invention, FIGS. 10 to 1
FIG. 6 is a diagram showing a diagram for implementing the present invention. 1... Input section, 2... Display section, 3... Storage section, 4
...Printing section, 5...Control section. Figure 1 Figure 2 Figure 3 The mark indicates that it has been specified. Fig. 4 Fig. 5 Search condition table 0 Fig. 6 Fig. 7 Fig. 8 Fig. 9 Fig. 10 Fig. 11 The mark indicates that it has been specified. 0 Figure 12 Figure 13 FF Data that does not satisfy the search condition statement Figure 14 Work table 60 Figure 15

Claims (1)

[Scope of Claims] 1. The character string input to any item in the table (hereinafter referred to as item data) and the item data in the next row of the item data are "" (space), "same as above", “″”, “same as left”
Item data indicating that the same value is consecutive (hereinafter referred to as
The first row where item data with the same value exists is the same value first row,
A line in which subsequent identical values are omitted is called an identical value omitted line. In addition, when the item data in those rows are called the same value first item data and the same value continuous expression data, respectively (however, when the same value continuous expression data is "same left", the item data in the left column is the same value (must be equal to the first item data), multiple lines containing the same value first line and the same value continuous expression data are regarded as one processing unit (hereinafter referred to as the same content line unit), and the same value in the same content line unit The present invention is characterized by comprising means for deeming data different from the first item data to be a separate processing unit when it appears, and means for searching and sorting (hereinafter referred to as sorting) the same content line by line. table creation device. 2. The table creation device according to claim 1, further comprising means for setting an expression format of the same value continuous expression data in addition to the same value continuous expression data, and means for changing the expression of the same value continuous expression data. Features table creation device. 3. The table creation device according to claim 1, further comprising a means for resetting the table frame after processing the same content row by row, and setting a horizontal key line for the same content row by row. table creation device.