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:
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 CENTOS
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.10-29.el7 June 2014 PACEMAKER(8)