Replace Pioneer Home   All Examples   Free Download

 New request --free  RSS: Replace Pioneer Examples

961.Advanced search and replace -- How to search and replace text base on csv file column 1 and 2?

User: Rodrigo -- 2012-06-16          << 960  962 >>
Hits: 1546
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