Replace Pioneer Home   All Examples   Free Download

 New request --free  RSS: Replace Pioneer Examples

1277.Advanced search and replace -- How to find out in each line which words in the list appear?

User: Rachel Heartwood -- 2015-01-26          << 1276  1278 >>
Hits: 1360
Type: Advanced search and replace   
Search all Advanced search and replace examples
Description:
How do I find where words from one list appear in another list, given that
the words may be part of random phrases, then mark where they were found in
a new column (comma or tab delimited)?

List of words to find:
Apple
Pear
Banana

List of words to analyze:

Ilovepears
Iloveapplesandpears
Banana
Apple123

I'd like to mark rows in an Excel file (or CSV) to show when a word like
Apple is found in Apple123, and when multiple words are found, like Apple
and Pear in Iloveapplesandpears.
Input Sample:
Football218
Random341
Apples85
Applesandpears21
GreatPears214
Output Sample:
Football218 - Not found
Random341 - Not found
Apples85 - Apple
Applesandpears21 - Apple  Pear
GreatPears214 - Pear
Answer:
Hint: You need to Download and install "Replace Pioneer" on windows platform to finish following steps.
Assume the file d:\test\words.txt contains the list of words.
1. ctrl-o to open the source csv or txt file which has one column
2. ctrl-h open 'replace' dialogue
* set 'replace unit' to 'Line'
* set 'replace with pattern' to:

* click 'advanced' tab
* set 'run following at the beginning of replace' to:

* set 'run following for each matched unit' to:

3. click 'replace', done.

Note: you should use double backslash as folder delimiter in step 2 like d:\\test\\words.txt

Screenshot 1:  Replace_Window


Screenshot 2:  Replace_Advanced_Window


Similar Examples:
How to find from an article all words not appeared in a word list? (60%)
How to add a number in each line indicating number of words in this line? (59%)
How to find out all files that contain all words of A, B and C? (58%)
How to extract all lines that contain words in a list? (57%)
How to findout all lines that contain specified words in multiple files? (57%)
How to find which words or phrases in a dictionary appearred in an article? (56%)
How to change columns in each line to specified order in text file? (56%)
How to extract lines with specific words in first column? (55%)

Check Demo of Advanced search and replace
Keywords:
tab delimited  phrases  delimited  keys  given  mark  excel  give  123  phrase  find and replace multiple words  random dictionary  replace word with a random word from a list  csv find replace column  random word from a list  use word dictionary file  find and replace in csv file  replace multiple words to words in a csv