Replace Pioneer Home   All Examples   Free Download

 New request --free  RSS: Replace Pioneer Examples

691.Text file parser -- How to extract column 3,6,7,8 from each line of text?

User: editor -- 2011-01-05          << 690  692 >>
Hits: 2037
Type: Text file parser   
Search all Text file parser examples
Description:
How to extract column 3,6,7,8 from each line of text?
Input Sample:
A1 A2 A3 A4 A5 A6 A7 A8 A9 
B1 B2 B3 B3 B5 B6 B7 B8 B9 B10 
...
Output Sample:
A3 A6 A7 A8 
B3 B6 B7 B8 
...
Answer:
Hint: You need to Download and install "Replace Pioneer" on windows platform to finish following steps.
1. ctrl-o open source text file 
2. ctrl-h open replace window 
* set 'replace unit' to 'Line' 
* set 'replace with pattern' to: 
 
3. click 'replace', done! 
 
Note:  
* if the file is csv file, you can use "," as delimiter: 
 
* Replace Pioneer 2.6 or newer version is required 

Screenshot 1:  Replace_Window


Similar Examples:
How to extract the forth column in the second line from different files? (64%)
How to extract specified columns from blocks of text? (62%)
How to extract all odd columns 1,3,5,... from a text file? (62%)
How to delete the first word in each line in a text file? (60%)
How to extract the second column from a database text file? (59%)
How to remove duplicate column in each line? (58%)
How to extract 3 lines from each file randomly? (58%)
How to replace the first 3 spaces into comma in each line of text? (58%)

Check Demo of Text file parser
Keywords:
extract column  extract colum  delimiter  csv  version  rsi  text file parser  file parser  parser  parse  extract column from csv  csv extract column  extract column csv  extract csv  csv file replace text from file  replace from csv  extract each line  csv from