Replace Pioneer Home   All Examples   Free Download

 New request --free  RSS: Replace Pioneer Examples

676.Advanced search and replace -- How to extract the 7th column from text files with 8 columns?

User: maadi -- 2010-12-11          << 675  677 >>
Hits: 2627
Type: Advanced search and replace   
Search all Advanced search and replace examples
Description:
I have mutliple text files. each one containes 8 columns. I want to delete all but 7th column. In other words I want my files only contain 7th column.  
How can I do that with batch runner?
Input Sample:
11 4 77 78 6 86 76 90
Output Sample:
76
Answer:
Hint: You need to Download and install "Replace Pioneer" on windows platform to finish following steps.
1. open "Tools->Batch Runner" window 
2. drag multiple files from Windows to "Batch Runner" window 
3. click "Fast Replace" button 
* click "Add" to add a rule: 
* in "search", enter: 
 
* in "replace", enter: 
 
* click "OK" 
4. Make sure "Regular exp" and "Cross Line" options are selected, click "Start"

Screenshot 1:  Fast_Replace_Window


Similar Examples:
How to delete the 4th column from text files with 8 columns? (88%)
How to extract 5 unique lines from a text file with 30 lines? (70%)
How to replace the 4th column if the 5th column is 0? (67%)
How to extract 3,4,5th columns from csv file and replace comma with space? (66%)
How to extract half of lines from a text file randomly? (66%)
How to extract the second column from a database text file? (66%)
How to extract all odd columns 1,3,5,... from a text file? (65%)
How to extract line if the 1st column is "a2" and the 2nd column is "b2"? (63%)

Check Demo of Advanced search and replace
Keywords:
7th column  columns  delete all  cross line  delete  delet  dele  rule  how to extract  regular  batch delete columns in text files  delete multiple columns  delete columns from multiple files  extract column in text batch  batch extract column from text  batch extract column  delete column in multiple files  delete columns