CN106649364A - Positioning method and device for target column in table - Google Patents
Positioning method and device for target column in table Download PDFInfo
- Publication number
- CN106649364A CN106649364A CN201510729604.4A CN201510729604A CN106649364A CN 106649364 A CN106649364 A CN 106649364A CN 201510729604 A CN201510729604 A CN 201510729604A CN 106649364 A CN106649364 A CN 106649364A
- Authority
- CN
- China
- Prior art keywords
- content
- character
- preset symbol
- preset
- column
- Prior art date
- Legal status (The legal status is an assumption and is not a legal conclusion. Google has not performed a legal analysis and makes no representation as to the accuracy of the status listed.)
- Granted
Links
- 238000000034 method Methods 0.000 title claims abstract description 31
- 238000006243 chemical reaction Methods 0.000 claims description 6
- 230000006870 function Effects 0.000 description 13
- 238000010586 diagram Methods 0.000 description 10
- 238000004590 computer program Methods 0.000 description 8
- 230000008901 benefit Effects 0.000 description 3
- 230000007547 defect Effects 0.000 description 3
- 230000004048 modification Effects 0.000 description 2
- 238000012986 modification Methods 0.000 description 2
- 230000003287 optical effect Effects 0.000 description 2
- 230000008569 process Effects 0.000 description 2
- 230000005540 biological transmission Effects 0.000 description 1
- 230000008859 change Effects 0.000 description 1
- 230000006872 improvement Effects 0.000 description 1
- 238000004519 manufacturing process Methods 0.000 description 1
- 230000003068 static effect Effects 0.000 description 1
Classifications
-
- G—PHYSICS
- G06—COMPUTING; CALCULATING OR COUNTING
- G06F—ELECTRIC DIGITAL DATA PROCESSING
- G06F16/00—Information retrieval; Database structures therefor; File system structures therefor
- G06F16/90—Details of database functions independent of the retrieved data types
- G06F16/95—Retrieval from the web
- G06F16/957—Browsing optimisation, e.g. caching or content distillation
- G06F16/9577—Optimising the visualization of content, e.g. distillation of HTML documents
-
- G—PHYSICS
- G06—COMPUTING; CALCULATING OR COUNTING
- G06F—ELECTRIC DIGITAL DATA PROCESSING
- G06F40/00—Handling natural language data
- G06F40/10—Text processing
- G06F40/166—Editing, e.g. inserting or deleting
- G06F40/177—Editing, e.g. inserting or deleting of tables; using ruled lines
- G06F40/18—Editing, e.g. inserting or deleting of tables; using ruled lines of spreadsheets
Landscapes
- Engineering & Computer Science (AREA)
- Theoretical Computer Science (AREA)
- Physics & Mathematics (AREA)
- General Engineering & Computer Science (AREA)
- General Physics & Mathematics (AREA)
- Databases & Information Systems (AREA)
- Data Mining & Analysis (AREA)
- Health & Medical Sciences (AREA)
- Artificial Intelligence (AREA)
- Audiology, Speech & Language Pathology (AREA)
- Computational Linguistics (AREA)
- General Health & Medical Sciences (AREA)
- User Interface Of Digital Computer (AREA)
- Information Retrieval, Db Structures And Fs Structures Therefor (AREA)
Abstract
The invention discloses a positioning method and device for a target column in a table and relates to the field of data processing. The problem that accurate positioning cannot be realized when a webpage table is searched for a target column is solved. The method comprises the steps that the table is initialized, wherein initialization includes starting of a search box of the table and setting of subscripts for columns in the table; content in the search box is acquired, and whether the content contains a preset symbol or not and whether information exists in the preset symbol or not are judged; if the preset symbol is contained and the information exists in the preset symbol, the information in the preset symbol is converted into a corresponding character or character string; the target column in the table is positioned according to the character or character string. The positioning method and device are mainly used for quickly positioning the target column in the table in a webpage.
Description
Technical Field
The present invention relates to the field of data processing, and in particular, to a table target column positioning method and apparatus.
Background
With the popularization of electronic office work, people can process a large amount of data on a computer. Usually, when data is displayed, a table is a very common display mode. However, due to the huge amount of data, some inconveniences may occur when the table is used for presentation. For example, when a form is displayed on a web page, due to the limitation of the size of the browser interface, when the number of columns of the form is large, all data cannot be completely displayed in the interface, so that horizontal scrolling must be set for the form to display all the column data within a fixed width of the interface.
When a user needs to search data in a table of a webpage, the data are searched by using a search function carried by the browser, and then the browser automatically locates corresponding content. However, if the web page contains a plurality of data identical to the target column, the browser will display all the column data in the web page, and the positioning is not accurate enough, so that the target column to be searched by the user cannot be accurately obtained.
Disclosure of Invention
In view of the above, the present invention provides a table target column positioning method and apparatus, and mainly aims to solve the problem that a target column cannot be accurately positioned when a web page table is searched.
According to a first aspect of the present invention, the present invention provides a table object column positioning method, including:
initializing a table, wherein the initialization comprises enabling a search box of the table and setting subscripts for columns of the table;
acquiring content in a search box, and judging whether the content comprises a preset symbol and whether information exists in the preset symbol or not;
if the preset symbol is included and information exists in the preset symbol, converting the information in the preset symbol into a corresponding character or character string;
the table target column is located according to the character or the character string.
According to a second aspect of the present invention, there is provided a table object column positioning device, comprising:
the processing unit is used for initializing the table, initializing a search box comprising an enabled table and setting subscripts for columns of the table;
the judging unit is used for acquiring the content in the search box and judging whether the content comprises a preset symbol and whether information exists in the preset symbol or not;
the conversion unit is used for converting the information in the preset symbol into a corresponding character or character string when the judgment unit judges that the content contains the preset symbol and the information exists in the preset symbol;
and the positioning unit is used for positioning the character or the character string obtained by the conversion unit to the table target column.
By means of the technical scheme, the table target column positioning method and the table target column positioning device provided by the embodiment of the invention can initialize the table, start the search box of the table and set subscripts for the columns of the table; acquiring content in a search box, and judging whether the content comprises a preset symbol and whether information exists in the preset symbol or not; if the preset symbol is included and information exists in the preset symbol, converting the information in the preset symbol into a corresponding character or character string; the table target column is located according to the character or the character string. Compared with the defect that in the prior art, when a user searches data in a table of a webpage, if the webpage contains a plurality of data which are the same as the target column, all the column data in the webpage can be displayed by using the search function of a browser, the method can convert the content in the preset symbol into the corresponding character or character string through the preset symbol carried by the content in the table search box, and accurately position the target column in the table according to the character and the character string.
The foregoing description is only an overview of the technical solutions of the present invention, and the embodiments of the present invention are described below in order to make the technical means of the present invention more clearly understood and to make the above and other objects, features, and advantages of the present invention more clearly understandable.
Drawings
Various other advantages and benefits will become apparent to those of ordinary skill in the art upon reading the following detailed description of the preferred embodiments. The drawings are only for purposes of illustrating the preferred embodiments and are not to be construed as limiting the invention. Also, like reference numerals are used to refer to like parts throughout the drawings. In the drawings:
fig. 1 is a flowchart illustrating a table target column positioning method according to an embodiment of the present invention;
FIG. 2 is a block diagram illustrating an apparatus for locating a table object column according to an embodiment of the present invention;
fig. 3 is a block diagram illustrating another table object column positioning apparatus according to an embodiment of the present invention.
Detailed Description
Exemplary embodiments of the present disclosure will be described in more detail below with reference to the accompanying drawings. While exemplary embodiments of the present disclosure are shown in the drawings, it should be understood that the present disclosure may be embodied in various forms and should not be limited to the embodiments set forth herein. Rather, these embodiments are provided so that this disclosure will be thorough and complete, and will fully convey the scope of the disclosure to those skilled in the art.
In data presentation, tables are a very common presentation. When a form is displayed on a web page, due to the limitation of the size of a browser interface, when the number of columns of the form is large, all data cannot be completely displayed in the interface, so that horizontal scrolling must be set for the form to display all column data within a fixed width of the interface. When a user needs to search data in a table of a webpage, the data are searched by using a search function carried by the browser, and then the browser automatically locates corresponding content. However, when the web page contains a plurality of data identical to the target column, the browser displays all the column data in the web page, and the positioning is not accurate enough.
In order to solve the problem that a target column cannot be accurately positioned when a web page table is searched, an embodiment of the present invention provides a table target column positioning method, as shown in fig. 1, the method includes:
101. the table is initialized.
Generally, in the field of computers, before starting to execute a task, initialization operations are generally required according to a program language or an acting object, including assigning a variable to a default value, setting a control to a default state, or allocating memory resources to a program by a system, so as to prevent unpredictable errors from being caused during use. Therefore, when the target column of the table is located, step 101 needs to be executed to initialize the table, except for basic setting of a data type for the table, inputting of default information of a program, and clearing of data for debugging, a search box of the table is mainly enabled so as to bind the locating operation to the table, avoid searching in the whole web page, and set subscripts for columns of the table to mark the sequence of the columns in the table.
102. And acquiring the content in the search box, and judging whether the content comprises a preset symbol and whether information exists in the preset symbol.
In the embodiment of the invention, after the search box is started for the table, the function expansion can be carried out aiming at the search box, namely, a certain search rule is preset for the search box, the search rule comprises a preset symbol, and after the preset symbol is input into the search box and specific search information is added into the preset symbol, a target column of a corresponding column subscript or a corresponding column header in the table can be found according to the search rule. Therefore, in step 102, the embodiment of the present invention needs to obtain the content in the search box, and determine whether the content includes the preset symbol and whether there is information in the preset symbol.
103. And if the preset symbol is included and the information exists in the preset symbol, converting the information in the preset symbol into a corresponding character or character string.
When it is determined in step 102 that the content in the search box includes the preset symbol and the preset symbol includes information, the information in the preset symbol needs to be converted into a corresponding character or character string according to a preset rule.
For example, in the embodiment of the present invention, the preset rule specifies that when subscript information representing a column in a table is added to a preset symbol a, the information can be converted into a corresponding character representing the subscript of the column; meanwhile, the preset rule provides that when information representing the head of a table in a table is added into the preset symbol B, the information can be converted into a corresponding character string representing the head of the table, wherein the head of the table is a mark in the first table in the column.
104. The table target column is located according to the character or the character string.
After the information in the predetermined symbol is converted into the corresponding character or character string in step 103, the target column can be accurately located in the table according to the related column subscript or column header information represented by the character or character string.
The table target column positioning method provided by the embodiment of the invention can initialize the table, start a search box of the table and set subscripts for the columns of the table; acquiring content in a search box, and judging whether the content comprises a preset symbol and whether information exists in the preset symbol or not; if the preset symbol is included and information exists in the preset symbol, converting the information in the preset symbol into a corresponding character or character string; the table target column is located according to the character or the character string. Compared with the defect that in the prior art, when a user searches data in a table of a webpage, if the webpage contains a plurality of data which are the same as the target column, all the column data in the webpage can be displayed by using the search function of a browser, the method can convert the content in the preset symbol into the corresponding character or character string through the preset symbol carried by the content in the table search box, and accurately position the target column in the table according to the character and the character string.
In order to better understand the method shown in fig. 1, the embodiment of the present invention will be described in detail with respect to the steps in fig. 1.
When initializing a form in a web page, in order to be able to bind a search to the form without searching all contents in the web page at the time of searching, the embodiment of the present invention needs to enable a search box of the form. For example, the form may be initialized by a DataTables plugin. When initializing the table, subscripts are also required to be set for columns of the table according to the sequence of each column in the table. The subscript of the column in the embodiment of the present invention indicates the position identifier of a certain column in the table. If there are more columns in the table, the subscripts of the columns may be represented by consecutive natural numbers in sequence; if there are fewer columns in the table, they may be represented by consecutive english letters. For example, subscripts may be provided for respective columns in order from left to right in the table, starting from the first column from the left of the table, and may be represented by a natural number that is consecutive in numbers 1, 2, 3, 4.
Because the embodiment of the invention needs to accurately position the target column in the table, the function expansion of the traditional search box which can only search according to the table content is needed. In the embodiment of the present invention, a specific search rule needs to be preset in the function of the search box, where the search rule includes a preset symbol and information to be added to the preset symbol, and after the preset symbol is input in the search box and the specific information is added to the preset symbol, if the input content (the preset symbol and the specific information therein) meets the preset rule, the input content is accurately located in the target column in the table. In the embodiment of the invention, the preset symbols in the preset rules comprise preset middle brackets or big brackets; wherein middle brackets are used to add information about the subscripts of the columns of the table; braces are used to add information about the head of the list of the table.
After the table is initialized in the above manner, when a target column of the table is located, first, the content in the search box needs to be acquired, and whether the content includes a preset middle bracket or a preset big bracket and whether information exists in the middle bracket or the big bracket is judged. When determining whether the content in the search box includes the preset symbol and whether the preset symbol includes the specific information, a single character string describing or matching a series of character strings conforming to a certain syntax rule may be used to perform a retrieval determination on the content in the search box, that is, a regular expression is used to perform the determination. Because the content in the search box is arranged in many ways, when the content in the search box is judged, it needs to be determined whether all the content in the search box is contained in the preset symbol, or whether a part of the content in the search box is contained in the preset symbol, or even whether the content in the search box does not contain the preset symbol. Based on the above-mentioned situations that may occur when determining the content in the search box, the embodiment of the present invention will be described with respect to several situations.
The middle brackets are used to add information about the subscripts of the columns of the table based on preset rules set for the search box. Therefore, when the content in the search box is determined to contain the parentheses and the content in the search box is in the parentheses after the judgment, the content in the parentheses needs to be converted into characters in the same format as the subscripts of the columns. For example, when using numbers to define the subscripts of a column in a table, the content in parentheses needs to be converted to numbers. The table is then searched for and located in the target column with the same index as the converted character. Or when information is input in the search box, characters in the same format as the subscripts of the columns are directly input in the brackets, so that the target columns with the subscripts being the same as the characters in the brackets are searched from the table.
The brace is used to add information about the head of the list of the table based on preset rules set for the search box. Therefore, when the content in the search box is judged to contain the braces and the content in the search box is in the braces, the content in the braces needs to be converted into a character string, and the character string is in the same format as the list header information. For example, when column header information in a table is defined using English words, it is necessary to convert the contents in parentheses into character strings. And then searching a target column with the same list head information as the converted character string from the table and positioning. Or directly inputting character strings with the same format as the list head information in the brackets when information is input in the search box so as to search the target columns with the same list head information and the character strings in the brackets from the table.
When the content in the search box is determined to be contained in the parentheses/braces and the content in the search box is partially in the parentheses/braces and partially out of the parentheses/braces after being judged, the content in the parentheses/braces needs to be converted into corresponding characters/character strings, and the content out of the parentheses/braces needs to be converted into corresponding characters/character strings; and is positioned to the target location in the table target column based on the content-converted character/string in parenthesis/brace and the content-converted character/string outside parenthesis/brace. For example, a character converted by the content in the middle bracket may be positioned in the table to the target column with the column subscript of 1, and on this basis, a character converted by the content outside the middle bracket may be specifically positioned to the target position of "zhang san" in the target column with the subscript of 1. Or, the character converted by the content in the parenthesis can be positioned to the target column with the column header of titleX in the table, and on the basis, the character converted by the content outside the parenthesis can be specifically positioned to the target position of "Liquan" in the target column with the column header of titleX.
According to the embodiment of the invention, the preset symbols of the preset rule are expanded in the table search box, so that the target column in the table can be quickly positioned through the subscript of the input column or the list head of the input column, and the purpose of quickly positioning the specific target position in the table can be achieved according to the arrangement of the search symbols and the search content.
Further, as an application of the method shown in fig. 1, an embodiment of the present invention further provides a table target column positioning apparatus, as shown in fig. 2, the apparatus includes: a processing unit 21, a judging unit 22, a converting unit 23 and a positioning unit 24, wherein,
a processing unit 21, configured to initialize a table, initialize a search box including enabling the table, and set subscripts for columns of the table;
the judging unit 22 is configured to obtain content in the search box, and judge whether the content includes a preset symbol and whether there is information in the preset symbol;
a conversion unit 23, configured to, when the determination unit 22 determines that the content includes the preset symbol and there is information in the preset symbol, convert the information in the preset symbol into a corresponding character or character string;
and the positioning unit 24 is used for positioning to the table target column according to the character or the character string obtained by the conversion unit 23.
Further, the processing unit 21 is configured to sequentially set subscripts for columns of the table in order.
Further, the judging unit 22 is configured to judge whether the content includes a preset middle bracket or a preset big bracket, wherein the middle bracket is used for adding information related to the subscript of the column of the table, and the big bracket is used for adding information related to the head of the column of the table.
Further, the judging unit 22 is configured to judge whether all the contents are contained in the preset symbol by using the regular expression, and judge whether a part of the contents are contained in the preset symbol by using the regular expression.
Further, as shown in fig. 3, the positioning unit 24 includes:
the searching module 241 is configured to search a target column in the table according to the character, where subscripts of the columns are the same as the character, and also search a target column in the table according to the character string, where a head of the column is the same as the character string;
and a positioning module 242, configured to position the target column searched by the searching module 241.
Further, the converting unit 23 is configured to, when the judging unit 22 judges that the preset symbol includes a part of content using the regular expression, convert the part of content in the preset symbol into a corresponding character or character string, and convert a part of content outside the preset symbol into a corresponding character or character string; the positioning unit 24 is configured to position the target position in the table target column according to the character or character string in the preset symbol and the character or character string outside the preset symbol.
The table target column positioning device provided by the embodiment of the invention can initialize a table, start a search box of the table and set subscripts for columns of the table; acquiring content in a search box, and judging whether the content comprises a preset symbol and whether information exists in the preset symbol or not; if the preset symbol is included and information exists in the preset symbol, converting the information in the preset symbol into a corresponding character or character string; the table target column is located according to the character or the character string. Compared with the defect that in the prior art, when a user searches data in a table of a webpage, if the webpage contains a plurality of data which are the same as the target column, all the column data in the webpage can be displayed by using the search function of a browser, the method can convert the content in the preset symbol into the corresponding character or character string through the preset symbol carried by the content in the table search box, and accurately position the target column in the table according to the character and the character string.
In addition, by expanding the preset symbols of the preset rules in the table search box, the embodiment of the invention can quickly locate the target column in the table through the subscript of the input column or the list head of the input column, and can also arrange the search symbols and the search content to quickly locate the specific target position in the table.
The table object column positioning device comprises a processor and a memory, wherein the processing unit 21, the judging unit 22, the converting unit 23 and the positioning unit 24 are all stored in the memory as program units, and the processor executes the program units stored in the memory to realize corresponding functions.
The processor comprises a kernel, and the kernel calls the corresponding program unit from the memory. The kernel can be set to be one or more than one, and the purpose of accurately positioning when searching the target column in the web page table is realized by adjusting the kernel parameters.
The memory may include volatile memory in a computer readable medium, Random Access Memory (RAM) and/or nonvolatile memory such as Read Only Memory (ROM) or flash memory (flash RAM), and the memory includes at least one memory chip.
The present application further provides a computer program product adapted to perform program code for initializing the following method steps when executed on a data processing device: initializing a table, wherein the initialization comprises enabling a search box of the table and setting subscripts for columns of the table; acquiring content in a search box, and judging whether the content comprises a preset symbol and whether information exists in the preset symbol or not; if the preset symbol is included and information exists in the preset symbol, converting the information in the preset symbol into a corresponding character or character string; the table target column is located according to the character or the character string.
As will be appreciated by one skilled in the art, embodiments of the present application may be provided as a method, system, or computer program product. Accordingly, the present application may take the form of an entirely hardware embodiment, an entirely software embodiment or an embodiment combining software and hardware aspects. Furthermore, the present application may take the form of a computer program product embodied on one or more computer-usable storage media (including, but not limited to, disk storage, CD-ROM, optical storage, and the like) having computer-usable program code embodied therein.
The present application is described with reference to flowchart illustrations and/or block diagrams of methods, apparatus (systems), and computer program products according to embodiments of the application. It will be understood that each flow and/or block of the flow diagrams and/or block diagrams, and combinations of flows and/or blocks in the flow diagrams and/or block diagrams, can be implemented by computer program instructions. These computer program instructions may be provided to a processor of a general purpose computer, special purpose computer, embedded processor, or other programmable data processing apparatus to produce a machine, such that the instructions, which execute via the processor of the computer or other programmable data processing apparatus, create means for implementing the functions specified in the flowchart flow or flows and/or block diagram block or blocks.
These computer program instructions may also be stored in a computer-readable memory that can direct a computer or other programmable data processing apparatus to function in a particular manner, such that the instructions stored in the computer-readable memory produce an article of manufacture including instruction means which implement the function specified in the flowchart flow or flows and/or block diagram block or blocks.
These computer program instructions may also be loaded onto a computer or other programmable data processing apparatus to cause a series of operational steps to be performed on the computer or other programmable apparatus to produce a computer implemented process such that the instructions which execute on the computer or other programmable apparatus provide steps for implementing the functions specified in the flowchart flow or flows and/or block diagram block or blocks.
In a typical configuration, a computing device includes one or more processors (CPUs), input/output interfaces, network interfaces, and memory.
The memory may include forms of volatile memory in a computer readable medium, Random Access Memory (RAM) and/or non-volatile memory, such as Read Only Memory (ROM) or flash memory (flash RAM). The memory is an example of a computer-readable medium.
Computer-readable media, including both non-transitory and non-transitory, removable and non-removable media, may implement information storage by any method or technology. The information may be computer readable instructions, data structures, modules of a program, or other data. Examples of computer storage media include, but are not limited to, phase change memory (PRAM), Static Random Access Memory (SRAM), Dynamic Random Access Memory (DRAM), other types of Random Access Memory (RAM), Read Only Memory (ROM), Electrically Erasable Programmable Read Only Memory (EEPROM), flash memory or other memory technology, compact disc read only memory (CD-ROM), Digital Versatile Discs (DVD) or other optical storage, magnetic cassettes, magnetic tape magnetic disk storage or other magnetic storage devices, or any other non-transmission medium that can be used to store information that can be accessed by a computing device. As defined herein, a computer readable medium does not include a transitory computer readable medium such as a modulated data signal and a carrier wave.
The above are merely examples of the present application and are not intended to limit the present application. Various modifications and changes may occur to those skilled in the art. Any modification, equivalent replacement, improvement, etc. made within the spirit and principle of the present application should be included in the scope of the claims of the present application.
Claims (10)
1. A method for locating a table object column, the method comprising:
initializing a table, the initializing including enabling a search box of the table and setting an index for a column of the table;
acquiring the content in the search box, and judging whether the content comprises a preset symbol and whether information exists in the preset symbol or not;
if the preset symbol is included and information exists in the preset symbol, converting the information in the preset symbol into a corresponding character or character string;
and positioning to a table target column according to the character or the character string.
2. The method of claim 1, wherein the assigning subscripts to columns of the table comprises:
and arranging subscripts for the columns of the table in sequence.
3. The method of claim 1, wherein the determining whether the content includes a predetermined symbol comprises:
judging whether the content contains a preset middle bracket or a preset big bracket; wherein,
the middle brackets are used for adding information related to subscripts of columns of the table;
the braces are used to add information about the head of the list of the table.
4. The method of claim 1, wherein the determining whether the content includes a predetermined symbol and whether information exists in the predetermined symbol comprises:
judging whether the content is contained in the preset symbol or not by using a regular expression; and
and judging whether the preset symbol contains part of the content or not by using a regular expression.
5. The method of claim 1, wherein said locating to a table target column based on said character or character string comprises:
searching a target column with the same column subscript as the character in the table according to the character and positioning; or
And searching a target column with the same column header as the character string in the table according to the character string and positioning.
6. The method of claim 4, further comprising:
if the regular expression is used for judging that the preset symbol contains part of the content, converting part of the content in the preset symbol into corresponding characters or character strings, and simultaneously converting part of the content outside the preset symbol into corresponding characters or character strings;
and positioning to a target position in a table target column according to the characters or character strings in the preset symbols and the characters or character strings outside the preset symbols.
7. A table object column locating apparatus, the apparatus comprising:
a processing unit configured to initialize a table, the initialization including enabling a search box of the table and setting subscripts for columns of the table;
the judging unit is used for acquiring the content in the search box and judging whether the content comprises a preset symbol and whether information exists in the preset symbol or not;
the conversion unit is used for converting the information in the preset symbol into a corresponding character or character string when the judgment unit judges that the content contains the preset symbol and the information exists in the preset symbol;
and the positioning unit is used for positioning to a table target column according to the character or the character string obtained by the conversion unit.
8. The apparatus of claim 7, wherein the processing unit is configured to assign subscripts to columns of the table in order.
9. The apparatus according to claim 7, wherein the judging unit is configured to judge whether the content is all contained in the preset symbol by using a regular expression; and judging whether the preset symbol contains part of the content or not by using a regular expression.
10. The apparatus of claim 7, wherein the positioning unit comprises:
the searching module is used for searching a target column with the same column subscript as the character in the table according to the character and searching a target column with the same column header as the character string in the table according to the character string;
and the positioning module is used for positioning the target column searched by the searching module.
Priority Applications (1)
| Application Number | Priority Date | Filing Date | Title |
|---|---|---|---|
| CN201510729604.4A CN106649364B (en) | 2015-10-30 | 2015-10-30 | Table target column positioning method and device |
Applications Claiming Priority (1)
| Application Number | Priority Date | Filing Date | Title |
|---|---|---|---|
| CN201510729604.4A CN106649364B (en) | 2015-10-30 | 2015-10-30 | Table target column positioning method and device |
Publications (2)
| Publication Number | Publication Date |
|---|---|
| CN106649364A true CN106649364A (en) | 2017-05-10 |
| CN106649364B CN106649364B (en) | 2020-03-27 |
Family
ID=58809341
Family Applications (1)
| Application Number | Title | Priority Date | Filing Date |
|---|---|---|---|
| CN201510729604.4A Active CN106649364B (en) | 2015-10-30 | 2015-10-30 | Table target column positioning method and device |
Country Status (1)
| Country | Link |
|---|---|
| CN (1) | CN106649364B (en) |
Cited By (3)
| Publication number | Priority date | Publication date | Assignee | Title |
|---|---|---|---|---|
| CN110728113A (en) * | 2018-06-28 | 2020-01-24 | 北京金山办公软件股份有限公司 | Information screening method and device of electronic forms and terminal equipment |
| CN112395830A (en) * | 2019-07-31 | 2021-02-23 | 腾讯科技（深圳）有限公司 | Form processing method based on Wan Guo code and related device |
| CN112966481A (en) * | 2019-12-13 | 2021-06-15 | 北京懿医云科技有限公司 | Data table display method and device |
Citations (5)
| Publication number | Priority date | Publication date | Assignee | Title |
|---|---|---|---|---|
| US4916655A (en) * | 1986-02-14 | 1990-04-10 | Hitachi, Ltd. | Method and apparatus for retrieval of a search string |
| US5230040A (en) * | 1988-09-21 | 1993-07-20 | Fuji Xerox Co., Ltd. | Table calculating device |
| EP0501416A3 (en) * | 1991-02-28 | 1994-01-05 | Hitachi Ltd | |
| CN101105797A (en) * | 2007-08-21 | 2008-01-16 | 南京新恺拓网络技术有限公司 | Form locating data mining method |
| CN103455498A (en) * | 2012-05-30 | 2013-12-18 | 重庆长安汽车股份有限公司 | Table keyword information locating method based on hypertext |
-
2015
- 2015-10-30 CN CN201510729604.4A patent/CN106649364B/en active Active
Patent Citations (5)
| Publication number | Priority date | Publication date | Assignee | Title |
|---|---|---|---|---|
| US4916655A (en) * | 1986-02-14 | 1990-04-10 | Hitachi, Ltd. | Method and apparatus for retrieval of a search string |
| US5230040A (en) * | 1988-09-21 | 1993-07-20 | Fuji Xerox Co., Ltd. | Table calculating device |
| EP0501416A3 (en) * | 1991-02-28 | 1994-01-05 | Hitachi Ltd | |
| CN101105797A (en) * | 2007-08-21 | 2008-01-16 | 南京新恺拓网络技术有限公司 | Form locating data mining method |
| CN103455498A (en) * | 2012-05-30 | 2013-12-18 | 重庆长安汽车股份有限公司 | Table keyword information locating method based on hypertext |
Non-Patent Citations (1)
| Title |
|---|
| 山桑弓 等: "excel中如何在某列中查找包含几个特定文字的行，并返回该行的数据？", 《HTTP://1T.CLICK/FPZ》 * |
Cited By (4)
| Publication number | Priority date | Publication date | Assignee | Title |
|---|---|---|---|---|
| CN110728113A (en) * | 2018-06-28 | 2020-01-24 | 北京金山办公软件股份有限公司 | Information screening method and device of electronic forms and terminal equipment |
| CN112395830A (en) * | 2019-07-31 | 2021-02-23 | 腾讯科技（深圳）有限公司 | Form processing method based on Wan Guo code and related device |
| CN112966481A (en) * | 2019-12-13 | 2021-06-15 | 北京懿医云科技有限公司 | Data table display method and device |
| CN112966481B (en) * | 2019-12-13 | 2023-09-29 | 北京懿医云科技有限公司 | Data form display method and device |
Also Published As
| Publication number | Publication date |
|---|---|
| CN106649364B (en) | 2020-03-27 |
Similar Documents
| Publication | Publication Date | Title |
|---|---|---|
| CN107957957B (en) | Test case obtaining method and device | |
| US11068441B2 (en) | Caseless file lookup in a distributed file system | |
| CN105824830B (en) | Method, client and equipment for displaying page | |
| CN105868166B (en) | Regular expression generation method and system | |
| CN104572668B (en) | Method and apparatus based on multiple pattern file generated Merge Styles files | |
| CN110020353B (en) | Method and device for constructing webpage form | |
| CN104268229A (en) | Resource obtaining method and device based on multi-process browser | |
| KR20170123337A (en) | Application loading method and device | |
| CN105843800A (en) | DOI-based language information display method and device | |
| CN106649364B (en) | Table target column positioning method and device | |
| CN108874379B (en) | Page processing method and device | |
| CN109597983A (en) | A kind of spelling error correction method and device | |
| CN113835737B (en) | Method and system for adding permission to front-end item | |
| CN104572904A (en) | Method and device for determining relevance level between tags | |
| CN104898991A (en) | Automatic-RAL-based register access method and system | |
| CN106648567B (en) | Data acquisition method and device | |
| JP2019522847A (en) | Method, device and terminal device for extracting data | |
| CN106339381B (en) | Information processing method and device | |
| US9258258B2 (en) | Implementing injection of formal numerical message identifiers in cloud stacks | |
| CN108073594B (en) | Method and device for generating thermodynamic diagram | |
| CN105243134A (en) | Method and equipment for processing hijacked browser | |
| CN107818000B (en) | Operation method and device of page table | |
| CN105786478A (en) | Data processing method and device | |
| US10296566B2 (en) | Apparatus and method for outputting web content that is rendered based on device information | |
| CN111859089B (en) | Wrong word detection control method for Internet information |
Legal Events
| Date | Code | Title | Description |
|---|---|---|---|
| PB01 | Publication | ||
| PB01 | Publication | ||
| SE01 | Entry into force of request for substantive examination | ||
| SE01 | Entry into force of request for substantive examination | ||
| CB02 | Change of applicant information | ||
| CB02 | Change of applicant information |
Address after: 100083 No. 401, 4th Floor, Haitai Building, 229 North Fourth Ring Road, Haidian District, Beijing Applicant after: Beijing Guoshuang Technology Co.,Ltd. Address before: 100086 Cuigong Hotel, 76 Zhichun Road, Shuangyushu District, Haidian District, Beijing Applicant before: Beijing Guoshuang Technology Co.,Ltd. |
|
| GR01 | Patent grant | ||
| GR01 | Patent grant |