Please help me to do Vertical an horizontal pivoing in unix in single run.
The input file is like this-
MRKT|PROD|PRD|FACT1|FACT2|FACT3|FACT4
M1|P1|PR1|F11|F12|F13|F14
M1|P1|PR2|F21|F22|F23|F24
M1|P1|PR3|F31|F32|F33|F34
M2|P2|PR1|F41|F42|F43|F44
M2|P2|PR2|F51|F53|F54|F55... (4 Replies)
Hi Everyone,
I have three files.
FileA:
aaaa
aaaa
bb
ccc
FileB:
21
2
FileC:
eeeeeee
e
eee
ee
Would like to combine three of them, not like cat, to cat three files, but the output should be like: (3 Replies)
Hi,
Silly question, if I have an excel file that looks something like this:
................. Subject 1 Subject 2 Subject 3 Subject 4
Fever..............13...........9.............23..........14
Headache.........2............12...........18..........23... (3 Replies)
Based on input
ail,UTT,id1_0,COMBO,21,24,21,19,85
al,UTHAST,id1_0,COMBO,342,390,361,361,1454
and awk code as
awk -F, '{ K=0; for(i=NF; i>=(NF-4); i--) { K=K+$i; J=J+$i;} { print K } } END { for ( l in J ) printf("%s ",J); }'
I'm trying to add columns and lines in single line. line... (6 Replies)
Hi All,
please help to achieve the desired output
Example: I have a file which contains the below data
empname
robert
empid
787
design
consultant
empname
alex
empid
898
design
advocate
Desired output should be
empname empid design
robert 787 consultant (19 Replies)
I need to change data from vertical to horizontal but with condition
input
USA|80
AUS|40
BRA|33
VEGAS|40
KENTUCKY|50
NEWYORK|21
DARWIN|33
ADELAIDE|21
SAOPAOLO|44
RIO|89
GAPIZA|44
BENFLEX|32
AXIS|44
ACRE|56
HEIGHT|22 (5 Replies)
Hi Masters,
I need help to change my vertical data to horisontal
input
2015-04-13|JS|741667
2015-04-13|JSJ|2272
2015-04-13|TMS|107099
2015-04-12|JMD|47945
2015-04-13|TM|760024
2015-04-13|JM|484508
2015-04-14|JMJ|318
2015-04-14|JSD|54436
2015-04-13|JM|15410
Output... (2 Replies)
Hi,
I am creating a script that will pull data from database. The only thing missing now is that i have to transform the lines into horizontal list.
EXAMPLE
2015-07-15 09:00:00.0 |TCSERVER01 |5354
2015-07-15 09:01:00.0 |TCSERVER01 |6899 ... (5 Replies)
Discussion started by: reignangel2003
5 Replies
LEARN ABOUT DEBIAN
shprewind
SHAPELIB(1) User Commands SHAPELIB(1)NAME
shprewind - fix polygon ring orientations in ESRI shapefiles
SYNOPSIS
shprewind infile outfile
DESCRIPTION
Makes a copy of the shapefile infile to outfile and fixes the orientation of points in the rings of Polygon, PolygonZ, and PolygonM typed
shapes to conform to the shapefile specification. According to the specification, the vertices of outer rings should be oriented clockwise
on the X/Y plane, and those of inner rings counterclockwise.
Shapefiles actually consist of two files with the same basename and extensions .shp and .shx (or .SHP and .SHX) containing the shape data
and shape index respectively. The files to open are determined by first stripping any filename extension from infile and attempting to
open the files infile.shp or infile.SHP, and infile.shx or infile.SHX for the respective data and index files. The files to create from
outfile are determined by stripping any filename extension from outfile and appending .shp and .shx suffixes for the respective data and
index files.
EXIT STATUS
0 Successful program execution.
1 Missing infile or outfile arguments, failed to open shapefile infile or create shapefile outfile.
DIAGNOSTICS
The following diagnostics may be issued on stdout:
Unable to open:infile
Unable to create:outfile
count objects rewound.
AUTHORS
Frank Warmerdam (warmerdam@pobox.com) is the maintainer of the shapelib shapefile library. Joonas Pihlaja (jpihlaja@cc.helsinki.fi) wrote
this man page.
BUGS
The implementation assumes that there is at most one outer ring in each shape, that it is the first ring in a shape, and all other rings in
a shape are inner rings. Polygons inside MultiPatch shape types aren't rewound.
SEE ALSO dbfadd(1), dbfcreate(1), dbfdump(1), dbf_dump(1), shpadd(1), shpcreate(1), shpdump(1)shapelib OCTOBER 2004 SHAPELIB(1)