JPH02288956A - System for re-arranging data in table format data - Google Patents

Abstract

PURPOSE:To easily perform the re-arranging processing of data with an interactive format by re-arranging numerical or character data of table format in the column or row of table format data in which plural binder groups are preserved and stored in ascending or descending order. CONSTITUTION:A command control part 3 retrieves and controls a command corresponding to menu data selected from a menu part 4 from a command group 5 based on an analysis instruction by an input data analysis part 2, and executes and processes the function of the command, and also, displays menu display selected at the menu part 4 on a display part 7 via a menu table control part 6. And the table format data generated with the interactive format is preserved in page unit, and also, the bundle of data of plural pages in page unit is preserved as a binder, and furthermore, the numerical or character data of table format in the column or row of the table format data in which the plural binder groups are preserved and stored are re-arranged in the ascending or descending order. Thereby, the re-arrangement of the data can be easily performed.

Description

DETAILED DESCRIPTION OF THE INVENTION (Industrial Field of Application) The present invention relates to data processing through interaction between a computer and a human, and particularly relates to rearrangement processing of tabular data in successive page openings arbitrarily created through interaction with a computer.

(Prior art and problems) Tables can be created interactively without having to acquire specialized computer programming skills by simply inputting commands and other marks etc. in an interactive manner according to the messages displayed on the screen. , simple languages that can perform processing such as editing table data and calculating table data are becoming popular. With the spread of such simple languages, the number of people using computers, especially personal computers, has also increased, and the current situation is that these languages are being used in a variety of fields. For example, business schedule management, patent business management, sales performance management, inventory management,
Aggregation and reports, such as the management of scorecards, are now processed and submitted by computers.

It is difficult to sort and process table-format data such as office supplies (7-sheets, binders, cabinets, etc.) that are stored and processed in a hierarchical manner, and requires advanced computer knowledge. However, there was a problem in that it was difficult to easily process it in an interactive format.

(Summary of the Invention) The present invention solves these two conventional problems, and allows tabular data created in an arbitrary format to be stored in cabinets, binders, and office supplies such as pages. The purpose is to provide a method for simple sorting processing, and the data processing method allows for the creation and editing of tables in any format in an interactive manner based on instructions displayed on a computer display screen, using a keyboard or mouse. an input means for processing commands input from the input means and menu selections displayed on the screen in place of the commands manually, and an input analysis means for analyzing data to be stored in the storage device, and a display. a menu group that stores menu data to be displayed in the section;
means for controlling menu data from the direct menu group by command analysis processing by the input data unit 411; and means for displaying menu data stored in the menu group controlled by the control means. Equipped with
A string of tabular data that saves the created tabular data in page units, and also saves a bundle of multiple vane data in vane units as a binder, and further saves and stores multiple binder groups. It is characterized by being able to arrange numerical or character data in a tabular format of rows in ascending or descending order.

(Margins below) (Example) Figure 1 is a diagram showing the configuration of the present invention, Figure 2 is a diagram showing the configuration of a display screen according to the present invention, and Figure 3 is an implementation of the screen according to the present invention. It is a figure which shows an example.

In the figure, 1 is an input section, 2 is a human data analysis section, 3 is a command control section, 4 is a part of a menu, 5 is a group of commands, 6 is a menu screen control section, 7 is a display section, 8 is a printer, and 9 is an external device A storage device, 10 a data transfer unit, 11 a part of a menu bar,
12 is a scale part, 13 is a window number part, 14 is a line number part,
Reference numeral 15 indicates a menseno batting section, 16 indicates a manual striking section, 17 indicates a tabular data display section, 18 indicates a pull-down menu, and 19 indicates a help menu window.

