| User: Rachel Heartwood -- 2015-01-26 << 1276 1278 >> |
| Hits: 2813 |
| 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 |