Replace Pioneer Home   All Examples   Free Download

 New request --free  RSS: Replace Pioneer Examples

825.Advanced search and replace -- How to search and replace words in specified column in csv file?

User: editor -- 2011-07-25          << 824  826 >>
Hits: 1900
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