Script data extraction method and device, computer equipment and storage medium

Abstract

The invention relates to a script data extraction method and device, computer equipment and a storage medium. The method comprises the following steps of obtaining script data, extracting regular expression rule logic corresponding to the script data; generating a regular expression based on regular expression rule logic, extracting bottom data and an output result field of the script data according to the regular expression, and outputting the extracted bottom data and the output result field to a data set corresponding to a preset filename matching model according to the preset filename matching model. By the adoption of the method, only regular expression rule logic needs to be obtained, specific extension of the regular expression can be constructed to obtain successful matching, and bottom layer data and output result fields contained in script data are rapidly found out from a large amount of script data. A large amount of manpower is saved for searching data, the data quality problem caused by missing of manual searching is greatly avoided, the data extraction efficiency is improved, and the auditing work difficulty is reduced.

Description

technical field [0001] The present application relates to the technical field of power grids, in particular to a script data extraction method, device, computer equipment and storage medium. Background technique [0002] With the development of information technology, electronic business flow, capital flow and information flow have gradually become the mainstream of data audit work, and massive data audit needs the support of information technology and big data. Among them, the marketing domain audit model involves a large number of source tables and model output data sets, and there are huge workload challenges in the matching, extraction and integration of related tables and data sets. There are too many scripts involved in the marketing domain of the power grid industry, and the correlation between scripts is also relatively complicated, which also contains multiple pseudo-tables. [0003] At present, the traditional marketing domain audit model source table and result i...

AI Technical Summary

Problems solved by technology

[0004] The above data extraction methods rely on manual data extraction, which not only consumes a lot of manpower and time, but if there is a lack of table or a wrong name of the table, it will lead to errors in the data extraction results and seriously affect the data quality. It can be seen that the traditional There is a problem of low data extraction efficiency in the extraction method of audit model source table and result integration

Images