CN113868282A - Data processing method and device, terminal and computer readable storage medium - Google Patents
Data processing method and device, terminal and computer readable storage medium Download PDFInfo
- Publication number
- CN113868282A CN113868282A CN202110903619.3A CN202110903619A CN113868282A CN 113868282 A CN113868282 A CN 113868282A CN 202110903619 A CN202110903619 A CN 202110903619A CN 113868282 A CN113868282 A CN 113868282A
- Authority
- CN
- China
- Prior art keywords
- data
- integrated
- character
- processing method
- data processing
- 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.)
- Pending
Links
- 238000003672 processing method Methods 0.000 title claims abstract description 37
- 230000010354 integration Effects 0.000 claims description 13
- 238000004590 computer program Methods 0.000 claims description 10
- 238000000034 method Methods 0.000 description 7
- 238000007689 inspection Methods 0.000 description 5
- 230000006870 function Effects 0.000 description 4
- 230000008569 process Effects 0.000 description 4
- 238000010586 diagram Methods 0.000 description 3
- 230000002265 prevention Effects 0.000 description 3
- 238000003908 quality control method Methods 0.000 description 3
- 239000002131 composite material Substances 0.000 description 2
- 239000000463 material Substances 0.000 description 2
- 230000004075 alteration Effects 0.000 description 1
- 230000008859 change Effects 0.000 description 1
- 239000000428 dust Substances 0.000 description 1
- 238000005516 engineering process Methods 0.000 description 1
- 230000004048 modification Effects 0.000 description 1
- 238000012986 modification Methods 0.000 description 1
- 238000006467 substitution reaction Methods 0.000 description 1
- 230000009466 transformation Effects 0.000 description 1
- XLYOFNOQVPJJNP-UHFFFAOYSA-N water Substances O XLYOFNOQVPJJNP-UHFFFAOYSA-N 0.000 description 1
Images
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/20—Information retrieval; Database structures therefor; File system structures therefor of structured data, e.g. relational data
- G06F16/24—Querying
- G06F16/242—Query formulation
- G06F16/2433—Query languages
-
- G—PHYSICS
- G06—COMPUTING; CALCULATING OR COUNTING
- G06F—ELECTRIC DIGITAL DATA PROCESSING
- G06F16/00—Information retrieval; Database structures therefor; File system structures therefor
- G06F16/20—Information retrieval; Database structures therefor; File system structures therefor of structured data, e.g. relational data
- G06F16/24—Querying
- G06F16/248—Presentation of query results
-
- G—PHYSICS
- G06—COMPUTING; CALCULATING OR COUNTING
- G06F—ELECTRIC DIGITAL DATA PROCESSING
- G06F16/00—Information retrieval; Database structures therefor; File system structures therefor
- G06F16/20—Information retrieval; Database structures therefor; File system structures therefor of structured data, e.g. relational data
- G06F16/28—Databases characterised by their database models, e.g. relational or object models
- G06F16/284—Relational databases
- G06F16/285—Clustering or classification
- G06F16/287—Visualization; Browsing
Landscapes
- Engineering & Computer Science (AREA)
- Theoretical Computer Science (AREA)
- Databases & Information Systems (AREA)
- Physics & Mathematics (AREA)
- Data Mining & Analysis (AREA)
- General Engineering & Computer Science (AREA)
- General Physics & Mathematics (AREA)
- Computational Linguistics (AREA)
- Mathematical Physics (AREA)
- Information Retrieval, Db Structures And Fs Structures Therefor (AREA)
Abstract
The application discloses a data processing method, a data processing device, a terminal and a non-volatile computer readable storage medium. The data processing method comprises the following steps: acquiring a plurality of pieces of data stored in a plurality of continuous cells in a first table; if the last character of the data is not matched with the preset ending character, integrating the data and the next piece of data of the data until the last character of the integrated data is matched with the preset ending character; and filling the integrated data into a second table. The data processing method, the data processing device, the terminal and the nonvolatile computer readable storage medium of the embodiment of the application eliminate the line feed situation among a plurality of data, so that when the integrated data is filled into a table, only each integrated data is used for line feed, thereby subtracting the situation of manually copying one by one, reducing the working time and the working cost and ensuring the accuracy.
Description
Technical Field
The present application relates to the field of data processing technologies, and in particular, to a data processing method, a data processing apparatus, a terminal, and a non-volatile computer-readable storage medium.
Background
Currently, when multiple Structured Query Language (SQL) statements are pasted into a table (Excel), a single SQL statement may be pasted into multiple cells due to the line feed existing in the complete SQL statement. Therefore, the copying can be performed only by human, which is time-consuming, labor-consuming and error-prone.
Disclosure of Invention
The embodiment of the application provides a data processing method, a data processing device, a terminal and a non-volatile computer readable storage medium.
The data processing method of the embodiment of the application comprises the following steps: acquiring a plurality of pieces of data stored in a plurality of continuous cells in a first table; if the last character of the data is not matched with a preset ending character, integrating the data and the next piece of data of the data until the last character of the integrated data is matched with the preset ending character; and filling the integrated data into a second table.
The data processing device comprises an acquisition module, an integration module and a filling module, wherein the acquisition module is used for acquiring a plurality of pieces of data stored in a plurality of continuous cells in a first form; the integration module is used for integrating the data and the next piece of data of the data if the last character of the data is not matched with a preset ending character until the last character of the integrated data is matched with the preset ending character; and the filling module is used for filling the integrated data into a second table.
The terminal comprises a processor, a first table and a second table, wherein the processor is used for acquiring a plurality of pieces of data stored in a plurality of continuous cells in the first table; if the last character of the data is not matched with a preset ending character, integrating the data and the next piece of data of the data until the last character of the integrated data is matched with the preset ending character; and filling the integrated data into a second table.
The non-transitory computer-readable storage medium of the embodiments of the present application contains a computer program that, when executed by one or more processors, causes the processors to perform a method such as data processing: acquiring a plurality of pieces of data stored in a plurality of continuous cells in a first table; if the last character of the data is not matched with a preset ending character, integrating the data and the next piece of data of the data until the last character of the integrated data is matched with the preset ending character; and filling the integrated data into a second table.
The data processing method, the data processing device, the terminal and the nonvolatile computer readable storage medium of the embodiment of the application eliminate the line feed situation among a plurality of data by judging whether the last character of the data is matched with the preset ending character or not to obtain the integrated data matched with the preset ending character, so that when the integrated data is filled into a table, only each integrated data is used for line feed, the situation of manually copying one by one is reduced, the working time and the working cost are reduced, and the accuracy is ensured.
Additional aspects and advantages of embodiments of the present application will be set forth in part in the description which follows and, in part, will be obvious from the description, or may be learned by practice of embodiments of the present application.
Drawings
The above and/or additional aspects and advantages of the present application will become apparent and readily appreciated from the following description of the embodiments, taken in conjunction with the accompanying drawings of which:
FIG. 1 is a schematic flow chart diagram of a data processing method according to some embodiments of the present application;
FIG. 2 is a schematic diagram of a data processing apparatus according to some embodiments of the present application;
FIG. 3 is a schematic plan view of a terminal according to some embodiments of the present application;
FIGS. 4-6 are schematic flow charts of data processing methods according to certain embodiments of the present application;
FIG. 7 is a schematic diagram of a connection state of a non-volatile computer readable storage medium and a processor of some embodiments of the present application.
Detailed Description
Reference will now be made in detail to embodiments of the present application, examples of which are illustrated in the accompanying drawings, wherein like or similar reference numerals refer to the same or similar elements or elements having the same or similar function throughout. The embodiments described below by referring to the drawings are exemplary only for the purpose of explaining the embodiments of the present application, and are not to be construed as limiting the embodiments of the present application.
Referring to fig. 1, an embodiment of the present application provides a data processing method. The method of the data processing method comprises the following steps:
01: acquiring a plurality of pieces of data stored in a plurality of continuous cells in a first table;
05: if the last character of the data is not matched with the preset ending character, integrating the data and the next piece of data of the data until the last character of the integrated data is matched with the preset ending character; and
09: and filling the integrated data into a second table.
Referring to fig. 2, a data processing apparatus 10 is provided in the present embodiment. The data processing apparatus 10 includes an obtaining module 11, an integrating module 12, and a filling module 13. The data processing method according to the embodiment of the present application is applicable to the data processing apparatus 10. The obtaining module 11 is configured to perform step 01, the integrating module 12 is configured to perform step 05, and the filling module 13 is configured to perform step 09. That is, the obtaining module 11 is configured to obtain a plurality of pieces of data stored in a plurality of consecutive cells in the first table. The integration module 12 is configured to, if the last character of the data does not match the preset ending character, integrate the data and the next piece of data of the data until the last character of the integrated data matches the preset ending character. The filling module 13 is used for filling the integrated data into the second table.
Referring to fig. 3, the present embodiment further provides a terminal 100. The terminal 100 includes a processor 20. The data processing method according to the embodiment of the present application can be applied to the terminal 100. Processor 20 is configured to perform step 01, step 05 and step 09. That is, the processor 20 obtains a plurality of pieces of data stored in a plurality of cells in succession in the first table; if the last character of the data is not matched with the preset ending character, integrating the data and the next piece of data of the data until the last character of the integrated data is matched with the preset ending character; and filling the integrated data into a second table.
The terminal 100 also includes a housing 40. The terminal 100 may be a mobile phone, a computer, a tablet computer, a notebook computer, a smart watch, etc. As shown in fig. 3, the terminal 100 is exemplified as a computer in the embodiment of the present application, and it is understood that the specific form of the terminal 100 is not limited to a computer. The housing 40 may also be used to mount functional modules, such as processing devices, power supply devices, etc., of the terminal 100, so that the housing 40 provides protection for the functional modules, such as dust prevention, drop prevention, water prevention, etc.
Specifically, a plurality of continuous cells in the first table store a plurality of pieces of data, and the processor 20 may obtain the data from the first table. The continuous cells may be a plurality of cells continuous in a row direction, or a plurality of cells continuous in a column direction, and the data may be a Structured Query Language (SQL) statement for operating the database, or data for storing data information. In the data processing method according to the embodiment of the present application, the continuous cells are the continuous cells in the column direction, and the data is the SQL statement, for example, it can be understood that the continuous mode of the continuous cells and the form of the data are not limited to one. Since a plurality of pieces of data are stored in a plurality of cells in succession, it is known that an auto line feed character exists between the plurality of pieces of data.
Next, after the processor 20 obtains a plurality of pieces of data, it is sequentially determined whether a last character of the data matches a preset ending character, and if so, the processor 20 takes the piece of data as integrated data; if not, the processor 20 integrates the piece of data with a piece of data subsequent to the piece of data, and continues to determine whether the last character of the integrated data matches the preset ending character until the last character of the integrated data matches the preset ending character.
Similarly, after the processor 20 integrates one piece of data, if there is data in the pieces of data, the processor 20 continues to determine whether the last character of the data of the day after the integration matches the preset ending character, so that the processor 20 integrates the pieces of data into a plurality of pieces of integrated data.
More specifically, the specific operation of integrating the pieces of data into integrated data is to eliminate the auto-linefeed between the pieces of data. Namely, the automatic line feed character among a plurality of data is modified into a forced line feed character or the automatic line feed character among a plurality of data is deleted in the data which needs to be integrated into one integrated data. It should be noted that the processor 20 only processes the automatic line break between the plurality of pieces of data in the integrated data, and does not process the automatic line break between the plurality of pieces of integrated data, and when the last character of the data matches the preset ending character, it indicates that the data or the data integrated by the plurality of pieces of data is the SQL statement. The automatic line-feed character can lead a plurality of data to feed the unit cell at the position of the automatic line-feed character, namely to feed to the next unit cell, and the forced line-feed character can lead a plurality of data to feed the unit cell at the position of the forced line-feed character, namely to feed the same unit cell.
In summary, the integrated data is not limited to the data obtained by integrating a plurality of pieces of data, and if the last character of a single piece of data matches the predetermined ending character, the processor 20 also uses the piece of data as the integrated data.
The predetermined ending character may be a period and/or a semicolon, and when the processor 20 determines whether the last character of the data matches the predetermined ending character, it determines whether the last character of the data is a period and/or a semicolon. If the last character of the data is a period, the processor 20 determines that the piece of data matches the predetermined ending character, if the last character of the data is a semicolon, the processor 20 determines that the piece of data matches the predetermined ending character, and if the last character of the data is a space, the processor 20 determines that the piece of data does not match the predetermined ending character.
Finally, after the processor 20 integrates the plurality of pieces of data into a plurality of pieces of integrated data, the processor 20 fills the plurality of pieces of integrated data into the second table. Because the plurality of integrated data do not have automatic line feed and the plurality of integrated data have automatic line feed, when the plurality of integrated data are filled into the second table, one integrated data is correspondingly stored in a plurality of continuous cells in the second table.
The data processing method, the data processing apparatus 10, and the terminal 100 according to the embodiment of the present application obtain integrated data matched with the preset ending character by determining whether the last character of the data matches the preset ending character, so as to eliminate line change between multiple data.
Referring to fig. 2, 3 and 4, in some embodiments, step 05: integrating the data and the latter data of the data, and further comprising the steps of:
051: and adding splicing characters behind the data to integrate the data and the next piece of data of the data.
In certain embodiments, integration module 12 is configured to perform step 051. Namely, the integration module 12 is used for adding splicing characters after the data so as to integrate the data and the next piece of data of the data.
In certain embodiments, processor 20 is configured to perform step 051. I.e. the processor 20 is arranged to add a concatenation character after the data to integrate the data with the latter piece of data.
When the data and the latter data are integrated, the splicing character can be added behind the data so as to integrate the data and the latter data of the data.
Specifically, when multiple pieces of data are integrated into an integrated data, the processor 20 may eliminate the auto-linefeed between the multiple pieces of data to ensure that one integrated data is not switched to the next cell when filling one cell. However, a plurality of data are tightly filled in one cell, which is inconvenient to read.
Therefore, when integrating a plurality of data into one integrated data, a splicing character can be added between two adjacent data, so that the plurality of data can be spaced for reading without influencing the filling of the integrated data into one cell.
Where the concatenated characters may be "spaces" or line breaks. A "space" may separate two pieces of data, and a force line wrapping character may enable data to be forced within a cell.
Therefore, the reading performance of the data in the cells can be ensured under the condition that each integrated data is respectively filled into one cell.
Referring to fig. 2, fig. 3 and fig. 5, the data processing method according to the embodiment of the present application further includes the steps of:
04: and if the first character of the data is matched with the preset starting character, judging the data to be invalid data.
In certain embodiments, the integration module 12 is configured to perform step 04. That is, the integration module 12 is configured to determine that the data is invalid data if the first character of the data matches the preset starting character.
In certain embodiments, processor 20 is configured to perform step 04. That is, the processor 20 is configured to determine that the data is invalid if the first character of the data matches the predetermined starting character.
Specifically, before the processor 20 determines whether the last character of the data matches the preset ending character, the processor 20 may further determine that the first character of the data matches the preset starting character, if so, the processor 20 may not determine whether the last character of the data matches the preset ending character, and the processor 20 directly determines that the data is invalid; if not, the processor 20 will perform the step of determining whether the last character of the data matches the predetermined ending character to integrate the plurality of sets of data.
More specifically, in the SQL statement, when the starting character is a double-horizontal line "-", or a slash with an asterisk "/", it indicates that the statement is an annotation. Thus, the predetermined starting character may be a horizontal line and/or a diagonal line, and when the processor 20 determines that the first character of the data is a horizontal line and/or a diagonal line, the data is identified as a comment, and the processor 20 determines that the data is invalid.
Referring to fig. 2, 3 and 6, in some embodiments, the second table includes a data table, and the data processing method further includes:
02: and generating an integrated table corresponding to the data table according to the data table and information of the data table in a third table corresponding to the name of the data table, wherein the third table is used for recording the table element information.
In some embodiments, the data processing apparatus 10 further includes a generating module 14, and the generating module 14 is configured to execute step 02, that is, the generating module 14 is configured to generate an integrated table corresponding to the data table according to the data table and information of the data table in a third table corresponding to the name of the data table, where the third table is used for recording the table meta information.
In some embodiments, the processor 20 is configured to perform step 02, that is, the processor 20 is configured to generate an integrated table corresponding to the data table according to the data table and information of the data table in a third table corresponding to the name of the data table, where the third table is used for recording the table meta information.
Please refer to tables 1 to 3 below, wherein table 1 is a plurality of data tables in the second table, table 2 is a plurality of integration tables in the second table, and table 3 is a third table. The data table in the second table is a preset demand table. The third table includes a plurality of data tables corresponding to the data tables and recording the table meta information.
TABLE 1
TABLE 2
TABLE 3
Specifically, before the integrated data is filled into the second table, in order to clarify each piece of integrated data, that is, the data information corresponding to the SQL statement, the integrated table needs to be generated first, so as to generate the table name information and the table metadata information corresponding to each piece of SQL statement.
More specifically, an Extract-Transform-Load (ETL) flow may first be introduced into the specified cells to generate the generate table name information button and generate table meta information button as in table 1. By introducing the ETL stream, after clicking the table name generation information button, the information (i.e., table ID) of the data table corresponding to the physical name of the target table in the multiple data tables in the third table can be found according to the name (i.e., physical name of the target table) in the data table.
Thus, the integrated table shown in table 2 can be generated from the data table in the second table and the information of the data table in the third table corresponding to the name of the data table. The integrated table contains table name information and table meta information, such as table id, table Chinese name, quality inspection relationship remark, quality inspection relationship number, and the like.
It should be noted that table 1 and table 2 together form a second table, i.e., table 1 and table 2 are located in the same sheet.
Referring to fig. 2, fig. 3 and fig. 6, in some embodiments, the data table includes a plurality of data tables, and the data processing method further includes the steps of:
03: and deleting empty rows among the plurality of data tables and empty rows among the plurality of integrated tables.
In some embodiments, the integration module 12 is configured to perform step 03, that is, the integration module 12 is configured to delete an empty row between the plurality of data tables and an empty row between the plurality of integration tables.
In some embodiments, processor 20 is configured to perform step 03, that is, processor 20 is configured to perform the empty row between the plurality of data tables and the empty row between the plurality of integrated tables.
Specifically, as shown in table 1 above, there is an empty row between the multiple data tables in the second table, and when the information of the data table in the third table is obtained by the names of the multiple data tables, the information of the data table in the third table is also obtained by the empty row between the multiple data tables, and at this time, since there is no name in the empty row, the information of the data table in the third table is also blank by the empty row. There will also be empty rows between multiple integrated tables after the integrated table is generated.
Next, the empty row button can be deleted to delete the empty rows between the multiple data tables and the empty rows between the multiple integrated tables simultaneously, so that the multiple data tables are integrated into one data table and the multiple integrated tables are integrated into one integrated table (as shown in tables 4 and 5 below).
TABLE 4
| Target table physical name | Target table Chinese name | Object field | Transformation rules |
| MAC_EG_RoadDistanceProvY | Road traffic distance meter (provincial level) (year) | Counting year | Spatial association |
| MAC_EG_RoadDistanceProvY | Road traffic distance meter (provincial level) (year) | Province A code | Direct correspondence |
| MAC_EG_RoadDistanceProvY | Road traffic distance meter (provincial level) (year) | Province A name | Direct correspondence |
| MAC_EG_RoadDistanceCityY | Road traffic distance meter (grade) (year) | Province B code | Direct correspondence |
| MAC_EG_RoadDistanceCityY | Road traffic distance meter (grade) (year) | Provincial society B name | Direct correspondence |
| MAC_EG_RoadDistanceCityY | RoadTraffic distance meter (grade) (year) | Passage route | Spatial association |
| MAC_EG_RoadDistanceCount | Road traffic distance meter (county level) (year) | Passing mileage | Direct correspondence |
| MAC_EG_RoadDistanceCount | Road traffic distance meter (county level) (year) | Shortest transit time | Spatial association |
| MAC_EG_RoadDistanceCount | Road traffic distance meter (county level) (year) | Counting year | Spatial association |
TABLE 5
Referring to fig. 2, 3 and 6, in some embodiments, step 09: filling the integrated data into a second table, further comprising the steps of:
091: and filling the integrated data into an integrated form.
In some embodiments, the filling module 13 is used to execute step 091, that is, the filling module 13 is used to fill the integrated data into the integrated table.
In some embodiments, the processor 20 is configured to perform step 091, that is, the processor 20 is configured to fill the integrated data into the integrated table.
After the integrated table is generated, the integrated data can be filled into the integrated table, specifically, as shown in table 5 above, the integrated data is filled into the quality inspection relationship of the integrated table.
More specifically, the user can integrate the pieces of data stored in the plurality of continuous cells in the first table by clicking the composite quality control relationship button, and automatically fill the pieces of data into the quality control relationship content of the integrated table.
The function of implementing the synthesized quality inspection relation button may specifically be: the processor 20 traverses a plurality of data in a plurality of rows of cells in the first table, if the first character of the row of data is determined to be "- - -" or the row of cells is empty, the data is determined to be an annotation, namely invalid data, and then traverses a plurality of data in the following plurality of rows in the first table until the last character of the data is determined to be a semicolon (;) end, the data between the cell of the initial row and the end of the semicolon can be integrated into one integrated data, a "chr (10)" character is added between the plurality of data, namely a line-change forcing character, so that the integrated data can be stored in one cell, and therefore, the plurality of data in the first table can be integrated into a plurality of integrated data, and the plurality of integrated data can be stored in one cell.
When the user clicks the composite quality control relationship button shown in table 1, the multiple pieces of integrated data are sequentially filled into the continuous cells in the integrated table. Because each integrated data has the automatic line feed character, after filling one integrated data, the next integrated data is filled in the next cell to ensure that only one integrated data exists in each cell.
Therefore, the multiple pieces of data in the first table can be automatically acquired and integrated by clicking the synthesized quality inspection relation button, and the integrated table is filled with the multiple pieces of data cell by cell, so that on one hand, each cell in the integrated table is guaranteed to store one piece of integrated data, and on the other hand, the integrated data in each cell is guaranteed to be convenient to read.
Referring to fig. 7, the present embodiment further provides a non-volatile pseudo-computer readable storage medium 200 containing a computer program 201. The computer program 201, when executed by the one or more processors 20, causes the one or more processors 20 to perform the data processing method of any of the embodiments described above.
For example, the computer program 201, when executed by the one or more processors 20, causes the processors 20 to perform the following data processing method:
01: acquiring a plurality of pieces of data stored in a plurality of continuous cells in a first table;
05: if the last character of the data is not matched with the preset ending character, integrating the data and the next piece of data of the data until the last character of the integrated data is matched with the preset ending character; and
09: and filling the integrated data into a second table.
As another example, the computer program 201, when executed by the one or more processors 20, causes the processors 20 to perform the following data processing method:
051: and adding splicing characters behind the data to integrate the data and the next piece of data of the data.
As another example, the computer program 201, when executed by the one or more processors 20, causes the processors 20 to perform the following data processing method:
04: and if the first character of the data is matched with the preset starting character, judging the data to be invalid data.
As another example, the computer program 201, when executed by the one or more processors 20, causes the processors 20 to perform the following data processing method:
06: and generating an integrated table corresponding to the data table according to the data table and information of the data table in a third table corresponding to the name of the data table, wherein the third table is used for recording the table element information.
As another example, the computer program 201, when executed by the one or more processors 20, causes the processors 20 to perform the following data processing method:
07: and deleting empty rows among the plurality of data tables and empty rows among the plurality of integrated tables.
Also for example, the computer program 201, when executed by the one or more processors 20, causes the processors 20 to perform the following image processing method:
091: and filling the integrated data into an integrated form.
In the description herein, references to the description of the terms "certain embodiments," "one example," "exemplary," etc., mean that a particular feature, structure, material, or characteristic described in connection with the embodiment or example is included in at least one embodiment or example of the application. In this specification, schematic representations of the above terms do not necessarily refer to the same embodiment or example. Furthermore, the particular features, structures, materials, or characteristics described may be combined in any suitable manner in any one or more embodiments or examples. Furthermore, various embodiments or examples and features of different embodiments or examples described in this specification can be combined and combined by one skilled in the art without contradiction.
Any process or method descriptions in flow charts or otherwise described herein may be understood as representing modules, segments, or portions of code which include one or more executable instructions for implementing specific logical functions or steps of the process, and the scope of the preferred embodiments of the present application includes other implementations in which functions may be executed out of order from that shown or discussed, including substantially concurrently or in reverse order, depending on the functionality involved, as would be understood by those reasonably skilled in the art of the present application.
Although embodiments of the present application have been shown and described above, it is to be understood that the above embodiments are exemplary and not to be construed as limiting the present application, and that changes, modifications, substitutions and alterations can be made to the above embodiments by those of ordinary skill in the art within the scope of the present application.
Claims (10)
1. A data processing method, comprising:
acquiring a plurality of pieces of data stored in a plurality of continuous cells in a first table;
if the last character of the data is not matched with a preset ending character, integrating the data and the next piece of data of the data until the last character of the integrated data is matched with the preset ending character; and
and filling the integrated data into a second table.
2. The data processing method of claim 1, wherein the integrating the data and the subsequent piece of the data comprises:
and adding the splicing character after the data so as to integrate the data and the latter data of the data.
3. The data processing method of claim 1, further comprising:
and if the first character of the data is matched with the preset starting character, judging that the data is invalid data.
4. A data processing method as claimed in claim 3, characterized in that the predetermined ending character can be a period and/or a semicolon and the predetermined starting character can be a horizontal line and/or a diagonal line.
5. The data processing method of claim 1, wherein the second table comprises a data table, the data processing method further comprising:
and generating an integrated table corresponding to the data table according to the data table and information of the data table in a third table corresponding to the name of the data table, wherein the third table is used for recording table meta information.
6. The data processing method according to claim 5, wherein the data table is plural, the data processing method comprising:
deleting empty rows between the plurality of data tables and the empty rows between the plurality of integrated tables.
7. The data processing method of claim 6, wherein the populating the second table with the integrated data comprises:
and filling the integrated data into the integrated table.
8. A data processing apparatus, comprising:
the acquisition module is used for acquiring a plurality of pieces of data stored in a plurality of continuous cells in a first table;
the integration module is used for integrating the data and the next piece of data of the data if the last character of the data is not matched with a preset ending character until the last character of the integrated data is matched with the preset ending character; and
and the filling module is used for filling the integrated data into a second table.
9. A terminal, comprising a processor configured to:
acquiring a plurality of pieces of data stored in a plurality of continuous cells in a first table;
if the last character of the data is not matched with a preset ending character, integrating the data and the next piece of data of the data until the last character of the integrated data is matched with the preset ending character; and
and filling the integrated data into a second table.
10. A non-transitory computer-readable storage medium containing a computer program which, when executed by a processor, causes the processor to perform a data processing method as claimed in any one of claims 1 to 7.
Priority Applications (1)
| Application Number | Priority Date | Filing Date | Title |
|---|---|---|---|
| CN202110903619.3A CN113868282A (en) | 2021-08-06 | 2021-08-06 | Data processing method and device, terminal and computer readable storage medium |
Applications Claiming Priority (1)
| Application Number | Priority Date | Filing Date | Title |
|---|---|---|---|
| CN202110903619.3A CN113868282A (en) | 2021-08-06 | 2021-08-06 | Data processing method and device, terminal and computer readable storage medium |
Publications (1)
| Publication Number | Publication Date |
|---|---|
| CN113868282A true CN113868282A (en) | 2021-12-31 |
Family
ID=78990305
Family Applications (1)
| Application Number | Title | Priority Date | Filing Date |
|---|---|---|---|
| CN202110903619.3A Pending CN113868282A (en) | 2021-08-06 | 2021-08-06 | Data processing method and device, terminal and computer readable storage medium |
Country Status (1)
| Country | Link |
|---|---|
| CN (1) | CN113868282A (en) |
Citations (10)
| Publication number | Priority date | Publication date | Assignee | Title |
|---|---|---|---|---|
| JP2007004681A (en) * | 2005-06-27 | 2007-01-11 | Toshiyuki Kono | Data acquiring method, data acquiring system, data acquiring device and computer program |
| JP2012068879A (en) * | 2010-09-22 | 2012-04-05 | Fujitsu Ltd | Character recognition device, character recognition device control program, character recognition device control method and portable terminal device |
| WO2013031117A1 (en) * | 2011-08-26 | 2013-03-07 | 日本電気株式会社 | Join processing device, data management device, and character string similarity join system |
| CN109408535A (en) * | 2018-09-28 | 2019-03-01 | 中国平安财产保险股份有限公司 | Big data quantity matching process, device, computer equipment and storage medium |
| CN109657109A (en) * | 2018-11-23 | 2019-04-19 | 山东中创软件商用中间件股份有限公司 | Specified word lookup method, device, equipment and storage medium in a kind of document |
| CN109783810A (en) * | 2018-12-26 | 2019-05-21 | 北京明略软件系统有限公司 | A kind of text handling method, device and computer readable storage medium |
| WO2020015150A1 (en) * | 2018-07-18 | 2020-01-23 | 平安科技（深圳）有限公司 | Method and device for dynamically exporting data table, computer apparatus, and storage medium |
| CN111258989A (en) * | 2020-02-14 | 2020-06-09 | 腾讯科技（深圳）有限公司 | Database migration evaluation method and device, storage medium and computer equipment |
| CN111506569A (en) * | 2020-03-02 | 2020-08-07 | 平安科技（深圳）有限公司 | Data storage method and device and electronic device |
| CN111563372A (en) * | 2020-05-11 | 2020-08-21 | 世纪金榜集团股份有限公司 | Typesetting document content self-duplication checking method based on teaching book publishing |
-
2021
- 2021-08-06 CN CN202110903619.3A patent/CN113868282A/en active Pending
Patent Citations (10)
| Publication number | Priority date | Publication date | Assignee | Title |
|---|---|---|---|---|
| JP2007004681A (en) * | 2005-06-27 | 2007-01-11 | Toshiyuki Kono | Data acquiring method, data acquiring system, data acquiring device and computer program |
| JP2012068879A (en) * | 2010-09-22 | 2012-04-05 | Fujitsu Ltd | Character recognition device, character recognition device control program, character recognition device control method and portable terminal device |
| WO2013031117A1 (en) * | 2011-08-26 | 2013-03-07 | 日本電気株式会社 | Join processing device, data management device, and character string similarity join system |
| WO2020015150A1 (en) * | 2018-07-18 | 2020-01-23 | 平安科技（深圳）有限公司 | Method and device for dynamically exporting data table, computer apparatus, and storage medium |
| CN109408535A (en) * | 2018-09-28 | 2019-03-01 | 中国平安财产保险股份有限公司 | Big data quantity matching process, device, computer equipment and storage medium |
| CN109657109A (en) * | 2018-11-23 | 2019-04-19 | 山东中创软件商用中间件股份有限公司 | Specified word lookup method, device, equipment and storage medium in a kind of document |
| CN109783810A (en) * | 2018-12-26 | 2019-05-21 | 北京明略软件系统有限公司 | A kind of text handling method, device and computer readable storage medium |
| CN111258989A (en) * | 2020-02-14 | 2020-06-09 | 腾讯科技（深圳）有限公司 | Database migration evaluation method and device, storage medium and computer equipment |
| CN111506569A (en) * | 2020-03-02 | 2020-08-07 | 平安科技（深圳）有限公司 | Data storage method and device and electronic device |
| CN111563372A (en) * | 2020-05-11 | 2020-08-21 | 世纪金榜集团股份有限公司 | Typesetting document content self-duplication checking method based on teaching book publishing |
Similar Documents
| Publication | Publication Date | Title |
|---|---|---|
| US11423457B2 (en) | User interface and geo-parsing data structure | |
| CN108563711B (en) | Time sequence data storage method based on time nodes | |
| CN100440221C (en) | Apparatus and method for a managing file system | |
| US9336095B2 (en) | Computing system and related data management method thereof | |
| CN102722516B (en) | NAND Flash writing file-orientated generating method and corresponding device | |
| CN102523129A (en) | Universal avionics bus test analysis method and device | |
| CN111061758B (en) | Data storage method, device and storage medium | |
| US20050240562A1 (en) | Method, computer program product and device for importing a plurality of data sets into a system | |
| CN110674052B (en) | Memory management method, server and readable storage medium | |
| CN102024057B (en) | Method and device for building index of mass data record | |
| CN104951482B (en) | A kind of method and device of the image file of operation Sparse formats | |
| CN112765163A (en) | Data index storage method, system and device capable of extending dimensionality at will | |
| CN110969000B (en) | Data merging processing method and device | |
| CN113868282A (en) | Data processing method and device, terminal and computer readable storage medium | |
| CN108664482B (en) | FLASH memory and storage file management method | |
| CN101207705A (en) | Graphic file management method | |
| CN109325221B (en) | Method and device for merging table files | |
| CN110516220B (en) | Report data input method, system and related equipment | |
| CN111880745A (en) | Data processing method, device and equipment based on solid-state disk array and storage medium | |
| CN111459943A (en) | Data processing method, device, system, equipment and storage medium | |
| CN110866127A (en) | Method for establishing index and related device | |
| CN109033271B (en) | Data insertion method and device based on column storage, server and storage medium | |
| CN113407261A (en) | Data configuration method and device and computer equipment | |
| CN111352917A (en) | Information input method and device, electronic equipment and storage medium | |
| CN112423104A (en) | Audio mixing method and system for multi-channel audio in live scene |
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 |