1
2
3
4
5
6
7
8
9
10
11
12
13
14
15
16
17
18
19
20
21
22
23
24
25
26
27
28
29
30
31
32
33
34
35
36
37
38
39
40
41
42
43
44
45
46
47
48
49
50
51
52
53
54
55
56
57
58
59
60
61
62
63
64
65
66
67
68
69
70
71
72
73
74
75
76
77
78
79
80
81
82
83
84
85
86
87
88
89
90
91
92
93
94
95
96
97
98
99
100
101
102
103
104
105
106
107
108
|
#!/usr/bin/mawk -We
# *********************************************************************
# Written by and copyright Carlo Strozzi <carlos@linux.it>.
#
# total: sums up selected table columns.
# Copyright (C) 2001 Carlo Strozzi <carlos@linux.it>
#
# 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
# MERCHANTABILITY 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., 675 Mass Ave, Cambridge, MA 02139, USA.
#
# 2001-03-16 Alpha code.
# 2001-04-18 Added inline help
# 2001-08-17 Added stdio portability
#
# $Id$
# *********************************************************************
BEGIN {
NULL = ""; FS = OFS = "\t"
while (ARGV[++i] != NULL) {
if (ARGV[i] == "-l" || ARGV[i] == "--last") pick_last = 1
else if (ARGV[i] == "-N" || ARGV[i] == "--no-header") no_hdr = 1
else if (ARGV[i] == "-r" || ARGV[i] == "--report") report = 1
else if (ARGV[i] == "-i" || ARGV[i] == "--input") i_file = ARGV[++i]
else if (ARGV[i] == "-o" || ARGV[i] == "--output") o_file = ARGV[++i]
else if (ARGV[i] == "-T" || ARGV[i] == "--total") gtcol = ARGV[++i]
else if (ARGV[i] == "-h" || ARGV[i] == "--help") {
system("grep -v '^#' @DOCPATH@/total.txt")
rc = 1
exit(rc)
}
else target_cols[ARGV[i]] = ARGV[i]
}
ARGC = 1 # Fix argv[]
if (o_file == NULL) o_file = "@STDOUT@"
if (i_file != NULL) { ARGV[1] = i_file; ARGC = 2 }
}
#
# Main loop
#
NR == 1 {
# Load the column position array.
while (++p <= NF) {
# Unless '-l' was specified, make sure we pick the first occurrence
# of duplicated column names (it may happen after a join).
if (P[$p] == NULL) auto_col = auto_col " " $p
if (pick_last) { P[$p] = p; N[p] = $p }
else {
if (P[$p] == NULL) { P[$p] = p; N[p] = $p }
}
}
if (gtcol != NULL) $0 = $0 OFS gtcol
if (!no_hdr) print > o_file
gsub(/[^\t]/, "-")
dashline = $0
next
}
# Dashline
NR == 2 {
if (!no_hdr) print dashline > o_file
next
}
# Table body.
{
for (i=1; i<=NF; i++) {
if (target_cols[N[i]] != NULL) total[i] += $i
}
if (gtcol != NULL) $0 = $0 OFS
if (report) print
}
END {
if (rc) exit(rc)
if (report) print dashline
for (i=1; i<=NF; i++) {
if (i > 1) printf(OFS) > o_file
if (gtcol != NULL && target_cols[N[i]] != NULL) gt += total[i]
printf("%s", total[i]) > o_file
}
if (gtcol != NULL) printf("%s", gt)
printf("\n") > o_file
}
#
# End of program.
#
|
