| User: editor -- 2011-07-25 << 824 826 >> |
| Hits: 3552 |
| 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 make search and replace only in specified lines in text file? (76%) How to search and replace text for specified occurrences with reg exp? (71%) How to batch replace files with specified format in each line? (70%) How to add some number to the specific column in csv file? (67%) How to extract specified columns from blocks of text? (64%) 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 replace the second column in a tab seperated file? (63%) |
Check Demo of Advanced search and replace |
| Keywords: |
| good cell excel second column delimiter unit number filter number filter second settings comma replace all examples search and replace column in a csv file column search and replace in csv specified words search replace csv csv search replace replace column csv column csv |