11-01-2004
XML parsing
Hi
I want to take an XML file and transform it into a pipe-delimited format. What is the best tool to use for this? I have libxml2 which seems to be the best xml parser around.
The xml file will have the following format.
<Txn>
<Date>120504</Date>
<id>99</id>
<Items>
<Item>
<sku>838373736</sku>
<price>1.26</price>
</Item>
<Item>
<sku>842374823</sku>
<price>2.99</price>
</Item>
</Items>
</Txn>
<Txn>
<Date>120504</Date>
<id>89</id>
<Items>
<Item>
<sku>36433637</sku>
<price>2.36</price>
</Item>
</Items>
</Txn>
I would want this xml to look like the following in the pipe delimited format,
120504|99|838373736|1.26
120504|99|842374823|2.99
120504|89|36433637|2.36
10 More Discussions You Might Find Interesting
1. Shell Programming and Scripting
I want to use wget comment to parse an xml parse that exist in an online website. How can I connect it using shell script through Unix and how can I parse it?? (1 Reply)
Discussion started by: walnut
1 Replies
2. Shell Programming and Scripting
Hi,
Need a script to parse the following xml file content
<tag1 Name="val1">
<abc Name="key"/>
<abc Name="pass">*********</abc>
</tag1>
<tag2 Name="Core">
<Host Name="a.b.c">
<tag1 Name="abc">
<abc Name="ac">None</abc>
... (4 Replies)
Discussion started by: Mavericc
4 Replies
3. Shell Programming and Scripting
I have a xml file attached. I need to parse parameterId and its value
My output should be like
151515 38
151522 32769
and so on..
Please help me. Its urgent (6 Replies)
Discussion started by: LavanyaP
6 Replies
4. Shell Programming and Scripting
Learned People,
Hello !
Till today, for the most part, all of the tricky questions/situations that I encountered were already posted by other folks and all I had to do was peruse through these one at a time and I could find some sort of an answer and all I had to do was add some minor tweaks... (5 Replies)
Discussion started by: ManoharMa
5 Replies
5. UNIX for Advanced & Expert Users
I had a big XML and from which I have to make a layout as below
*TOTAL+CB | *CB+FX | CS |*IR | *TOTAL |
--------------------------------------------------------------------------------------------------
|CB FX | | | |
DMFXNY EMSGFX... (6 Replies)
Discussion started by: manas_ranjan
6 Replies
6. Shell Programming and Scripting
I am trying to parse an xml file and trying to grab certain values and inserting them into database table. I have the following xml that I am parsing:
<dd:service name="locator" link="false">
<dd:activation mode="manual" />
<dd:run mode="direct_persistent" proxified="false" managed="true"... (7 Replies)
Discussion started by: $criptKid617
7 Replies
7. Shell Programming and Scripting
I am trying to parse the XML Google contact file using tools like xmllint and I even dived into the XSL Style Sheets using xsltproc but I get nowhere.
I can not supply any sample file as it contains private data but you can download your own contacts using this script:
#!/bin/sh
# imports... (9 Replies)
Discussion started by: ripat
9 Replies
8. Shell Programming and Scripting
i have xml output in below format...
<AlertsResponse>
<Alert id="11216" name="fgdfg">
<AlertActionLog timestamp="1356521629778" user="admin" detail="Recovery Alert"/>
</Alert>
<Alert id="11215" name="gdfg
<AlertActionLog timestamp="1356430119840" user=""... (12 Replies)
Discussion started by: vivek d r
12 Replies
9. Shell Programming and Scripting
HI
I want to parse below file in to two output :-
Input :-
?xml version="1.0" encoding="UTF-8"?>
<bulkCmConfigDataFile xmlns:un="utranNrm.xsd"
<configData dnPrefix="Undefined">
<xn:SubNetwork id="ONRM_ROOT_MO_R">
<xn:MeContext id="C136">
... (3 Replies)
Discussion started by: asavaliya
3 Replies
10. Shell Programming and Scripting
I have an xml file where the format looks like below
<SESSIONCOMPONENT REFOBJECTNAME ="pre_session_command" REUSABLE ="NO" TYPE ="Pre-session command">
<TASK DESCRIPTION ="" NAME ="pre_session_command" REUSABLE ="NO" TYPE ="Command" VERSIONNUMBER ="1">
... (8 Replies)
Discussion started by: r_t_1601
8 Replies
LEARN ABOUT DEBIAN
crm_diff
PACEMAKER(8) System Administration Utilities PACEMAKER(8)
NAME
Pacemaker - Part of the Pacemaker cluster resource manager
SYNOPSIS
crm_diff original_xml operation [options]
DESCRIPTION
crm_diff - A utility for comparing Pacemaker configurations (XML format)
The tool produces a custom (diff-like) output which it can also apply like a patch
OPTIONS
-?, --help
This text
-$, --version
Version information
-V, --verbose
Increase debug output
Original XML:
-o, --original=value
XML is contained in the named file
-O, --original-string=value
XML is contained in the supplied string
Operation:
-n, --new=value
Compare the original XML to the contents of the named file
-N, --new-string=value
Compare the original XML to the contents of the supplied string
-p, --patch=value
Patch the original XML with the contents of the named file
Additional Options:
-c, --cib
Compare/patch the inputs as a CIB (includes versions details)
-f, --filter
Suppress irrelevant differences between the two inputs
EXAMPLES
Obtain the two different configuration files by running cibadmin on the two cluster setups to compare:
# cibadmin --query > cib-old.xml
# cibadmin --query > cib-new.xml
Calculate and save the difference between the two files:
# crm_diff --original cib-old.xml --new cib-new.xml > patch.xml
Apply the patch to the original file:
# crm_diff --original cib-old.xml --patch patch.xml > updated.xml
Apply the patch to the running cluster:
# cibadmin --patch patch.xml
AUTHOR
Written by Andrew Beekhof
REPORTING BUGS
Report bugs to pacemaker@oss.clusterlabs.org
Pacemaker 1.1.7 April 2012 PACEMAKER(8)