Hello everyone,
I would like to use awk to parse a file with three columns in, like:
monday 0 1
monday 1 1
monday 2 1
monday 3 1
monday 4 1
monday 5 1
tuesday 0 5
tuesday 1 1
tuesday 2 1
tuesday 3 1
tuesday 4 1
wednesday 0 1
monday 5 25
they represent the day the hour and the... (2 Replies)
Hi
Please suggest a script that would do a horizontal pivot , on the fields separated by a semicolon
Below is my input file 1|c2|aa
1|c3|dd
1|c4|cc
1|c5|aa
1|c6|ss
1|c7|dd
1|c8|bb
1|c9|jjj
1|c10|kkk
1|c11|fffg
1|c12|nnn;indi;pak;linf;wer
1|c13|lllnk;li;sdfsd;oiuo
1|c14|ppp... (5 Replies)
Dear friend,
I want to sum popul based on ville and reg.
input
date country ville reg popul
20131101 INDIA Gujarat College 322047286
20131101 USA Oregon 2 Kindergaten 477305599
20131101 INDIA Delhi 1 Ecole 255029428
20131101 MEXICO ... (2 Replies)
Hello everyone
I have a 20M file which is having the below sample layout
1111,ABC,100
1111,DEF,200
1111,XYZ,300
4444,LMN,100
4444,AKH,500
4444,WCD,400
2222,ABC,100
7777,DEF,300
7777,WCD,300
I need to covert this to below format
Output
Party_ID|ABC|AKH|DEF|LMN|WCD|XYZ... (5 Replies)
Hi
My Input is like below
DELETE|MPI|AUD_UPD_AGENT|MPISYS
INSERT|MPI|AUD_UPD_AGENT|MPISYS
SELECT|MPI|AUD_UPD_AGENT|MPISYS
UPDATE|MPI|AUD_UPD_AGENT|MPISYS
DELETE|MPI|BDYMOD|MPISYS
INSERT|MPI|BDYMOD|MPISYS
SELECT|MPI|BDYMOD|MPISYS
UPDATE|MPI|BDYMOD|MPISYS
DELETE|MPI|BDYMOD_DESC|MPISYS... (4 Replies)
Hi everyone,
Has anyone figured out yet how to do pivot table averages using AWK. I didn't see anything with regards to doing averages.
For example, suppose you have the following table with various individuals and their scores in round1 and round2:
SAMPLE SCORE1 SCORE2
British ... (6 Replies)
hi team
With below results in Db2 v10.5 . Please refer column A and B are same,while Staus column defers with distinct values .
A B STATUS
Insert Update Old
Insert Update New
Insert Update Final
Can someone guide how to... (2 Replies)
Hi all, I am new to shell scripting so pardon me for the questions I will be asking.
I was given a task where I have to pivot my data
Example
Source
SGPAPCTUMACCHEA
Expected output
SGP APC TUM
SGP APC ACC
SGP APC HEA
Can anybody assist me on this?Please use CODE tags as required... (3 Replies)
Discussion started by: redaela
3 Replies
LEARN ABOUT DEBIAN
html::microformats::format::halarm
HTML::Microformats::Format::hAlarm(3pm) User Contributed Perl Documentation HTML::Microformats::Format::hAlarm(3pm)NAME
HTML::Microformats::Format::hAlarm - an hCalendar alarm component
SYNOPSIS
use Data::Dumper;
use HTML::Microformats::DocumentContext;
use HTML::Microformats::Format::hCalendar;
my $context = HTML::Microformats::DocumentContext->new($dom, $uri);
my @cals = HTML::Microformats::Format::hCalendar->extract_all(
$dom->documentElement, $context);
foreach my $cal (@cals)
{
foreach my $ev ($cal->get_vevent)
{
foreach my $alarm ($ev->get_valarm)
{
print $alarm->get_description . "
";
}
}
}
DESCRIPTION
HTML::Microformats::Format::hAlarm is a helper module for HTML::Microformats::Format::hCalendar. This class is used to represent alarm
components within calendars. Generally speaking, you want to use HTML::Microformats::Format::hCalendar instead.
HTML::Microformats::Format::hAlarm inherits from HTML::Microformats::Format. See the base class definition for a description of property
getter/setter methods, constructors, etc.
Additional Method
o "to_icalendar"
This method exports the data in iCalendar format. It requires RDF::iCalendar to work, and will throw an error at run-time if it's not
available.
BUGS
Please report any bugs to <http://rt.cpan.org/>.
SEE ALSO
HTML::Microformats::Format::hCalendar, HTML::Microformats::Format, HTML::Microformats.
AUTHOR
Toby Inkster <tobyink@cpan.org>.
COPYRIGHT
Copyright 2008-2011 Toby Inkster
This library is free software; you can redistribute it and/or modify it under the same terms as Perl itself.
DISCLAIMER OF WARRANTIES
THIS PACKAGE IS PROVIDED "AS IS" AND WITHOUT ANY EXPRESS OR IMPLIED WARRANTIES, INCLUDING, WITHOUT LIMITATION, THE IMPLIED WARRANTIES OF
MERCHANTIBILITY AND FITNESS FOR A PARTICULAR PURPOSE.
perl v5.14.2 2011-12-06 HTML::Microformats::Format::hAlarm(3pm)