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 PHP
apc_bin_dumpfile
APC_BIN_DUMPFILE(3) 1 APC_BIN_DUMPFILE(3)apc_bin_dumpfile - Output a binary dump of cached files and user variables to a fileSYNOPSIS
int apc_bin_dumpfile (array $files, array $user_vars, string $filename, [int $flags], [resource $context = NULL])
DESCRIPTION
Outputs a binary dump of the given files and user variables from the APC cache to the named file.
PARAMETERS
o $files
- The file names being dumped.
o $user_vars
- The user variables being dumped.
o $filename
- The filename where the dump is being saved.
o $flags
- Flags passed to the $filename stream. See the file_put_contents(3) documentation for details.
o $context
- The context passed to the $filename stream. See the file_put_contents(3) documentation for details.
RETURN VALUES
The number of bytes written to the file, otherwise FALSE if APC is not enabled, $filename is an invalid file name, $filename can't be
opened, the file dump can't be completed (e.g., the hard drive is out of disk space), or an unknown error was encountered.
SEE ALSO apc_bin_dump(3), apc_bin_load(3).
PHP Documentation Group APC_BIN_DUMPFILE(3)