| User: editor -- 2011-07-25 << 824 826 >> |
| Hits: 250 |
| Type: Advanced search and replace |
| Search all Advanced search and replace examples |
| Description: |
| How to search and replace words in specified column in csv file? For examples, replace all "good" with "EXCELLENT" only in second column. |
| Input Sample: |
| good,plain,good poor,good,good good,poor,good ... |
| Output Sample: |
| good,plain,good poor,EXCELLENT,good good,poor,good ... |
| Answer: |
| Hint: You need to Download and install "Replace Pioneer" on windows platform to finish following steps. |
| 1. ctrl-o open csv file 2. ctrl-h open 'replace' dialogue * set 'replace unit' to 'Word' * set 'Replace scope' to 'Line' * set 'Unit Number Filter' to 2 * set 'replace with pattern' to: ## click 'settings' page * set 'Word Delimiter' to 'Others', and set the following entry to a comma. 3. click 'Replace', done. |
Screenshot 1: Replace_Window |
Screenshot 2: Replace_Settings_Window |
Similar Examples: |
| How to search and replace text for specified occurrences with reg exp? (71%) How to add some number to the specific column in csv file? (67%) How to search and sum the numbers at specified position in a text file? (64%) How to search and replace text 'ReplaceMe' only in specified lines? (64%) How to search and replace multiple terms with 1 common term in text file? (63%) How to batch extract specified lines from a text file? (63%) How to replace one specified word with a sequence of words from a file? (62%) How to search and replace in multiple files base on user-defined mapping file? (61%) |
Check Demo of Advanced search and replace |
| Keywords: |
| good excel second delimiter unit number filter number filter csv settings comma setting replace all examples replace column csv column csv csv column search words words to replace words replace replace 2 words |