| User: mybox65 -- 2017-12-12 << 1410 1412 >> |
| Hits: 3536 |
| Type: Text generator |
| Search all Text generator examples |
| Description: |
| A template file as a searching resource, using the first line of Excel as the searching keyword to search the template file, Once matched, use the second line of excel one to one to replace it, for example: Cow -change to-> pig, sheep -chang to-> Pigeon, fish -change to-> horse; save it as a file when it is done, then re-search again by the first line of Excel and replace it with the third line. cow -> rat, sheep-> wolf, fish-> parrot... |
| Input Sample: |
| Template file: I like cow, elephant and donkey, but I only eat sheep and fish. clock timezone AST -4 0 Excel file: first line: cow | sheep | fish | elephant | Atlantic second line: pig | pigeon | horse | mouse | Central third line: rat | wolf | parrot | lion | Mountain forth line:..... ... |
| Output Sample: |
| Output pig.txt: I like pig, mouse and donkey, but I only eat pigeon and horse. clock timezone CST -6 0 Output rat.txt I like rat, lion and donkey, but I only eat wolf and parrot. clock timezone MST -7 0 |
| Answer: |
| Hint: You need to Download and install "Replace Pioneer" on windows platform to finish following steps. |
| 0. put template.txt to folder of d:\test\ 1. save excel file to a csv file like: 2. ctrl-o open this csv file 3. ctrl-h open replace dialog. *set 'replace unit' to 'Line' *set 'replace with pattern' to: * click 'advanced' tab, set 'run following at begin' to: * set 'run following for each' to: 3. click 'replace', done. |
Screenshot 1: Replace_Window |
Screenshot 2: Replace_Advanced_Window |