In the work of text and data cleaning, Notepad files sometimes need to quickly find and delete an entire line of text containing specified keyword words. For example, delete all keywords containing [ERROR] in the log generated by the system to simplify the log file; Delete all entire lines containing [test] from the results of data export; or delete all lines containing the [resigned] tag from all contact lists. Generally, we can only open each file and use search and replace to search for keywords, and then directly delete the entire line of text containing the keywords. Even if there are not many files, there will still be fatigue caused by repeated operations, not to mention facing dozens to hundreds of files.
So in this case, how should we directly find out all the specific keywords in the TXT file, and then delete the entire line of text with this keyword? Here to introduce a few immediate methods, just a few steps can be quickly solved, and I understand how to operate it!
When do you want to use a word in a TXT file to delete an entire line of text that contains that word?
Clean up file data
when processing TXT files, there are often many error prompts or duplicate records mixed in the files. These contents usually contain a common word and keyword as identification. Instead of searching line by line, it is better to directly use this word as the basis to delete the entire line of text containing it, so as to quickly clean up the files and keep only the really useful information.
Delete superfluous information
some TXT text is exported from the system and equipment, which will contain valid and invalid data, which are mixed together. The content of invalid data usually has fixed words such as test and failure. By judging whether a line contains the specified word and deleting the whole line, the screening work can be completed very efficiently. Compared with manual deletion, it is much simpler and not easy to miss the problem.
Prevent human error
when the notepad file has a lot of content and tens of thousands of lines, manually finding and deleting lines containing a certain word will not only take too much time, but also be prone to accidentally deleting or missing several lines without deleting. If you are not careful, you will also delete useful information, resulting in subsequent data not being right. Using the method of deleting the entire row by keyword can ensure uniformity and stable results. After the batch operation is completed, the file content will be cleaner and the structure will be clearer.
According to the keyword in the TXT file, delete an entire line of text containing the keyword effect preview.
Before treatment:
after treatment:
method 1: Use HeSoft Doc Batch Tool Batch delete complete lines from TXT file
recommended Index:★★★★★
Advantages:
- the operation is simple, only need to enter the keyword to complete the batch deletion of the entire line of text with the keyword, and hundreds of 10. of documents can be quickly completed in batches, but also supports Word, PDF and other file formats.
- All files are processed locally and will not be required to upload files to protect the privacy of users.
Disadvantages:
- only software can be installed to operate in a computer.
Operation steps:
1. Open 【 HeSoft Doc Batch Tool ], select [Text Tool]-[Find and replace complete lines in text files based on keywords]].
2. Select a method in [Add File] or [Import File from Folder] to import the TXT file that needs to delete text lines, or drag the file directly to the bottom. After confirming that there is no problem with the file, click Next.
3. Enter the setting option interface, select [Accurate Text Search] for the search method, then enter the keywords contained in the row below the keyword list found below, leave blank below the replaced keyword list on the right, do not enter, and finally click Next again. Then click Browse and select a location to save the new file.
4. After waiting for the processing to end, click the red path to open the file to view and delete the entire line of successful TXT text file containing the keyword.
Method 2: Batch delete using Notepad
recommended Index:★★★☆ ☆
advantages:
- the operation is simple and intuitive, and the results can be viewed in real time to avoid accidental deletion.
- Supports multiple encodings and the ability to open multiple files simultaneously for batch processing.
Disadvantages:
- the response may be slow when processing text files larger than 100MB.
- Although free processing, but still need to open the installation.
Operation steps:
1. Use the Notepad to open the TXT file and press Ctrl F to open the search.
2. Select [Mark], enter the keywords to be found, check [Bookmark Line], and finally click [All Marks] to delete.
Method 3: Use the Excel filter function to batch delete the complete line of TXT containing the keyword
recommended Index:★★★☆ ☆
advantages:
- Excel everyone can basically operate, very familiar with general, small white can also handle.
- It can be previewed and then deleted, which is very suitable for structured text.
Disadvantages:
- plain text using Excel is a bit of a waste of human resources.
- More complex formats can be confused.
Operation steps:
1. Use Excel to open the TXT file, and the data will be automatically displayed in columns.
2. Find [Data] and click the [Filter] button.
3. Enter keyword screening.
4. Delete the filtered rows and save them as TXT.
