| User: editor -- 2010-02-25 << 430 432 >> |
| Hits: 3272 |
| 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 |