Replace Pioneer Home   All Examples   Free Download

 New request --free  RSS: Replace Pioneer Examples

1256.Advanced search and replace -- How to update values in xml file according to values from another xml?

User: Dilip -- 2014-09-29          << 1255  1257 >>
Hits: 2944
Type: Advanced search and replace   
Search all Advanced search and replace examples
Description:
I have to map two xml files: File1.xml has correct primary_value, but may have incorrect language value, For example: 
While first record with primary value Dext is correct along with spanish and  
english, the second record Prank has bad language values.  
I have another xml file with corrected values in File2.xml 
How to update language values of File1.xml by the value from File2.xml
Input Sample:
File1.xml 
<values> 
<primary_value>Dext</primary_value> 
<spanish>Dext</spanish> 
<english>Dext<english></values> 
<values> 
<primary_value>Prank</primary_value> 
<spanish>Pink</spanish> 
<english>Pank</english></values> 
 
File2.xml 
<values> 
<primary_value>Prank</primary_value> 
<spanish>Prink</spanish> 
<english>Prank</english></values>
Output Sample:
<values> 
<primary_value>Dext</primary_value> 
<spanish>Dext</spanish> 
<english>Dext</english></values> 
<values> 
<primary_value>Prank</primary_value> 
<spanish>Prink</spanish> 
<english>Prank</english></values>
Answer:
Hint: You need to Download and install "Replace Pioneer" on windows platform to finish following steps.
1. ctrl-o open File2.xml 
2. ctrl-h open 'replace' dialogue 
* set 'search for pattern' to: 
 
* click 'advanced' tab 
* set 'run following at the beginning of replace' to: 
 
* set 'run following for each matched unit' to: 
 
3. click 'replace', primary_value of file2.xml will be imported to system dictionary 
 
4. ctrl-o open File1.xml 
5. ctrl-h open 'replace' dialogue 
* set 'search for pattern' to: 
 
* set 'replace with pattern' to: 
 
* set 'if=>' to: 
 
6. click 'replace', done.

Screenshot 1:  Replace_Window


Screenshot 2:  Replace_Advanced_Window


Screenshot 3:  Replace_Window


Similar Examples:
How to extract from a file according to content of another file? (67%)
How to split a csv file according to the value of column A? (65%)
How to substract one csv file from another according to value of column A? (60%)
How to split a CSV file with Header according to value of  column B? (59%)
How to split a CSV file with Header according to value of a column? (59%)
How to replace one part of html with corresponding part from another? (58%)
How to fill in one xml file with elements from another xml file? (55%)
How to move all files whose names are ended with numbers to another folder? (55%)

Check Demo of Advanced search and replace
Keywords:
language  span  xml files  xml  xml file  english  dictionary  diction  system  record  xml files search and replace  xml search replace  xml search and replace  files dictionary  replace xml  first two  the first two  two files