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
ijsgutenprint
IJSGUTENPRINT(1) Gutenprint Manual Pages IJSGUTENPRINT(1)NAME
ijsgutenprint - Ghostscript driver for Gutenprint
SYNOPSIS
gs -sDEVICE=ijs -sIjsServer=/usr/bin/ijsgutenprint -sDeviceManufacturer=vendor-sDeviceModel=name [ -dIjsUseOutputFD ] -sIjsParams=[
key1=value1,keyn=valuen... ] [ options ] [ files ]
DESCRIPTION
ijsgutenprint provides Ghostscript with a Gutenprint driver, supporting all printers supported by libgutenprint.
NOTE: ijsgutenprint should never be called directly. Ghostscript will run it if the IjsServer parameter is set to IjsServer=ijsgutenprint
when invoking the IJS driver.
NOTE: The only supported method of running ijsgutenprint is via Foomatic. Users running ghostscript directly will not be supported. The
driver name used by Foomatic is gutenprint-ijs.5.2.
OPTIONS
ijsgutenprint accepts the following Ghostscript IJS options. The Gutenprint-specific options are not documented here.
-dIjsUseOutputFD
This option should be specified whenever output from Ghostscript will go to stdout or into a pipe. It may be specified in all other
cases, with only a slight performance degradation.
-sIjsParams=Option1=Value1,Option2=Value2
This parameter contains a single string containing a comma-separated list of sub-options.
-sDeviceManufacturer=vendor -sDeviceModel=name
This option must be supplied. There is no default. The IJS driver requires the vendor (it's part of the protocol), but the
ijsgutenprint driver ignores it.
HISTORY
The Ghostscript stp driver was originally written by Henryk Richter (buggs@comlab.uni-rostock.de), and was integrated into Gutenprint dur-
ing the 3.1 development series. Gutenprint (which was named Gimp-Print prior to release 5.0) itself was originally written by Michael
Sweet <mike@easysw.com>, who released up to version 2.0; Robert Krawitz released version 3.0. The Gutenprint development team
(http://gimp-print.sourceforge.net) now maintains the entire package.
The IJS driver was originally written by Russell Lang, and incorporated into Gutenprint (known then as Gimp-Print) in early 2002. This
driver corresponds with the IJS protocol 0.32.
The stp driver is no longer supported as of Gutenprint 5.0.
COPYRIGHT
Copyright (C) 2001-2006 Robert Krawitz (rlk@alum.mit.edu)
This program is free software; you can redistribute it and/or modify it under the terms of the GNU General Public License as published by
the Free Software Foundation; either version 2 of the License, or (at your option) any later version.
This program is distributed in the hope that it will be useful, but WITHOUT ANY WARRANTY; without even the implied warranty of MER-
CHANTABILITY or FITNESS FOR A PARTICULAR PURPOSE. See the GNU General Public License for more details.
You should have received a copy of the GNU General Public License along with this program; if not, write to the Free Software Foundation,
Inc., 59 Temple Place - Suite 330, Boston, MA 02111-1307, USA.
AUTHORS
Robert Krawitz. Originally written by Russell Lang.
This manual page was written by Robert Krawitz (rlk@alum.mit.edu) and Roger Leigh (rleigh@debian.org).
SEE ALSO gs(1)Version 5.2.4 26 Jul 2009 IJSGUTENPRINT(1)