Replace string in XML file with awk/sed with string from another


 
Thread Tools Search this Thread
Top Forums Shell Programming and Scripting Replace string in XML file with awk/sed with string from another
# 8  
Old 02-15-2016
Quote:
Originally Posted by cozzin
This works, but only for765101293;
.
.
.
Which is exactly what you requested.
Quote:
.
.
.
Then, the xml will be copied somewhere else and the next value should be put there.
.
.
.
Which is done - for each file2 entry, a new file is created in the cwd (as you did not specify anything else although requested to do by Don Cragun, and still don't)
Quote:
.
.
.
And so on; the xml will be overwritten everytime.
.
.
.
Overwritten?
# 9  
Old 02-15-2016
I'm sorry if I am not very clear. English is not my first language. I'll try again to explain. In my xml i want to replace the 7.. value. The new value comes from file2. Then I will copy the new Update.xml file to a different folder (let's say /home/XML). For the next line in file2, I will want to again modify UpdateOffer1.xml (this is what i meant by overwritten...) same as before (except that instead of 765101293, the value to be replaced will be 765003448). After the modification, I will again copy Update.xml to the folder. This needs to be done for all line in file2.
# 10  
Old 02-15-2016
Quote:
Originally Posted by cozzin
I'm sorry if I am not very clear. English is not my first language. I'll try again to explain. In my xml i want to replace the 7.. value. The new value comes from file2. Then I will copy the new Update.xml file to a different folder (let's say /home/XML). For the next line in file2, I will want to again modify UpdateOffer1.xml (this is what i meant by overwritten...) same as before (except that instead of 765101293, the value to be replaced will be 765003448). After the modification, I will again copy Update.xml to the folder. This needs to be done for all line in file2.
The script RudiC gave you does exactly what you want except that instead of creating file /home/XML/file1 and file2, it will create files named (for your sample data):
Code:
file_765003448
file_765885388
file_764034143
file_784478101
file_762568592
file_769765134
file_767200702
file_769550613
file_784914007
file_762333840

Didn't his script create these files for you?
Login or Register to Ask a Question

Previous Thread | Next Thread

10 More Discussions You Might Find Interesting

1. Shell Programming and Scripting

Replace string of a file with a string of another file for matches using grep,sed,awk

I have a file comp.pkglist which mention package version and release . In 'version change' and 'release change' line there are two versions 'old' and 'new' Version Change: --> Release Change: --> cat comp.pkglist Package list: nss-util-devel-3.28.4-1.el6_9.x86_64 Version Change: 3.28.4 -->... (1 Reply)
Discussion started by: Paras Pandey
1 Replies

2. Shell Programming and Scripting

Replace a string in a xml file

Hello, I have below xml file, I want to find line default-value and replace the string within quotes followed by default-value "moni/Websphere/". Replace moni/Websphere/ with monitor/AMQ/ <monitor> <name>WebsphereMqMonitor</name> <type>managed</type> <argument... (4 Replies)
Discussion started by: prince1987
4 Replies

3. Shell Programming and Scripting

sed or awk command to replace a string pattern with another string based on position of this string

here is what i want to achieve... consider a file contains below contents. the file size is large about 60mb cat dump.sql INSERT INTO `table1` (`id`, `action`, `date`, `descrip`, `lastModified`) VALUES (1,'Change','2011-05-05 00:00:00','Account Updated','2012-02-10... (10 Replies)
Discussion started by: vivek d r
10 Replies

4. Shell Programming and Scripting

sed or awk to replace a value in a certain line from another file containing a string

Hi experts, In my text file I have the following alot of lines like below. input.k is as follows. 2684717 -194.7050476 64.2345581 150.6500092 0 0 2684718 -213.1575623 62.7032242 150.6500092 0 0 *INCLUDE $# filename... (3 Replies)
Discussion started by: hamnsan
3 Replies

5. Shell Programming and Scripting

sed or awk to replace a value in a certain line containing a string

hi experts , I have an input like following. R sfst 1000.0000 $ new time step for mass scaled calculation R dt2ms -4.000E-7 $ friction value for blank R mue ... (10 Replies)
Discussion started by: hamnsan
10 Replies

6. Shell Programming and Scripting

replace (sed?) a string in file with multiple lines (string) from variable

Can someone tell me how I can do this? e.g: a=$(echo -e wert trewt ertert ertert ertert erttert erterte rterter tertertert ert) How do i replace the STRING with $a? I try this: sed -i 's/STRING/'"$a"'/g' filename.ext but this don' t work (2 Replies)
Discussion started by: jforce
2 Replies

7. Shell Programming and Scripting

replace (sed?) a single line/string in file with multiple lines (string) from another file??

Can someone tell me how I can do this? e.g: Say file1.txt contains: today is monday the 22 of NOVEMBER 2010 and file2.txt contains: the 11th month of How do i replace the word NOVEMBER with (5 Replies)
Discussion started by: tuathan
5 Replies

8. Shell Programming and Scripting

How to find a certain string in a file and replace it with a value from another file using sed/awk?

Hi Everyone, I am new to this forum and new to sed/awk programming too !! I need to find particular string in file1(text file) and replace it with a value from another text file(file2) the file2 has only one line and the value to be replaced with is in the second column. file 1: (assert (=... (21 Replies)
Discussion started by: paramad
21 Replies

9. Shell Programming and Scripting

Using sed to replace a string in file with a string in a variable that contains spaces

Hi, i call my shell like: my_shell "my project name" my script: #!/bin/bash -vx projectname=$1 sed s/'PROJECT_NAME ='/'PROJECT_NAME = '$projectname/ <test_config_doxy >temp cp temp test_config_doxy the following error occurres: sed s/'PROJECT_NAME ... (2 Replies)
Discussion started by: vivelafete
2 Replies

10. Shell Programming and Scripting

replace string in XML with sed

Greetings, I have an XML : file.xml <component> <name>abcd</name> <value>1234</value> </component> I am using sed to replace abcd with the desired value dynamically without knowing the actual value. sed 's/<name>./]\{1,\}<\/name>/<name>ijkl<\/name>/' file.xml > newfile.xml I... (6 Replies)
Discussion started by: chiru_h
6 Replies
Login or Register to Ask a Question