The input unit 1 is an input device such as a mouse or a keyboard.The human power data analysis unit 2 inputs data from the human power unit 1 and executes it using arrow keys or input from a mouse. Analyze whether the input is a command name, etc. If the input is via the window menu 1 displayed on the screen instead of the input of the name of the corner from the human power section 1, the command controller 3 instructs the selection operation of menu data in the menu section 4. Instructs to call the commands of command group 5 through the command line. By operating the input unit 1, move the cursor in the pull-down menu to select a command or highlight the function of the selected item, and if it is an execution command, search for a command from the command group 5 via the command control unit 3. be done.

The command control unit 3 searches the command group 5 for a command corresponding to the menu data selected from the menu part 4 based on the analysis instruction by the input data analysis unit 2, and executes the command effl 118. At the same time, it controls the operation up to displaying the menu selected in the menu section 4 via the menu table control section 6 on the display section 7-\. .

Menu part 4 includes menu bar, pull-down menu,
This is a memory that stores items I-1 to be displayed on the display screen 4, such as error menu, calculator menu, title menu, etc.

Command group 5 is a memory that stores commands that control execution, and is divided into 1-common command group, input command group, row editing command group, column editing command group, and table editing command group based on the function of the command. "Calculation aggregation command group""Search classification command group""Display command group""Management command group""Setting command group""Transfer communication command group"
Classified into "Print graph command group", "Data conversion command group", etc. (Please refer to the attached table for the contents of the command group)
.

The menu screen control section 6 controls data for executing the commands of the command group 5 selected by the command control section 3 and displaying the menu data of the menu part 4 as one menu screen on the display section 7.

Based on the search control command, control the table data corresponding to the command with the search control command from the table group 5;
Display the table data on the display screen 4.

