If you like to make generic tools to convert xml ex. to csv, then maybe you can find some helps from my Xml2Csv docs.
Main idea is to convert all to element format and then create csv.
Using ex. xsltproc process will be something like:
Code:
# remove some elements and attributes
xsltproc remove.xsl ex1.xml > ex1.b.xml
# change attributes => elements
xsltproc xml2elements.xsl ex1.b.xml > ex1.e.xml
# to csv
xsltproc xml2csv.xsl ex1.e.xml > ex1.csv
If somebody has done same using awk, I like to use it also ...
I am trying to use a line of output in an XML file as input in another new XML file for processing purposes via a shell script. Since I am a newbie though, I'm not sure how to do this since the data is different everytime. I am using this technique with static data right now:
echo -n "Running... (5 Replies)
Hi people!,
I need extract from the file (test-file.txt) the values between
<context> and </context> tag's , the total are 7 lines,but i can only get 5 or 2 lines!!:confused:
Please look my code:
#awk '/context/{flag=1} /\/context/{flag=0} !/context/{ if (flag==1) p
rint $0; }'... (3 Replies)
As per another thread - https://www.unix.com/shell-programming-scripting/81027-how-can-i-parse-xml-file-2.html
I am using the following to extract the Subaccid and RecAccTotal from the xm file below
awk -v v=SubaccId -F'' '$2==v{s=$3;getline;a+=$3}END {for (i in a)print v,i,a}' file
Can... (6 Replies)
hello ,
i am trying to parse xml using awk however its a little bit tricky as i want
<databases>
<source>
<host>prod</host>
<port>1522</port>
<tns>GP1</tns>
<user>P11</user>... (6 Replies)
Hi ,
I have an xml format as shown below:
<Info>
<last name="sean" first name="john"/>
<period="5" time="11"/>
<test value="1",test2 value="2",test3 value="3",test4 value="5">
<old>
<value1>1</value1>
<value2>2</value2>
</old>
<new>
<value1>4</value1>
<value2>3</value2>
</new>... (1 Reply)
Hi,
I am trying to parse regular XML file where I have to reduce number of decimal points in some xml elements. I am using following AWK command to achive that :
#!/bin/ksh
EDITCMD='BEGIN { FS = ""; OFS=FS }
{
if ( $3 ~ "*\\.*" && length(substr($3,1+index($3,"."))) == 15 ) {... (4 Replies)
Hi All,
I have a problem to resolve. For following XML file, I need to parse the values based on Tag Name. I would prefer to use this by awk. I have used sed command to replace the tags (s/<SeqNo>//).
In this case there can be new tags introduced. So need to parse it based on Tag Name. Any... (9 Replies)
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)
below is the output xml string from some other command and i will be parsing it using awk
cat /tmp/alerts.xml
<Alert id="10102" name="APP-DS-ds_ha-140018-componentFailure-S" alertDefinitionId="13982" resourceId="11427" ctime="1359453507621" fixed="false" reason="If Event/Log Level(ANY) and... (2 Replies)
Discussion started by: vivek d r
2 Replies
LEARN ABOUT DEBIAN
xml2
XML2(1) General Commands Manual XML2(1)NAME
xml2 - convert xml documents in a flat format
2xml - convert flat format into xml
html2 - convert html documents in a flat format
2html - convert flat format into html
csv2 - convert csv files in a flat format
2csv - convert flat format into csv
SYNOPSIS
<xml2|2xml|html2|2html|csv2|2csv> > outfile < infile
DESCRIPTION
There are six tools. Except csv2 and and 2csv they don't take any command-line arguments. They are all simple filters which can be used to
read files from standard input in one format and output it to standard output in another format.
The flat format used by the tools is specific to these tools. It is a syntax for representing structured markup in a way that makes it
easy to process with line-oriented tools. The same format is used for HTML and XML; in fact, you can think of html2 as converting HTML to
XHTML and running xml2 on the result; likewise 2html and 2xml. (Of course, this isn't how the implementation works.)
SEE ALSO
This program does normally not include any documentation in form of manpages. However it has a real excellent documentation online with a
lot of example. In fact this manpage was based on this documentation.
Please find it on:
http://dan.egnor.name/xml2/ref
Examples can be found here:
http://dan.egnor.name/xml2/examples
AUTHOR
xml2 was written by Dan Egnor.
This manpage was written by Patrick Schoenfeld <schoenfeld@in-medias-res.com> for the Debian project, but may be used by others under the
same terms as xml2 is distributed.
BUGS
Bugs can be reported through the Debian Bug tracking system.
7h february 2008 XML2(1)