Replace Pioneer Home   All Examples   Free Download

 New request --free  RSS: Replace Pioneer Examples

431.Advanced search and replace -- How to insert two columns into a database file separated by "|"?

User: editor -- 2010-02-25          << 430  432 >>
Hits: 2931
Type: Advanced search and replace   
Search all Advanced search and replace examples
Description:
How to insert two columns into a database file separated by "|"?
Input Sample:
01|02|03|04|05|06 
11|12|13|14|15|16 
21|22|23|24|25|26
Output Sample:
01|02|aaaa|03|04|bbbb|05|06 
11|12|aaaa|13|14|bbbb|15|16 
21|22|aaaa|23|24|bbbb|25|26 
Answer:
Hint: You need to Download and install "Replace Pioneer" on windows platform to finish following steps.
*** Note *********** 
Following procedure require Replace Pioneer 2.52 and above, if you has 2.51 and earlier version, please upgrade to new version or modify below procedure. 
*** Note *********** 
  
1. ctrl-o open source text file 
2. ctrl-h open 'Replace' window 
* set 'Replace Unit' to 'Line' 
* in 'search for pattern', enter: 
 
* in 'replace with pattern', enter: 
 
3. click 'Replace', done! 
4. ctrl-s save to file
Download Script:  scripts/431.rst.zip

Screenshot 1:  Replace_Window


Similar Examples:
How to extract specified columns from a large pipe separated csv file? (60%)
How to merge two columns of a CSV file? (57%)
How to extract the second column from a database text file? (57%)
How to batch split files into columns that separated by comma? (56%)
How to extract 3,4,5th columns from csv file and replace comma with space? (54%)
How to batch insert the filename into the beginning of the file conent? (54%)
How to merge more columns into one column in multiple csv files? (53%)
How to sort all the lines of a text file randomly? (53%)

Check Demo of Advanced search and replace
Keywords:
aaaa  database  aaa  separate  two  columns  version  rsi  how to insert  insert  insert search into database  text to database  text to columns open source  two text  text columns  text to columns  insert text file  file insert