Replace Pioneer Home All Examples Free Download

824.Advanced search and replace -- How to delete the second column in multiple text files?

User: mahdi -- 2011-07-21 << 823 825 >>

Hits: 3525

Type: Advanced search and replace

Search all Advanced search and replace examples

Description:

Hi
I have 1000 text files. Each file contains 2 columns. I do not need the second column and I want delete the second column in all my 1000 files.
Thanks

Input Sample:

23   43
23   3
12   6
34   2
62   3
76   8

Output Sample:

23
23
12
34
62
76

Answer:

Hint: You need to Download and install "Replace Pioneer" on windows platform to finish following steps.

1. open "Tools->Batch Runner" menu
2. drag 1000 files from "windows file browser" to "Batch Runner" window
3. click "Fast Replace" button to open "Fast Replace" window
* click "add" button to insert new rule:
* set "Search" to:

* set "Replace" to:

* click "ok"
4. make sure "Reg exp" option is selected, and click "Start", done!

Screenshot 1: Fast_Replace_Window

Similar Examples:

How to remove/delete first column for multiple files? (76%)
How to add filename as a new column for multiple csv/txt files? (75%)
How to extract the second column from a database text file? (75%)
How to replace a word only one time in multiple text files? (71%)
How to replace the second column in a tab seperated file? (70%)
How to extract the last non-blank line from multiple text files? (70%)
How to delete last column in a csv file? (68%)
How to insert a keyword only at first line of multiple text files? (67%)

Check Demo of Advanced search and replace

Keywords:

second column contains columns 2 columns second 100 how to delete delete insert delet delete second column in text files delete second column delete multiple columns delete columns from multiple files delete column in multiple files delete columns in text file delete columns delete column in text files