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: 325
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 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 replace the first 3 spaces into comma in each line of text? (58%)
How to change columns in each line to specified order in text file? (57%)
How to remove every other characters on each line of text? (57%)
How to reverse the order of characters in each line of text? (57%)
How to extract half of lines from a text file randomly? (56%)

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