Text data processing tools

The latest version of the text data processing tool is a comprehensive and practical tool that is widely used in text data processing. Users of the latest version of the text data processing tool can merge and split text data, and can also manage their own account passwords and other texts. The official version of the data processing tool supports extracting numbers in text, merging two texts for extraction, sequential extraction as required, and supports operations such as modifying content and replacing characters.

Introduction to the functions of text data processing tools

Function 1: Extract specified columns in data 1 or data 2

Sometimes we need to extract certain columns from the account text. For example: username----password----payment password----mobile phone----email----email password, we only need to export: username----password----payment password , then we only need to check the ①②③ columns of data 1.

Sometimes we need to merge and extract certain columns in two text files in one-to-one correspondence. For example, data 1: province----city----district----street----mobile phone number; data 2: account number----password----mobile phone number. We need to replace the mobile phone number in data 1 with the mobile phone number in data 2.

Function 2: Association matching extraction of specified columns of data 1 and data 2

Sometimes we need to match and merge two texts according to specified columns. For example, data 1: user name ---- password ---- mobile phone ---- email; data 2: email ---- email password. Here we need to match the email address in data 1 with the email address in data 2, and then merge them together to extract: username----password----email----email password, without extracting the mobile phone.

Function 3: Extract the items that exist in the specified column in data 1 and in the specified column in data 2

Sometimes we need to extract items that exist in both data 1 and data 2. For example, data 1: username----password----payment password; data 2: username----password. Here we match according to the user name column. As long as the user name in data 1 exists in the user name column in data 2, the result will be output. (Here I only demonstrate single-column matching. In fact, multi-column matching search is also supported.)

Function 4: Extract items in the specified column in data 1 that do not exist in the specified column in data 2

Sometimes we need to extract items that do not exist in data 1 and data 2. For example, data 1: username----password----payment password; data 2: username----password. Here we match according to the user name column. As long as the user name in data 1 does not exist in the user name column in data 2, the result will be output. (Here I only demonstrate single-column matching. In fact, multi-column matching search is also supported.)

Function 5: Extract items with a certain keyword in the specified column in data 1

Sometimes we need to extract items with a certain keyword in certain columns in data 1. For example: username----password----winning result. Here we want to extract the items with the keyword "cash coupon" in the winning result column.

Function 6: Extract items that meet numerical conditions in a column of data 1

Sometimes we extract items in a column in data 1 that meet a certain numerical condition. For example: username----password----coupon face value. Here we want to extract items with a coupon value greater than or equal to 50.

Function 7: Rearrange the order of columns in data 1

Sometimes we need to adjust the order of some columns in data 1. For example: username----password----mobile phone----email----email password. Here we want to put the mobile phone in the last column. Original order: 123456. Here, the third column is placed in the last five columns, the fourth column is placed in the third column, the fifth column is placed in the fourth column, and the last column remains unchanged without or unchanged. The adjusted order is: 124536.

How to install text data processing tools

Download the official version of the text data processing tool software package from Huajun Software Park

​ ​Extract to the current folder

​ ​Double-click to open the application in the folder

This software is green software and can be used without installation.

Text data processing tool update log

​ 1. Optimized some functions

​ 2. Solved many unbearable bugs