| User: editor -- 2010-02-25 << 430 432 >> |
| Hits: 381 |
| 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 the second column from a database text file? (57%) How to batch split files into columns that separated by comma? (56%) 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%) How to extract multiple fields from data file and create a csv file? (52%) How to convert columns of data into SQL statement for mysql database? (52%) How to merge every two lines into one line between (part1) and (partn)? (52%) |
Check Demo of Advanced search and replace |
| Keywords: |
| aaaa database aaa columns para insert tab version rsi data insert search into database file insert insert text replace enter in text file search and replace open source replace if if replace search and replace text |