Login or Register to Ask a Question and Join Our Community


Shell Programming and Scripting

Merge different xml files in one

Login to Discuss or Reply to this Discussion in Our Community

 
Thread Tools Search this Thread
Top Forums Shell Programming and Scripting Merge different xml files in one
# 1  
Old 04-09-2012
Merge different xml files in one
Dear all,

I have a big number of .xml files (130GB) and I would like merge them in one. The problem is that I don't want all tags and all the xml files are the same.
Is there any script that I can use?
Thank you in advance for your helping!

Some files are like:
HTML Code:
<doctype>TA</doctype>
<year>2005</year>
<lan>en</lan>
<proc>12345</proc>
<body>context of the file</body>

And some like:
HTML Code:
<doctype>TA</doctype>
<year>2005</year>
<lan>en</lan>
<proc>12345</proc>
<type>PRO</type>
<use>NO</use>
<body>context of the file</body>

And the new file must be:
HTML Code:
<?xml version="1.0" encoding="UTF-8" standalone="no" lang="EN"?>
<text>
<doc>
<file mane>file's mane</file mane>
< doctype>TA</doctype>
<year>2005</year>
<lan>EN</lan>
<body>context of the file</body>
</doc>

<doc>
<file mane>file's mane</file mane>
< doctype>TA</doctype>
<year>2006</year>
<lan>EN</lan>
<body>context of the file</body>
</doc>
</text>
Login or Register to Ask a Question

Previous Thread | Next Thread

10 More Discussions You Might Find Interesting

1. 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

2. 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

3. Shell Programming and Scripting

Extract strings from XML files and create a new XML

Hello everybody, I have a double mission with some XML files, which is pretty challenging for my actual beginner UNIX knowledge. I need to extract some strings from multiple XML files and create a new XML file with the searched strings.. The original XML files contain the source code for... (12 Replies)
Discussion started by: milano.churchil
12 Replies

4. Shell Programming and Scripting

Merge files and generate a resume in two files

Dear Gents, Please I need your help... I need small script :) to do the following. I have a thousand of files in a folder produced daily. I need first to merge all files called. txt (0009.txt, 0010.txt, 0011.txt) and and to output a resume of all information on 2 separate files in csv... (14 Replies)
Discussion started by: jiam912
14 Replies

5. Shell Programming and Scripting

How to merge two files?

Hi Gurus, I have two files as below file1 abc cde cdd cdf file2 123 234 345 456 I want to get abc 123 cde 234 cdd 345 (3 Replies)
Discussion started by: ken6503
3 Replies

6. Shell Programming and Scripting

Compare two xml files while ignoring some xml tags

I've got two different files and want to compare them. File 1 : <response ticketId="944" type="getQueryResults"><status>COMPLETE</status><description>Query results fetched successfully</description><recordSet totalCount="1" type="sms_records"><record id="38,557"><columns><column><name>orge... (2 Replies)
Discussion started by: Shaishav Shah
2 Replies

7. Shell Programming and Scripting

Checking in a directory how many files are present and basing on that merge all the files

Hi, My requirement is,there is a directory location like: :camp/current/ In this location there can be different flat files that are generated in a single day with same header and the data will be different, differentiated by timestamp, so i need to verify how many files are generated... (10 Replies)
Discussion started by: srikanth_sagi
10 Replies

8. Shell Programming and Scripting

Merge XML file (to same root)

HI I am looking for a easy way to merge 2 xml files like the following file 1: will have a structure like this <Group GID="TOTO" NAME="TOTO" UNITS="1.0"> <Property NAME="Id" VALUE="TOTO"/> <Property NAME="Currency" VALUE="USD"/> <Group... (6 Replies)
Discussion started by: kykyboss
6 Replies

9. Shell Programming and Scripting

script to merge xml files with options

Hi, I have a very basic knowledge of shell scripting & would like some help with a little problem I have. I sometimes use a program calle phronix & sometimes like to compare its results which are *.xml files. Which is easy enough but a friend wants to avoid typing the path to the files.... (2 Replies)
Discussion started by: ptrbee
2 Replies

10. Shell Programming and Scripting

Merge files of differrent size with one field common in both files using awk

hi, i am facing a problem in merging two files using awk, the problem is as stated below, file1: A|B|C|D|E|F|G|H|I|1 M|N|O|P|Q|R|S|T|U|2 AA|BB|CC|DD|EE|FF|GG|HH|II|1 .... .... .... file2 : 1|Mn|op|qr (2 Replies)
Discussion started by: shashi1982
2 Replies
Login or Register to Ask a Question