|User: Rachel Heartwood -- 2015-01-26 << 1276 1278 >>|
|Type: Advanced search and replace|
|Search all Advanced search and replace examples|
|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:
List of words to analyze:
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.
|Football218 - Not found |
Random341 - Not found
Apples85 - Apple
Applesandpears21 - Apple Pear
GreatPears214 - Pear
|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