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 All,
I am trying to pivot the contents in a file.
Ex: I have a file sample.txt with data "A B C D", i need the contents to pivot & resulting file should look like "A
B
C
... (3 Replies)
I would like to use awk to parse a file with three columns in, like:
Chennai,01,1
Chennai,07,1
Chennai,08,3
Chennai,09,6
Chennai,10,12
Chennai,11,19
Chennai,12,10
Chennai,13,12
Kerala,09,2
AP,10,1
AP,11,1
Delhi,13,1
Kerala,13,3
Chennai,00,3
Chennai,01,1
Chennai,02,1
Chennai,07,5 (3 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)
Hi All ,
I have a file as below .
A "1"
B "2"
C "3"
D "4"
E "5"
F "6"
A "11"
B "21"
C "31"
D "41"
E "51"
F "61"
And the output should be like
A B C D E F
1 2 3 4 5 6
11 21 31 41 51 (8 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)
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)
Discussion started by: Perlbaby
2 Replies
LEARN ABOUT FREEBSD
mkcsmapper
MKCSMAPPER(1) BSD General Commands Manual MKCSMAPPER(1)NAME
mkcsmapper -- generates hashed conversion data for iconv(3)SYNOPSIS
mkcsmapper [-mpd] -o outfile infile
DESCRIPTION
The mkcsmapper utility generates binary conversion data from plain text conversion tables for the iconv(3) library. The conversion data has
two components: The conversion mapping between specific character encodings. A pivot file, which the possible source and destination encod-
ing pairs or the set of mappings to use for a compound encoding.
The following options are available:
-d Turns on debug mode.
-m Generate mapping data from infile.
-o outfile
Put generated binary data to outfile.
-p Generate pivot data from outfile.
EXIT STATUS
The mkcsmapper utility exits 0 on success, and >0 if an error occurs.
SEE ALSO iconv(1), mkesdb(1), iconv(3)HISTORY
mkcsmapper first appeared in NetBSD 2.0, and made its appearance in FreeBSD 9.0.
AUTHORS
This manual page was written by Gabor Kovesdan <gabor@FreeBSD.org>.
BSD Sep 6, 2009 BSD
03-26-2019
