How join two xml files?

 
Thread Tools Search this Thread
Special Forums Windows & DOS: Issues & Discussions How join two xml files?
# 8  
Old 06-11-2016
I tried to find what you told me, but I can't find it. Here there is the list of the possible command hxxp://gnuwin32.sourceforge.net/packages.html I think what you told me is no available Smilie

---------- Post updated at 04:20 PM ---------- Previous update was at 04:18 PM ----------

Quote:
Originally Posted by Aia
Do you have Perl?

Code:
my $header = qq(<?xml version="1.0" encoding="UTF-8"?>);
my @tv_queue;
my %tv = ();
{
    local $/="</tv>\n";
    while(<>) {
        my ($generator) = /(<tv.*>)/;
        if (!$tv{$generator}){
           push @tv_queue, $generator;
        }
        push @{$tv{$generator}[0]}, /(\s{2}<channel.*channel>)/sm;
        push @{$tv{$generator}[1]}, /(\s{2}<programme.*programme>)/sm;
    }
}
print "$header\n";
for my $g (@tv_queue){
    print "$g\n";
    for my $i (@{$tv{$g}}) {
        print join("\n", @{$i}), "\n";
    }
    print "</tv>\n";
}

I have not but i think is avalaible, I try to find and install it.
# 9  
Old 06-11-2016
Quote:
Originally Posted by Tapiocapioca
I have not but i think is avalaible, I try to find and install it.
There are binaries of Perl for windows as well.
# 10  
Old 06-11-2016
Quote:
Originally Posted by Aia
There are binaries of Perl for windows as well.
I found and downloaded this hxxp://www.activestate.com/activeperl/downloads , but I am totally beginner about, what the way to use your script? Where can I input my files? Excuseme if I am asking really simple questions for you totally clear.
# 11  
Old 06-11-2016
Moderator's Comments:
Mod Comment I am moving this out of the Shell Programming and Scripting forum to the Windows & DOS: Issues and Discussions forum.

This question is asking about creating and running batch commands on a Windows system where the batch command runs some unspecified subset of GnuWin packages tools not including the package that contains the shell.

Maybe someone with more knowledge of Windows batch scripting can tell you how to do what you want using Windows commands.
# 12  
Old 06-11-2016
Tell us a bit more about that Italy - Indonesia setup. Are both machines Windows? How do you connect/login? Is there an option to copy those files elsewhere?
# 13  
Old 06-11-2016
Quote:
Originally Posted by RudiC
Tell us a bit more about that Italy - Indonesia setup. Are both machines Windows? How do you connect/login? Is there an option to copy those files elsewhere?
I use remote desktop to connect to one machine with windows 7, is a real machine not virtual. I connect mysel from indonenesia to italy, but I think this is not really important Smilie I tried to make some scripts with dos but the xml files I need edit are big like 100 mb and windows become crazy trying to modify big files, so I tried the solution of GnuWin32 Packages and works fine. But about join files with linux command I have not idea Smilie
# 14  
Old 06-11-2016
Quote:
Originally Posted by Tapiocapioca
I found and downloaded this hxxp://www.activestate.com/activeperl/downloads , but I am totally beginner about, what the way to use your script? Where can I input my files? Excuseme if I am asking really simple questions for you totally clear.
Save the snippet I posted as merge_xml.pl
Run at the command prompt as perl merge_xml.pl file1.xml file2.xml file3.xml > big.xml

This suggested code will accommodate as many files as you want to merge. It uses the following entries as unique ID
Code:
<tv generator-info-name="xxx" generator-info-url="www.xxx.com">

Login or Register to Ask a Question

Previous Thread | Next Thread

10 More Discussions You Might Find Interesting

1. Shell Programming and Scripting

Join, merge, fill NULL the void columns of multiples files like sql "LEFT JOIN" by using awk

Hello, This post is already here but want to do this with another way Merge multiples files with multiples duplicates keys by filling "NULL" the void columns for anothers joinning files file1.csv: 1|abc 1|def 2|ghi 2|jkl 3|mno 3|pqr file2.csv: 1|123|jojo 1|NULL|bibi... (2 Replies)
Discussion started by: yjacknewton
2 Replies

2. Shell Programming and Scripting

Help to join separate lines in a single one from xml file

Hi all, I need help to parse this xml file that has paragraphs broken in different lines and I would like to join in a single line. I hope you can understand my explanation. Thanks for any help/direction. The script could be in bash, awk, ruby, perl whatever please In the output I want:... (8 Replies)
Discussion started by: Ophiuchus
8 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

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

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

6. Shell Programming and Scripting

Join 2 files

I have file1.txt BGE179W1 BGE179W2 BGE179W3 BGE187W1 BGE187W2 BGE187W3 BGE194W1 BGE194W2 BGE194W3 BGE227W1 BGE227W2 BGE227W3 BGE288W1 BGE288W2 BGE288W3 BGE650W1 ---------- Post updated at 12:41 AM ---------- Previous update was at 12:39 AM ---------- (5 Replies)
Discussion started by: radius
5 Replies

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

8. UNIX for Dummies Questions & Answers

How to use the the join command to join multiple files by a common column

Hi, I have 20 tab delimited text files that have a common column (column 1). The files are named GSM1.txt through GSM20.txt. Each file has 3 columns (2 other columns in addition to the first common column). I want to write a script to join the files by the first common column so that in the... (5 Replies)
Discussion started by: evelibertine
5 Replies

9. UNIX for Dummies Questions & Answers

how to join two files using "Join" command with one common field in this problem?

file1: Toronto:12439755:1076359:July 1, 1867:6 Quebec City:7560592:1542056:July 1, 1867:5 Halifax:938134:55284:July 1, 1867:4 Fredericton:751400:72908:July 1, 1867:3 Winnipeg:1170300:647797:July 15, 1870:7 Victoria:4168123:944735:July 20, 1871:10 Charlottetown:137900:5660:July 1, 1873:2... (2 Replies)
Discussion started by: mindfreak
2 Replies

10. UNIX for Dummies Questions & Answers

Join 2 files with multiple columns: awk/grep/join?

Hello, My apologies if this has been posted elsewhere, I have had a look at several threads but I am still confused how to use these functions. I have two files, each with 5 columns: File A: (tab-delimited) PDB CHAIN Start End Fragment 1avq A 171 176 awyfan 1avq A 172 177 wyfany 1c7k A 2 7... (3 Replies)
Discussion started by: InfoSeeker
3 Replies
Login or Register to Ask a Question