The display unit 7 is a display device such as a liquid crystal, plasma, or other CRT, and is capable of split-screen display. scale? (s 12
, window number part 13, line number part 14, mensaeng line 1'fl
(15. When the input line section 16 and the tabular data display section 17 are displayed, the menu window 18 and the help menu window 19 are also displayed. Furthermore, the menu section 4 is stored. Menu data such as error menu, calculator menu, title menu, etc. is displayed.

The printer 8 is a printer that prints the execution processing result of the command selected by the command control unit 3.

The storage unit 9 is an external storage device that stores tabular data whose processing is controlled by executing commands in a hierarchical manner like a vane, a vane, and a cabinet.

S I O (serial input/output 1) 10
is a processing unit for transferring tabular data to and from an external device through command execution processing.

The menu bar part 11 is a display area on the screen that categorizes the processing functions of the computer into top categories, and the cursor moves on the display screen by moving the arrow keys.
The menu item where the cursor is located will be highlighted. When you specify a highlighted item on the menu bar and press the execution key, the Purgran menu with the contents corresponding to the highlighted item is displayed on the screen, and at the same time, a help menu is also displayed.

The menu bars according to the present invention are classified into four types, and each menu bar is selected by using arrow keys and displayed on the screen.

The scale section 12 displays the title name, column number, and column number of the table to be displayed.
This is a display area on the screen that displays the number of column digits, 11 ring names, number of character digits, etc.

The window number section 13 is an area for identifying the screen displayed on the display screen. Save the main screen to be displayed and the tabular data of the main screen in memory using R'pr: Forward 1-1.
, a sub screen may be displayed. In that case (,: This is an area that identifies whether the currently displayed screen is "main screen 1" or "sub screen-1." Also, since the display screen according to the present invention can be divided into four screens, , it becomes easy to identify whether the displayed data is the main screen or the sub screen.

Normally, the tabular data on the sub screen cannot be seen, or it can be seen by dividing the display screen using the split screen function. Assign a number to each divided screen. This number is called the window number. You can work while displaying tabular data on different parts of the main screen or sub-screens at the same time.

In this case, commands can only process data according to the table displayed on the main screen.

For this reason, the main screen is also called a work screen. The identification notation for the main screen and sub screen is [Window number surrounded by 1 means main screen, window number surrounded by () means sub screen. Furthermore, if the identification notation cannot be used to distinguish between the two screens, both screens are displayed with different identification notations and different frame designs.

The line number section 14 is an area on the screen J- that displays the line number of the table of tabular data, and is an area that identifies which line the tabular data called up in the screen 1nj is.

The message input section 15 is an area on the screen that displays commands or commands from the input section 1 in an interactive format, command selection in the pull-down menu, and operation instructions for processing the selected items, such as ``Please enter a command.'' (also called prompt area). Message batting section 1
5 prompts for selection items or operation instructions when executing a command, and data processing can be executed in an interactive manner by inputting commands from the keyboard in response to the instructions.

The input line section 16 is an area on the screen that temporarily displays contents input from the keyboard according to instructions from the Messeno typing section 15. When the operator confirms the contents displayed in the input line section 16 and presses the execution key, the contents are sent to the desired tabular data (also referred to as a "cell") and displayed. In response to instructions from the message typing section 15, commands, characters, numbers, etc. are input from the keyboard. When you finish entering characters and press the execution key, the entered contents will be entered. The present invention has an input row section 16 and a pull-down menu window 1.
Since the process can be executed in combination with the selection of the commands listed in 8, commands etc. can be input directly to the input line section 16 to execute the execution process.

The tabular data display section 17 defines M rows and N columns as one page, and displays the page on the screen page by page. If the data consists of multiple pages, it is possible to organize and save the data in a binder, and expand the data processing unit to the binder. Data processing using commands can process multiple pages. That is, when performing editing and processing such as adding or deleting data items in a tabular format, the data items can be increased or deleted across multiple pages by executing one command.

On the display screen, as shown in FIG. 3, a pull-down menu window 18 and a help menu window 19 are displayed along with tabular data, and, although not shown, an error window, a calculator window, a cabinet window, and a binder title window are also displayed. displayed individually or in layers. When the message "Please input command" is displayed on the message input unit 15, a function on the menu bar can be selected. Functions on the menu bar are selected and executed by moving the highlighted display (reverse display) using the arrow keys and pressing the execution key.

Move the highlighted display to the desired function and press the execution key to display a pull-down menu. When selecting a function, press the execution key to execute the selection. If you type the left or right arrow key while a pull-down menu is displayed, the selected pull-down menu will be displayed. For example, in the case of "→J", the pull-down menu of the function menu bar on the right side will be displayed.

The pull-down menu window 18 is part of the menu bar 1
This is an area for displaying each function group corresponding to the top desired processing function displayed in 1. The pull-down menu window 18 classifies and displays functions for controlling the computer into a higher-level function group and a lower-level function group. Each function displayed in the pull-down menu window 18 is executed by moving the arrow keys to highlight the item, appropriately selecting the desired location, and pressing the execution key.

The help menu window 19 is an area for explaining each function of the upper and lower function groups displayed on the menu bar section 11 and the pull-down menu window 18. The operator can operate by referring to the help menu displayed on the display screen without referring to the manual.

There are four types of menus displayed on the menu bar part 11: Menu (1), Menu (2), Menu (3),
Consists of menu (4). Menu (1) is [Common],
Menu (2) consists of [Input], [Row Edit], [Column Edit 1], [Table Edit], [Calculation Summary 1, r Search Classification], [
Menu (3) consists of [Management 1, [Settings]
, [Transfer Communication], [Consists of print graph 1, menu (
4) is for each m of [data exchange] and [option].
It is classified as Noh. A pull-down menu is displayed for each function divided into each menu bar. In other words, each function of the menu bar (1) [Regular use 11 manual 41 line editing 1
A pull-down menu is displayed individually in 1-column edit 1 (see "Appendix"). Furthermore, a lower pull-down menu window 18 is displayed and the menu bar (1) (
2) A pull-down menu listing 11 selection orders is displayed for each of the functions (3) and (4). The tabular data on the computer is processed by interactively selecting the selection items displayed in this pull-down menu window 18.

A help menu window 19 is displayed that provides explanations and operations for each of the functions listed in the menu bar section 11 and pull-down menu window 18. If you are unable to understand the operations when processing the computer interactively, explanations or operation guides for functions corresponding to the highlighted display position of the menu or command execution status are displayed in the help menu window 19. Reproduction becomes easier.

Next, an embodiment of the tabular data sorting process according to the present invention will be described.

■Use the arrow keys to move the inverted display of the menu bar - related to the present invention to "Common Use" and press the execution key.

■ [Confirm that the pull-down menu related to the invention of Common Use 1 is displayed. [Common use-1 pull-down menu includes [Call Vane 11-Keep Vane 11] [Print 1 [List of various titles 1F table calculation old-Cross tabulation]
``Simple graph, 1 [Business graph 1 [Sort old - Condition search] ``Exit'' ``Manage media exchange fee binder'' You can choose.

■Use the arrow keys to move the highlighted display of the pull-down menu according to the present invention to "5ORT Sort" and press the execution key.

■The message line related to the present invention on the screen displays "What is the processing range (target of stop change)?" (Ml Pebe, Binder) 1 is displayed.

■Press the execution key. What is the 11th key column (sort key column) in the message line on the screen? (Maximum of 10 columns) ① Manually enter the column names of the tabular data according to the present invention from the keyboard. To rearrange one column 1-1, manually press the [1=15 0] execution key.

(2) A pull-down menu according to the present invention of "Comparison Condition" is displayed on the screen, and a comparison condition is selected using the arrow keys. The pull-down menu of the comparison conditions is "Ascending order" [Descending old - Numerical non-numeric order 1 "Numerical descending order""I" Ascending order] 1 Date descending order, which is also displayed in the message line. A condition selection command may be input from the keyboard into the input line according to the present invention.

■Use the arrow keys to move the highlighted display in the pull-down menu to ``Descending numerical order'' and press the execution key. Then, what are the 1st and 2nd key columns (sort key columns) in the message row on the screen?
is displayed, asking you to specify the next condition selection. If there is only one column of comparison conditions, press only the execution key without inputting anything from the keyboard.

■Display confirmation on the message line whether to save the sorted data as a new one. “What is the new saved light? (Bane,
Binder) Display as ``No save second execution key''.

This completes the sorting comparison condition, executes the sorting process, and displays the sorted result on the screen.

L16 (Effects of the Invention) Since the present invention has the above configuration, it has the effect of simplifying the data sorting process in tabular data in an interactive manner.

[Brief explanation of the drawing]

FIG. 1 is a block diagram showing the configuration of the present invention, FIG. 2 is a diagram showing the configuration of a display screen according to the present invention, and FIG. 3 is a diagram showing an embodiment of the display screen according to the present invention. 1... Input section 2... Input data analysis section 3...
Command control unit 4... Menu part 5... Command group 6... Menu screen control unit 7... Display unit 8... Printer 9... External storage device 10... Data transfer unit 11
...Menu bar part 12...Scale part 13.
...Window number section 14...Line number section 15...Message entry section 16...Input line section 17...Tabular data display section 18...Pull-down menu 19...Help menu window

Claims (1)

[Claims] A data processing method that allows for the creation and editing of tables in any format in an interactive manner based on instructions displayed on a computer display screen. an input analysis means for processing menu selections to be displayed on a screen in place of command input and for analyzing data to be stored in a storage device; a menu group for storing menu data to be displayed on a display; and the input data. The table created in the interactive format includes means for controlling menu data from the menu group by command analysis processing by the analysis means, and means for displaying menu data to be stored in the menu group controlled by the control means. Format data is stored page by page, a bundle of data of multiple pages in page units is stored as a binder, and numeric or character data in a tabular format in columns or rows of tabular data is stored and stored in multiple binder groups. A data sorting processing method for tabular data, characterized by sorting in ascending order or descending order.