Replace Pioneer Home   All Examples   Free Download

 New request --free  RSS: Replace Pioneer Examples

1385.Text file parser -- How to extract specified columns from blocks of text?

User: jnjnjnjnjnjn -- 2016-12-26          << 1384  1386 >>
Hits: 404
Type: Text file parser   
Search all Text file parser examples
Description:
How to extract specified columns from blocks of text?
Input Sample:
a1 ( a2-a3 )
 a4
 a5
 a6 a7 a8       a9 a10 a11 a12 a13 a14

 a15 a16 a17 a18 a19 a20 a21
 b1 b2 b3 b4 b5 b6 b7
 b8 b9 b10 b11 b12 b13 b14
 b15 b16 b17 b18 b19 b20 b21

a1 ( a2-a3 )
 a4
 a5
...
Output Sample:
a2|a3|a4|a8|a11|a1|b1|b2|b3|b4|b5|b6|b7
a2|a3|a4|a8|a11|a1|b8|b9|b10|b11|b12|b13|b14
a2|a3|a4|a8|a11|a1|b15|b16|b17|b18|b19|b20|b21
...
Answer:
Hint: You need to Download and install "Replace Pioneer" on windows platform to finish following steps.
1. ctrl-o open text file
2. ctrl-h open 'replace' dialogue
* set 'replace unit' to 'Paragraph'
* set 'replace with pattern' to:


* click 'settings' tab:
* set 'Para start' to 'other':

* set 'Para end' to 'None'
3. click 'replace', done.

Screenshot 1:  Replace_Window


Screenshot 2:  Replace_Settings_Window


Similar Examples:
How to batch extract specified lines from a text file? (72%)
How to extract the second column from a database text file? (70%)
How to extract all specified links from a html file? (69%)
How to extract specified lines in different section of text file? (67%)
How to extract specified columns from a large pipe separated csv file? (67%)
How to extract all specified date format from a text file? (67%)
How to extract specified text followed by 8 digits from text file? (66%)
How to extract all specific links from webpage? (65%)

Check Demo of Text file parser
Keywords:
blocks of text  blocks  block  non  paragraph  paragra  columns  settings  map  setting  split file columns  split text file columns  extract columns  split columns text file  split text file to columns  extract 10 lines  text file split to columns  text file split columns