07-13-2011
Need help in using sed/awk for line insertion in xml
Hello,
I have two text files (txt1 and txt2). txt1 contains many lines with a single number in each line. txt2 (xml format) contains information about the numbers given in txt1. I need to insert one line in txt2 within the scope of each number taken from txt1.
Sample problem:
txt1:
12
23
45
67
78
txt2:
<id = "ab">
<>
<"add text here!!!">
</holder>
<>
<num = "12">
<>
<>
<>
<id = "bc">
<>
<"add text here!!!">
</holder>
<>
<num = "78">
<>
<>
<>
<id = "cd">
<>
<>
<>
<"dont add since 90 is not in the txt1">
</holder>
<num = "90">
<>
<>
hope i have not confused much..
---------- Post updated at 04:05 PM ---------- Previous update was at 04:03 PM ----------
so within the scope of each number place the text above the line </holder> for all the numbers present in txt1.
---------- Post updated at 04:11 PM ---------- Previous update was at 04:05 PM ----------
I have been able to insert the line above all the </holder> in the file... But I am stuck when I am matching the numbers from txt1 and inserting into txt2 into a specific location.....
here's the code I used to insert above all lines having </holder>
sed '/</\Holder>/i\<TEXT INSERTED>' filename
10 More Discussions You Might Find Interesting
1. Shell Programming and Scripting
Hi people!,
I need extract from the file (test-file.txt) the values between
<context> and </context> tag's , the total are 7 lines,but i can only get 5 or 2 lines!!:confused:
Please look my code:
#awk '/context/{flag=1} /\/context/{flag=0} !/context/{ if (flag==1) p
rint $0; }'... (3 Replies)
Discussion started by: ricgamch
3 Replies
2. Shell Programming and Scripting
Hi, I want to get data from Xml file by using sed or awk command. I want to get the following result :
mon titre 1;Createur1;Dossier1
mon titre 1;Createur1;Dossier1
and save it in cvs file (fichier.cvs).
FROM this Xml file (test.xml):
<playlist version="1">
<trackList>
<track>... (1 Reply)
Discussion started by: yeclota
1 Replies
3. Shell Programming and Scripting
Hi ,
This is my first thread ; facing some issues withmy sed script
I need to insert the code from my log file which is between two keywords.
content is like this ........
log
############################
log1 log2
231 "Ban" "tom" and the line one of the cross line
friend... (2 Replies)
Discussion started by: shalini_008
2 Replies
4. Shell Programming and Scripting
I have a file called config.xml, it's a simple xml file, and I need use sed/awk to erase some lines.
<machine xsi:type="unix-machineType">
<name>server1</name>
<node-manager>
<name>server1</name>
<listen-address>server1</listen-address>
</node-manager>
... (3 Replies)
Discussion started by: cbo0485
3 Replies
5. Shell Programming and Scripting
Hello everyone,
Firstly i do not require alot of help.. i am right at the end of finishing my scipt but cannot find a solution to the last part.
What i need to do is, prompt the user for a file to work with, which i have done.
promt the user for an output file - which is done.
#!/bin/bash... (14 Replies)
Discussion started by: hugh86
14 Replies
6. Shell Programming and Scripting
Hi ! I'm working into my first bash script to make some xml modification and it's going to make me crazy lol .. so I decide to try into this forum to take some ideas from people that really know about this!
This is my situation I've and xml file with a lots of positional values with another tags... (9 Replies)
Discussion started by: juampal
9 Replies
7. Shell Programming and Scripting
I have 800+ html files that need to have a javascript added to them in the head. I can do the looping, setting filenames as variables, etc. but I cannot figure out how to insert my javascript file into the html.
My javascript is in a file named jsinsert.txt
It basically has this format:... (4 Replies)
Discussion started by: Trapper
4 Replies
8. UNIX for Dummies Questions & Answers
Hi Guys,
Can you help me in creating shell script using sed,awk etc commands to generate csv file using xml file. (5 Replies)
Discussion started by: sbk
5 Replies
9. Shell Programming and Scripting
Hi There,
I am trying to load data from a csv file into a DB during our DB migration phase. I am successfully able export all data into a .csv file but those have to rewritten in terms insert statement which will allow for further population of same data in different DB
My exiting csv record... (6 Replies)
Discussion started by: bhaskar_m
6 Replies
10. Shell Programming and Scripting
Hi All,
I want to modify(changing the status from "on" to "off" status of Stage-element value from the below xml file using sed or awk:
File Name: global.xml
<?xml version="1.0" encoding="UTF-8"?>
<config>
<widget>
<name>HTTP-POOL</name>
<attributes>
... (5 Replies)
Discussion started by: wamqemail2
5 Replies
LEARN ABOUT DEBIAN
iptables-xml
IPTABLES-XML(8) IPTABLES-XML(8)
NAME
iptables-xml -- Convert iptables-save format to XML
SYNOPSIS
iptables-xml [-c] [-v]
DESCRIPTION
iptables-xml is used to convert the output of iptables-save into an easily manipulatable XML format to STDOUT. Use I/O-redirection pro-
vided by your shell to write to a file.
-c, --combine
combine consecutive rules with the same matches but different targets. iptables does not currently support more than one target per
match, so this simulates that by collecting the targets from consecutive iptables rules into one action tag, but only when the rule
matches are identical. Terminating actions like RETURN, DROP, ACCEPT and QUEUE are not combined with subsequent targets.
-v, --verbose
Output xml comments containing the iptables line from which the XML is derived
iptables-xml does a mechanistic conversion to a very expressive xml format; the only semantic considerations are for -g and -j targets in
order to discriminate between <call> <goto> and <nane-of-target> as it helps xml processing scripts if they can tell the difference between
a target like SNAT and another chain.
Some sample output is:
<iptables-rules>
<table name="mangle">
<chain name="PREROUTING" policy="ACCEPT" packet-count="63436" byte-count="7137573">
<rule>
<conditions>
<match>
<p>tcp</p>
</match>
<tcp>
<sport>8443</sport>
</tcp>
</conditions>
<actions>
<call>
<check_ip/>
</call>
<ACCEPT/>
</actions>
</rule>
</chain>
</table> </iptables-rules>
Conversion from XML to iptables-save format may be done using the iptables.xslt script and xsltproc, or a custom program using libxsltproc
or similar; in this fashion:
xsltproc iptables.xslt my-iptables.xml | iptables-restore
BUGS
None known as of iptables-1.3.7 release
AUTHOR
Sam Liddicott <azez@ufomechanic.net>
SEE ALSO
iptables-save(8), iptables-restore(8), iptables(8)
Jul 16, 2007 IPTABLES-XML(8)