awk and or sed command to sum the value in repeating tags in a XML
I have a XML in which <Amt Ccy="EUR">3.1</Amt> tag repeats. This is under another tag <Main>. I need to sum all the values of <Amt Ccy=""> (Ccy may vary) coming under <Main> using awk and or sed command.
I have some data that is something like this?
item: onhand counted location
ITEM0001 1 0 a1
ITEM0001 0 1 a2
ITEM0002 5 0 b5
ITEM0002 0 6 c1
I want to sum up... (6 Replies)
Hi all,
I have an awk command that needs to be ran multiple times in a script on one file containing lots of fields of data.
The file look like this (the numbers are made up):
1234 2222 2223 2222
123 2223 3333 2323
3333 3321 3344 4444
The... (2 Replies)
Hi,
I have catenated multiple output files (from a monte carlo run) into one big output file. Each individual file has it's own two line header. So when I catenate, there are multiple two line headers (of the same wording) within the big file. How do I use the sed command to search for the... (1 Reply)
Here is what I have so far:
find . -name "*php*" -or -name "*htm*" | xargs grep -i iframe | awk -F'"' '/<iframe*/{gsub(/.\*iframe>/,"\"");print $2}'
Here is an example content of a PHP or HTM(HTML) file:
<iframe src="http://ADDRESS_1/?click=5BBB08\" width=1 height=1... (18 Replies)
Hi,
I am new to shell scripting. I need to extract data between repeating tags from an xml file and store the data in an array to process it further.
<ns1:root xmlns:ns1="http://example.com/config">
<ns1:interface>in1</ns1:interface>
<ns1:operation attribute1="true" attribute2="abd"... (2 Replies)
I've got two different files and want to compare them.
File 1 :
HTML Code:
<response ticketId="944" type="getQueryResults"><status>COMPLETE</status><description>Query results fetched successfully</description><recordSet totalCount="1" type="sms_records"><record... (1 Reply)
Hi ,
I have a below xml:
<ns:Body>
<ns:result>
<Date Month="June" Day="Monday:/>
</ns:result>
</ns:Body>
i have a lookup abc.txtt text file with below details
Month June July August
Day Monday Tuesday Wednesday
I need a output xml with below tags
<ns:Body>
<ns:result>... (2 Replies)
Hello All,
I have data like this in a column.
0
1
2
3
0
3
4
5
6
0
1
2
3
etc. where 0 identifies the start of a pattern in my data.
So I need the output like below using either awk/sed.
0 1 (2 Replies)
Hello all,
how would one go about writing a command using sed/awk that will give me an output that can sum up the number of time each user has done something and also add the amount of time...
so output would be for example
"smiths has run 3 process and for time taken of value: 224"
... (5 Replies)
Discussion started by: crazy_max
5 Replies
LEARN ABOUT DEBIAN
mkdoc::xml::stripper
MKDoc::XML::Stripper(3pm) User Contributed Perl Documentation MKDoc::XML::Stripper(3pm)NAME
MKDoc::XML::Stripper - Remove unwanted XML / XHTML tags and attributes
SYNOPSIS
use MKDoc::XML::Stripper;
my $stripper = new MKDoc::XML::Stripper;
$stripper->allow (qw /p class id/);
my $ugly = '<p class="para" style="color:red">Hello, <strong>World</strong>!</p>';
my $neat = $stripper->process_data ($ugly);
print $neat;
Should print:
<p class="para">Hello, World!</p>
SUMMARY
MKDoc::XML::Stripper is a class which lets you specify a set of tags and attributes which you want to allow, and then cheekily strip any
XML of unwanted tags and attributes.
In MKDoc, this is used so that editors use structural XHTML rather than presentational tags, i.e. strip anything which looks like a <font>
tag, a 'style' attribute or other tags which would break separation of structure from content.
DISCLAIMER
This module does low level XML manipulation. It will somehow parse even broken XML and try to do something with it. Do not use it unless
you know what you're doing.
API
my $stripper = MKDoc::XML::Stripper->new()
Instantiates a new MKDoc::XML::Stripper object.
$stripper->load_def ($def_name);
Loads a definition located somewhere in @INC under MKDoc/XML/Stripper.
Available definitions are:
xhtml10frameset
xhtml10strict
xhtml10transitional
mkdoc16 - MKDoc 1.6. XHTML structural markup
You can also load your own definition file, for instance:
$stripper->load_def ('my_def.txt');
Definitions are simple text files as follows:
# allow p with 'class' and id
p class
p id
# allow more stuff
td class
td id
td style
# etc...
$stripper->allow ($tag, @attributes)
Allows "<$tag>" to appear in the stripped XML. Additionally, allows @attributes to appear as attributes of <$tag>, so for instance:
$stripper->allow ('p', 'class', 'id');
Will allow the following:
<p>
<p class="foo">
<p id="bar">
<p class="foo" id="bar">
However any extra attributes will be stripped, i.e.
<p class="foo" id="bar" style="font-color: red">
Will be rewritten as
<p class="foo" id="bar">
$stripper->disallow ($tag)
Explicitly disallows a tag and all its associated attributes. By default everything is disallowed.
$stripper->process_data ($some_xml);
Strips $some_xml according to the rules that were given with the allow() and disallow() methods and returns the result. Does not modify
$some_xml in place.
$stripper->process_file ('/an/xml/file.xml');
Strips '/an/xml/file.xml' according to the rules that were given with the allow() and disallow() methods and returns the result. Does not
modify '/an/xml/file.xml' in place.
NOTES
MKDoc::XML::Stripper does not really parse the XML file you're giving to it nor does it care if the XML is well-formed or not. It uses
MKDoc::XML::Tokenizer to turn the XML / XHTML file into a series of MKDoc::XML::Token objects and strictly operates on a list of tokens.
For this same reason MKDoc::XML::Stripper does not support namespaces.
AUTHOR
Copyright 2003 - MKDoc Holdings Ltd.
Author: Jean-Michel Hiver
This module is free software and is distributed under the same license as Perl itself. Use it at your own risk.
SEE ALSO
MKDoc::XML::Tokenizer MKDoc::XML::Token
perl v5.10.1 2004-10-06 MKDoc::XML::Stripper(3pm)