| User: Rodrigo -- 2012-06-16 << 960 962 >> |
| Hits: 3616 |
| Type: Advanced search and replace |
| Search all Advanced search and replace examples |
| Description: |
| I'd like to search and replace a text content based in content of csv file, where column 1 is the search string and column 2 is the replace string. Ex. of CSV file: (column 1,column 2) 388,10 577,99 903,61 xxx,yyy |
| Input Sample: |
| Text content 388,577,903,388,xxx 903,388,577,577,903 xxx 388 |
| Output Sample: |
| Text content (output) 10,99,61,10,yyy 61,10,99,99,61 yyy 10 |
| Answer: |
| Hint: You need to Download and install "Replace Pioneer" on windows platform to finish following steps. |
| 1. open "Tools->Batch Runner" window 2. drag the text files to the "Batch Runner" window 3. click "Fast Replace" button open "Fast replace" dialog * click "import" to import csv files as search replace rules, the first column should be search strings and the second column should be replace strings 4. click "start", done. |
Similar Examples: |
| How to search/replace multiple text files base on rules from csv file? (66%) How to search and replace text 'ReplaceMe' only in specified lines? (62%) How to search and replace words in specified column in csv file? (61%) How to search and replace in multiple files base on user-defined mapping file? (59%) How to merge two text file base on the value of first column and do sort? (59%) How to search and replace text for specified occurrences with reg exp? (57%) How to search and replace multiple file with multiple regex rules? (56%) How to batch replace files and save the result to new files? (56%) |
Check Demo of Advanced search and replace |
| Keywords: |
| second column xxx replace strings strings csv files first column import rules second csv replace text file based on rules csv first column replace first string based on first string search and replace text in csv files search replace text in csv column strings files |