CN110175317A - A kind of txt batch turns the data method of Excel - Google Patents
A kind of txt batch turns the data method of Excel Download PDFInfo
- Publication number
- CN110175317A CN110175317A CN201910346501.8A CN201910346501A CN110175317A CN 110175317 A CN110175317 A CN 110175317A CN 201910346501 A CN201910346501 A CN 201910346501A CN 110175317 A CN110175317 A CN 110175317A
- Authority
- CN
- China
- Prior art keywords
- data
- txt
- text
- excel
- information
- 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
- 238000000034 method Methods 0.000 title claims abstract description 23
- 238000006243 chemical reaction Methods 0.000 claims abstract description 24
- 239000000284 extract Substances 0.000 claims description 5
- 238000000926 separation method Methods 0.000 claims description 4
- 230000009467 reduction Effects 0.000 abstract description 5
- 230000001360 synchronised effect Effects 0.000 abstract description 4
- 238000013507 mapping Methods 0.000 description 3
- 230000008676 import Effects 0.000 description 2
- 230000008569 process Effects 0.000 description 2
- 238000010586 diagram Methods 0.000 description 1
- 230000006872 improvement Effects 0.000 description 1
- 230000004048 modification Effects 0.000 description 1
- 238000012986 modification Methods 0.000 description 1
- 238000012545 processing Methods 0.000 description 1
- 238000012876 topography Methods 0.000 description 1
Classifications
-
- G—PHYSICS
- G06—COMPUTING; CALCULATING OR COUNTING
- G06F—ELECTRIC DIGITAL DATA PROCESSING
- G06F40/00—Handling natural language data
- G06F40/10—Text processing
- G06F40/12—Use of codes for handling textual entities
- G06F40/151—Transformation
Landscapes
- Engineering & Computer Science (AREA)
- Theoretical Computer Science (AREA)
- Health & Medical Sciences (AREA)
- Artificial Intelligence (AREA)
- Audiology, Speech & Language Pathology (AREA)
- Computational Linguistics (AREA)
- General Health & Medical Sciences (AREA)
- Physics & Mathematics (AREA)
- General Engineering & Computer Science (AREA)
- General Physics & Mathematics (AREA)
- Document Processing Apparatus (AREA)
Abstract
The present invention relates to a kind of txt batches to turn the data method of Excel, specifically includes the following steps: extracting the information of a variety of different attributes from Surveying Engineering design software, the information of a variety of different attributes generates multiple txt format text files；Every different attribute information branch arranges, and uses separators between the txt text of different attribute information；Excel software is opened, txt text data is obtained by data options function；Data conversion of the txt text of importing from data source to datum target, it is replicated by the data from data source to datum target, or give datum target default settings, or it writes data conversion script and is converted, switching motion is realized after the completion of data conversion, and data information is transmitted to hardware device.The present invention can be realized the batch between any txt formatted data and Excel data text conversion with it is synchronous significantly improved so that later stage work personnel summarize reduction operating efficiency.
Description
Technical field
The present invention relates to Surveying Engineering software development and applied technical fields, turn Excel more particularly, to a kind of txt batch
Data method.
Background technique
When mapping operations personnel's operation, it is frequently encountered field operation measuring device export performance data and needs to carry out secondary editor
With the collect statistics of data；Most of Surveying Engineering software (mainly includes CAD basic software, CASS software, GPS number at present
According to processing software etc.) format is exported from instrument is the formats such as dat/txt/csv for multiple groups or multiple data, single text is compiled
Volume efficiency is lower, while when extracting from Surveying Engineering software a variety of different attribute information, can generate multiple txt format texts texts
Part, the later period need batch summarize arrange data processing it is very troublesome, it is low to summarize reduction operating efficiency.
Summary of the invention
The present invention for the technical problems in the prior art, provides the data method that a kind of txt batch turns Excel,
Using this method can be realized the batch between any txt formatted data and Excel data text conversion with it is synchronous so that the later period
Staff summarizes reduction operating efficiency and significantly improves.
The technical scheme to solve the above technical problems is that
A kind of txt batch turns the data method of Excel, comprising the following steps:
S1, it extracts data information: extracting the information of a variety of different attributes from Surveying Engineering design software, it is a variety of not belong to
Property information generate multiple txt format text files；
The separation of S2, txt text data: every different attribute information branch arranges, the txt text of different attribute information it
Between use separators；
S3, Excel obtain txt text data: opening Excel software, obtain txt textual data by data options function
According to；
S4, txt data text are converted to Excel: data conversion of the txt text of importing from data source to datum target,
By the data duplication from data source to datum target, perhaps gives datum target default settings or write data conversion foot
This is converted, and switching motion is realized after the completion of data conversion, and data information is transmitted to hardware device.
As the preferred of the embodiment of the present invention, in the step S2, the txt text derived from Surveying Engineering design software
Content each information is a line, and every information different attribute information separates with separator, and n row information is to n attribute information.
As the preferred of the embodiment of the present invention, the separator can for space, tab, English comma and point
Number.
As the preferred of the embodiment of the present invention, for be distributed in the identical txt text of attribute information that do not go together pass through it is soft
After part batch realizes merging, retain original format and information.
As the preferred of the embodiment of the present invention, in the step S2, using not between the txt text of different attribute information
The separator of same type is separated, in the step S3, can be to inhomogeneity during Excel obtains txt text
The txt of type separator is individually imported.
As the preferred of the embodiment of the present invention, in the step S4, switching motion is to extract number from txt text data
According to format, the format of the datum target as the data source to be imported records each word for including for every in txt text data
Section is corresponding with each field of specified table extracted in data format.
The invention has the following advantages:
1, txt batch of the present invention turns the data method of Excel, can be realized any txt format using this method
Between data and Excel data text batch conversion with it is synchronous so that later stage work personnel summarize reduction operating efficiency
It significantly improves.
2, txt batch of the present invention turns the data method of Excel, txt text derived from Surveying Engineering design software
Content each information is a line, and every information different attribute information separates with separator, n row information to n attribute information,
After the txt text of multiple uniform types realizes merging by software batch, retain original format and information, and be converted into easy volume
The excel format file collected, can greatly improve batch editing operating efficiency.
Detailed description of the invention
Fig. 1 is the structural schematic diagram for the data method that txt batch of the present invention turns Excel；
Specific embodiment
Following will be combined with the drawings in the embodiments of the present invention, and technical solution in the embodiment of the present invention carries out clear, complete
Site preparation description, it is clear that described embodiments are only a part of the embodiments of the present invention, instead of all the embodiments.It is based on
Embodiment in the present invention, it is obtained by those of ordinary skill in the art without making creative efforts every other
Embodiment shall fall within the protection scope of the present invention.
Shown in Figure 1, the embodiment of the present invention provides the data method that a kind of txt batch turns Excel, specifically includes following
Step:
It extracts data information: in the present embodiment, the information of a variety of different attributes is extracted from Surveying Engineering design software,
The information of a variety of different attributes generates multiple txt format text files, and in the present embodiment, the information of a variety of different attributes refers to
Wanted in same Surveying Engineering software or different Survey and map software according to the various information that Fundamental Geographic Information System topographic(al) feature generates
Element, including remote sensing image data, dimensional topography contextual data, fundamental geological frame data, location base data, administrative division number
According to, place name address date etc., the mapping information of different attribute is exported into multiple txt format text files by Survey and map software.
The separation of txt text data: in the present embodiment, will from Surveying Engineering design software derived txt format text
This every different attribute information carries out branch's arrangement, while using separators between the txt text of different attribute information.At this
In embodiment, derived txt content of text each information is a line, every information different attribute information in Surveying Engineering software
It is separated with separator, in this way, n row information is to n attribute information.In the present embodiment, the txt text of multiple same alike result types
After this realizes merging by software batch, retain original format and information, for the data statistic analysis in later period after merging in this way
It lays a good foundation with data conversion.
In the present embodiment, further the mapping information of different attribute is arranged in txt data text, it is different
Different types of separator is selected to classify between the txt text of attribute type, so that txt text is in derived process
In can carry out classification export, while the phenomenon that messy code will not occur during converting.In the present embodiment, the separation
Symbol can be space, tab, the comma of English and four kinds of one or more in branch.
Excel obtains txt text data: in the present embodiment, opening Excel software, is obtained by data options function
Txt text data.During txt data import, system default original data type, during importing, according to can
Individual data importing is carried out with the type of separator, all txt that different types of separator is separated can also be carried out
All import.
Txt data text is converted to Excel: data conversion of the txt text of importing from data source to datum target passes through
From data source to datum target data duplication, perhaps to datum target default settings or write data conversion script into
Row conversion, switching motion is realized after the completion of data conversion, and data information is transmitted to hardware device.In the present embodiment, it converts
Movement is extracts data format from txt text data, the format of the datum target as the data source to be imported, by txt text
Each field that every record includes in notebook data is corresponding with each field of specified table extracted in data format.In this reality
It applies in example, is setting in specific data conversion process from data source (txt data text) to the datum target (Excel needed
Data text) conversion logic need to select in specified data library if data source or datum target are the table in database
This table, after setting, the structure of the table is extracted from database by system, and all fields are shown on interface.Conversion
Logic includes: data duplication: directly being copied data in datum target from data source；Default settings: it is set to datum target
Set a default value；It writes conversion script: realizing flexible and changeable, complicated data conversion.When executing convert task, Ke Yishe
Fixed number is combined into unique value according to the group of a field or multiple fields in purpose table, to execute the update order in database
Operation, realization update the purpose of data in datum target table with the data in data source.
Txt batch of the present invention turns the data method of Excel, can be realized any txt format number using this method
According between Excel data text batch conversion with it is synchronous so as to summarize reduction operating efficiency bright by later stage work personnel
It is aobvious to improve, while txt content of text each information derived from Surveying Engineering design software is a line, every information different attribute
Information is separated with separator, and n row information is realized to the txt text of n attribute information, multiple uniform types by software batch
After merging, retain original format and information, and be converted into the excel format file of easy editor, batch can be greatly improved and compiled
Collect operating efficiency.
The foregoing is merely presently preferred embodiments of the present invention, is not intended to limit the invention, it is all in spirit of the invention and
Within principle, any modification, equivalent replacement, improvement and so on be should all be included in the protection scope of the present invention.
Claims (6)
1. the data method that a kind of txt batch turns Excel, which comprises the following steps:
S1, it extracts data information: extracting the information of a variety of different attributes from Surveying Engineering design software, a variety of different attributes
Information generates multiple txt format text files；
The separation of S2, txt text data: every different attribute information branch arranges, and uses between the txt text of different attribute information
Separators；
S3, Excel obtain txt text data: opening Excel software, obtain txt text data by data options function；
S4, txt data text are converted to Excel: data conversion of the txt text of importing from data source to datum target passes through
From data source to datum target data duplication, perhaps to datum target default settings or write data conversion script into
Row conversion, switching motion is realized after the completion of data conversion, and data information is transmitted to hardware device.
2. txt batch turns the data method of Excel according to claim 1, it is characterised in that: in the step S2, from
Txt content of text each information derived from Surveying Engineering design software is a line, and every information different attribute information separates
Symbol separates, and n row information is to n attribute information.
3. txt batch turns the data method of Excel according to claim 2, it is characterised in that: the separator can be sky
Lattice, tab, English comma and branch.
4. txt batch turns the data method of Excel according to claim 1, it is characterised in that: do not go together for being distributed in
After the identical txt text of attribute information realizes merging by software batch, retain original format and information.
5. the data method that the batch of the txt according to Claims 2 or 3 turns Excel, it is characterised in that: in the step S2,
It is separated between the txt text of different attribute information using the separator of different types, in the step S3, Excel
Obtain txt text during, can the txt to different type separator individually imported.
6. txt batch turns the data method of Excel according to claim 1, it is characterised in that: in the step S4, turn
Move and extracts data format as from txt text data, the format of the datum target as the data source to be imported, by txt
Each field that every record includes in text data is corresponding with each field of specified table extracted in data format.
Priority Applications (1)
| Application Number | Priority Date | Filing Date | Title |
|---|---|---|---|
| CN201910346501.8A CN110175317A (en) | 2019-04-26 | 2019-04-26 | A kind of txt batch turns the data method of Excel |
Applications Claiming Priority (1)
| Application Number | Priority Date | Filing Date | Title |
|---|---|---|---|
| CN201910346501.8A CN110175317A (en) | 2019-04-26 | 2019-04-26 | A kind of txt batch turns the data method of Excel |
Publications (1)
| Publication Number | Publication Date |
|---|---|
| CN110175317A true CN110175317A (en) | 2019-08-27 |
Family
ID=67690184
Family Applications (1)
| Application Number | Title | Priority Date | Filing Date |
|---|---|---|---|
| CN201910346501.8A Pending CN110175317A (en) | 2019-04-26 | 2019-04-26 | A kind of txt batch turns the data method of Excel |
Country Status (1)
| Country | Link |
|---|---|
| CN (1) | CN110175317A (en) |
Cited By (3)
| Publication number | Priority date | Publication date | Assignee | Title |
|---|---|---|---|---|
| CN110609990A (en) * | 2019-09-06 | 2019-12-24 | 趋新科技(北京)有限公司 | Method and system for editing structured data text based on artificial intelligence |
| CN111901159A (en) * | 2020-07-15 | 2020-11-06 | 中盈优创资讯科技有限公司 | Method and device for replacing equipment configuration ports in batches |
| CN114124861A (en) * | 2020-08-28 | 2022-03-01 | 腾讯科技（深圳）有限公司 | Message group sending method and device, computer equipment and storage medium |
Citations (4)
| Publication number | Priority date | Publication date | Assignee | Title |
|---|---|---|---|---|
| CN101393526A (en) * | 2008-10-16 | 2009-03-25 | 宁波玺玛克智能科技有限公司 | Data synchronization method capable of implementing programmable data conversion and file conversion function |
| US20120303642A1 (en) * | 2011-05-23 | 2012-11-29 | Gbs Corp. | Automated file-conversion system and process for a media-generation system |
| CN106951442A (en) * | 2017-02-15 | 2017-07-14 | 中国保险信息技术管理有限责任公司 | Data interactive method and device between a kind of heterogeneous database |
| CN109299051A (en) * | 2018-12-10 | 2019-02-01 | 浪潮(北京)电子信息产业有限公司 | A kind of performance data files management method and relevant apparatus |
-
2019
- 2019-04-26 CN CN201910346501.8A patent/CN110175317A/en active Pending
Patent Citations (4)
| Publication number | Priority date | Publication date | Assignee | Title |
|---|---|---|---|---|
| CN101393526A (en) * | 2008-10-16 | 2009-03-25 | 宁波玺玛克智能科技有限公司 | Data synchronization method capable of implementing programmable data conversion and file conversion function |
| US20120303642A1 (en) * | 2011-05-23 | 2012-11-29 | Gbs Corp. | Automated file-conversion system and process for a media-generation system |
| CN106951442A (en) * | 2017-02-15 | 2017-07-14 | 中国保险信息技术管理有限责任公司 | Data interactive method and device between a kind of heterogeneous database |
| CN109299051A (en) * | 2018-12-10 | 2019-02-01 | 浪潮(北京)电子信息产业有限公司 | A kind of performance data files management method and relevant apparatus |
Cited By (6)
| Publication number | Priority date | Publication date | Assignee | Title |
|---|---|---|---|---|
| CN110609990A (en) * | 2019-09-06 | 2019-12-24 | 趋新科技(北京)有限公司 | Method and system for editing structured data text based on artificial intelligence |
| CN110609990B (en) * | 2019-09-06 | 2023-02-07 | 趋新科技(北京)有限公司 | Method and system for editing structured data text based on artificial intelligence |
| CN111901159A (en) * | 2020-07-15 | 2020-11-06 | 中盈优创资讯科技有限公司 | Method and device for replacing equipment configuration ports in batches |
| CN111901159B (en) * | 2020-07-15 | 2023-04-07 | 中盈优创资讯科技有限公司 | Method and device for replacing equipment configuration ports in batches |
| CN114124861A (en) * | 2020-08-28 | 2022-03-01 | 腾讯科技（深圳）有限公司 | Message group sending method and device, computer equipment and storage medium |
| CN114124861B (en) * | 2020-08-28 | 2023-05-23 | 腾讯科技（深圳）有限公司 | Message mass-sending method, device, computer equipment and storage medium |
Similar Documents
| Publication | Publication Date | Title |
|---|---|---|
| CN110175317A (en) | A kind of txt batch turns the data method of Excel | |
| US6339836B1 (en) | Automated design partitioning | |
| CN101739390B (en) | Data transformation based on a technical design document | |
| CN110738037B (en) | Method, apparatus, device and storage medium for automatically generating electronic form | |
| CN112949276A (en) | Report generation method and device, electronic equipment and storage medium | |
| US20210011889A1 (en) | Concurrent enumeration of multiple hierarchies in a database environment | |
| US20080195377A1 (en) | Method, device, and program product for verifying translation in resource file | |
| Fitch et al. | Building the national historical geographic information system | |
| CN101996131A (en) | Automatic test method and automatic test platform for graphic user interface (GUI) based on x extensive makeup language (XML) packaging key word | |
| CN109766085B (en) | Method and device for processing enumeration type codes | |
| CN110674199B (en) | Method and device for converting csv format data into SEG-2 format data | |
| CN103473056A (en) | Automatic generation method for telemetering configuration files | |
| CN113609820A (en) | Method, device and equipment for generating word file based on extensible markup language file | |
| CN106096644B (en) | Method for measuring similarity and device based on probability workflow | |
| US7885933B2 (en) | Apparatus and system for analyzing computer events recorded in a plurality of chronicle datasets | |
| CN106991100A (en) | Data lead-in method and device | |
| WO2006136055A1 (en) | A text data mining method | |
| CN107451429A (en) | A kind of system of keyization analysis RNA data | |
| CN106021354A (en) | Establishment method of digital interpretation library of Dongba classical ancient books | |
| CN113204465A (en) | Micro-service extraction method based on execution tracking | |
| CN108319695A (en) | Power station fault data processing method, device, computer equipment and storage medium | |
| CN108133017A (en) | A kind of multi-data source acquisition configuration method and device | |
| CN113779953A (en) | Automatic document generation method and system | |
| CN116303641B (en) | Laboratory report management method supporting multi-data source visual configuration | |
| CN109917456B (en) | Method and system for quickly extracting seismic 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 | ||
| RJ01 | Rejection of invention patent application after publication |
Application publication date: 20190827 |
|
| RJ01 | Rejection of invention patent application after publication |