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 in 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
Huajun editor recommends:
Text data processing tool is a software that does not need to be learned to use. It is a very simple tool. Users in need can download and use it in the Huajun Software Park. You are guaranteed to be satisfied. In addition, there are many similar software of the same type available for download, such as:Wancai Office Master OfficeBox,Foxit PDF Suite Advanced Editor,Lizard Safeguard Secure PDF Viewer,XML Explorer(XML Editor),Sante CT Viewerwait.
it works
it works
it works