01-22-2010
I dont think you understand my point. XML files have a structure that do not necessarily lend themselves to straightforward conversion into CSV files, in which case sed would do the trick. I understand that you are working on a UNIX machine, which means that more than likely you will have access to Perl. Giving you an answer in shell script will merely be a replication of what is in the tried and tested Perl module.
10 More Discussions You Might Find Interesting
1. Shell Programming and Scripting
Dear all,
Can you send me a script file the changes .xml to .csv file.
Thanks,
Srinivasa (4 Replies)
Discussion started by: srinivasaphani
4 Replies
2. Shell Programming and Scripting
Apologies if this has already been covered in this site somewhere, I did try looking but without any success. I am new to the whole XML thing, very late starter, and have a requirement to convert an XML fiule to a CSV fomat. I am crrently working on a Solaris OS. Does anyone have any suggestions,... (2 Replies)
Discussion started by: rossingi_33
2 Replies
3. Shell Programming and Scripting
Can any one give the idea on this, please.
I have the following XML file and wants to convert into CSV(comma separated value) format.
<?xml version='1.0' encoding='UTF-8'?>
<!DOCTYPE Waveset PUBLIC 'waveset.dtd' 'waveset.dtd'>
<Waveset>
<Object name='ra8736'>
<Attribute name='ADDRESS'... (2 Replies)
Discussion started by: kumar04
2 Replies
4. Shell Programming and Scripting
Hi,
I have an xml file and I want to convert it with awk in to a csv file
Test.xml
<Worksheet ss:Name="Map1">
<Table ss:ExpandedColumnCount="2" ss:ExpandedRowCount="2" x:FullColumns="1"
x:FullRows="1" ss:DefaultColumnWidth="60">
<Row>
<Cell><Data... (6 Replies)
Discussion started by: research3
6 Replies
5. Shell Programming and Scripting
I need to convert below xml code to csv. I searched other posts as well but this post (_https://www.unix.com/shell-programming-scripting/174417-extract-parse-xml-data-statistic-value-csv.html) gives "sed command garbled" error. As of now I have written a long script to do it, but can it be done with... (7 Replies)
Discussion started by: dineshydv
7 Replies
6. Shell Programming and Scripting
I have huge xml file in server and i want to convert it to .csv with specific column ...
i have search in blog but i didn't get any usefully command.
Thanks in advance (1 Reply)
Discussion started by: pareshkp
1 Replies
7. Shell Programming and Scripting
Hi Guys,
I am new to Shell scripting and need to convert an XML files to a CSV file.
My actual problem is that XML file loading is taking hours and I have decided to convert the XML structure to row based data in a CSV file.
My XML file: Message846 can repeat within main loop and... (1 Reply)
Discussion started by: qamar.shahbaz
1 Replies
8. Shell Programming and Scripting
I am in need of converting billions of XML into csv file to load data to DB, i have found the below code in perl but not sure why it's not working properly.
CODE:
#!/usr/bin/perl
# Script to illustrate how to parse a simple XML file
# and pick out all the values for a specific element, in... (1 Reply)
Discussion started by: rspwilliam
1 Replies
9. Shell Programming and Scripting
Hello,
I am working on a part of code where I need a awk or shell script to convert the given XML file to CSV or TXT file.
There are multiple xml files and of different structure, so a single script is required for converting data.
I did find a lot of solutions in the forum but... (16 Replies)
Discussion started by: Rashmitha
16 Replies
10. UNIX for Advanced & Expert Users
we have a CSV which i need to convert to XML using Perl or Unix shell scripting.
I was able to build this XML in oracle database. However, SQL/XML query is running for long time. Hence, I'm considering to write a Perl or shell script to generate this XML file. Basically need to build this XML... (3 Replies)
Discussion started by: laknar
3 Replies
LEARN ABOUT DEBIAN
soap::deserializer
SOAP::Deserializer(3pm) User Contributed Perl Documentation SOAP::Deserializer(3pm)
NAME
SOAP::Deserializer - the means by which the toolkit manages the conversion of XML into an object manageable by a developer
DESCRIPTION
SOAP::Deserializer provides the means by which incoming XML is decoded into a Perl data structure.
METHODS
context
This provides access to the calling context of "SOAP::Deserializer". In a client side context the often means a reference to an
instance of SOAP::Lite. In a server side context this means a reference to a SOAP::Server instance.
EXAMPLES
DESERIALIZING RAW XML INTO A SOAP::SOM OBJECT
A useful utility for SOAP::Deserializer is for parsing raw XML documents or fragments into a SOAP::SOM object. SOAP::Lite developers use
this technique to write unit tests for the SOAP::Lite module itself. It is a lot more efficient for testing aspects of the toolkit than
generating client calls over the network. This is a perfect way for developers to write unit tests for their custom data types for example.
Here is an example of how raw XML content can be parsed into a SOAP::SOM object by using SOAP::Deserializer:
$xml = <<END_XML;
<foo>
<person>
<foo>123</foo>
<foo>456</foo>
</person>
<person>
<foo>789</foo>
<foo>012</foo>
</person>
</foo>
END_XML
my $som = SOAP::Deserializer->deserialize($xml);
COPYRIGHT
Copyright (C) 2000-2004 Paul Kulchenko. All rights reserved.
This library is free software; you can redistribute it and/or modify it under the same terms as Perl itself.
AUTHORS
Byrne Reese (byrne@majordojo.com)
perl v5.12.4 2010-06-03 SOAP::Deserializer(3pm)