Replace Pioneer Home   All Examples   Free Download

 New request --free  RSS: Replace Pioneer Examples

1411.Text generator -- How to generate a list of sentences from template sentence?

User: mybox65 -- 2017-12-12          << 1410  1412 >>
Hits: 1550
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


Similar Examples:
How to generate a list of strings with sequence id decreased? (65%)
How to generate a list of web pages with 2 numbers increased in sequence? (64%)
How to generate a list of picture names and put into a csv file? (63%)
How to insert lines between sentences with specified order? (58%)
How to generate a csv file from a template file and a list of words? (57%)
How to generate the full list of 2 letter combinations? (57%)
How to generate a full list of hours minutes seconds.html in a day? (56%)
How to generate a random binary sequence matrix? (56%)

Check Demo of Text generator
Keywords:
third  chin  sentences  excel  keyword  sentence  key  second line  template  values  txt to csv split  csv and template replace  split keyword  save as excel  replace sentences  csv file split line  keyword line  pattern search replace template