Login or Register to Ask a Question and Join Our Community


Shell Programming and Scripting

process xml

Login to Discuss or Reply to this Discussion in Our Community

 
Thread Tools Search this Thread
Top Forums Shell Programming and Scripting process xml
# 1  
Old 02-24-2006
process xml
Hi,

I'm looking to split the below mentioned XML files into defintie splits , so that each split still specific number of the tag <action></action>.

<?xml version="1.0" encoding="ISO-8859-1"?>
<begin>
<action domain="XXX" actionType="INSERT" documentId="111" docVersion="1" startdate="2005-02-21T16:57:01.817" enddate="4999-12-31T00:00:00.000" isCurrentVersion="true">
<column1>11</column1>
</action>

<action domain="XXX" actionType="INSERT" documentId="222" docVersion="1" startdate="2005-02-21T16:57:01.817" enddate="4999-12-31T00:00:00.000" isCurrentVersion="true">
<column1>22</column1>
</action>

<action domain="XXX" actionType="INSERT" documentId="333" docVersion="1" startdate="2005-02-21T16:57:01.817" enddate="4999-12-31T00:00:00.000" isCurrentVersion="true">
<column1>3322</column1>
</action>

<action domain="XXX" actionType="INSERT" documentId="444" docVersion="1" startdate="2005-02-21T16:57:01.817" enddate="4999-12-31T00:00:00.000" isCurrentVersion="true">
<column1>4422</column1>
</action>
</begin>

Say above mentioned file need to be slpited tin two pieces, I give input as 2 and first split contains the data element like

Code:
Split 1

<?xml version="1.0" encoding="ISO-8859-1"?>
<begin>
<action domain="XXX" actionType="INSERT" documentId="111" docVersion="1" startdate="2005-02-21T16:57:01.817" enddate="4999-12-31T00:00:00.000" isCurrentVersion="true">
    <column1>11</column1>
</action>

<action domain="XXX" actionType="INSERT" documentId="222" docVersion="1" startdate="2005-02-21T16:57:01.817" enddate="4999-12-31T00:00:00.000" isCurrentVersion="true">
    <column1>22</column1>
</action>
</begin>


Split 2
<?xml version="1.0" encoding="ISO-8859-1"?>
<action domain="XXX" actionType="INSERT" documentId="333" docVersion="1" startdate="2005-02-21T16:57:01.817" enddate="4999-12-31T00:00:00.000" isCurrentVersion="true">
    <column1>3322</column1>
</action>

<action domain="XXX" actionType="INSERT" documentId="444" docVersion="1" startdate="2005-02-21T16:57:01.817" enddate="4999-12-31T00:00:00.000" isCurrentVersion="true">
    <column1>4422</column1>
</action>
</begin>


Is this feasible ???
Login or Register to Ask a Question

Previous Thread | Next Thread

9 More Discussions You Might Find Interesting

1. UNIX for Beginners Questions & Answers

How to pull multiple XML tags from the same XML file in Shell.?

I'm searching for the names of a TV show in the XML file I've attached at the end of this post. What I'm trying to do now is pull out/list the data from each of the <SeriesName> tags throughout the document. Currently, I'm only able to get data the first instance of that XML field using the... (9 Replies)
Discussion started by: hungryd
9 Replies

2. UNIX for Beginners Questions & Answers

Grepping multiple XML tag results from XML file.

I want to write a one line script that outputs the result of multiple xml tags from a XML file. For example I have a XML file which has below XML tags in the file: <EMAIL>***</EMAIL> <CUSTOMER_ID>****</CUSTOMER_ID> <BRANDID>***</BRANDID> Now I want to grep the values of all these specified... (1 Reply)
Discussion started by: shubh752
1 Replies

3. Shell Programming and Scripting

Splitting a single xml file into multiple xml files

Hi, I'm having a xml file with multiple xml header. so i want to split the file into multiple files. Sample.xml consists multiple headers so how can we split these multiple headers into multiple files in unix. eg : <?xml version="1.0" encoding="UTF-8"?> <ml:individual... (3 Replies)
Discussion started by: Narendra921631
3 Replies

4. Shell Programming and Scripting

Split xml file into multiple xml based on letterID

Hi All, We need to split a large xml into multiple valid xml with same header(2lines) and footer(last line) for N number of letterId. In the example below we have first 2 lines as header and last line as footer.(They need to be in each split xml file) Header: <?xml version="1.0"... (5 Replies)
Discussion started by: vx04
5 Replies

5. Shell Programming and Scripting

Splitting xml file into several xml files using perl

Hi Everyone, I'm new here and I was checking this old post: /shell-programming-and-scripting/180669-splitting-file-into-several-smaller-files-using-perl.html (cannot paste link because of lack of points) I need to do something like this but understand very little of perl. I also check... (4 Replies)
Discussion started by: mcosta
4 Replies

6. Shell Programming and Scripting

How to add Xml tags to an existing xml using shell or awk?

Hi , I have a below xml: <ns:Body> <ns:result> <Date Month="June" Day="Monday:/> </ns:result> </ns:Body> i have a lookup abc.txtt text file with below details Month June July August Day Monday Tuesday Wednesday I need a output xml with below tags <ns:Body> <ns:result>... (2 Replies)
Discussion started by: Nevergivup
2 Replies

7. Shell Programming and Scripting

Shell Command to compare two xml lines while ignoring xml tags

I've got two different files and want to compare them. File 1 : HTML Code: <response ticketId="944" type="getQueryResults"><status>COMPLETE</status><description>Query results fetched successfully</description><recordSet totalCount="1" type="sms_records"><record... (1 Reply)
Discussion started by: Shaishav Shah
1 Replies

8. Shell Programming and Scripting

How to add the multiple lines of xml tags before a particular xml tag in a file

Hi All, I'm stuck with adding multiple lines(irrespective of line number) to a file before a particular xml tag. Please help me. <A>testing_Location</A> <value>LA</value> <zone>US</zone> <B>Region</B> <value>Russia</value> <zone>Washington</zone> <C>Country</C>... (0 Replies)
Discussion started by: mjavalkar
0 Replies

9. Shell Programming and Scripting

How to remove xml namespace from xml file using shell script?

I have an xml file: <AutoData xmlns:xsi="http://www.w3.org/2001/XMLSchema-instance"> <Table1> <Data1 10 </Data1> <Data2 20 </Data2> <Data3 40 </Data3> <Table1> </AutoData> and I have to remove the portion xmlns:xsi="http://www.w3.org/2001/XMLSchema-instance" only. I tried using sed... (10 Replies)
Discussion started by: Gary1978
10 Replies
Login or Register to Ask a Question