1DBROWUNIQ(1)          User Contributed Perl Documentation         DBROWUNIQ(1)
2
3
4

NAME

6       dbrowuniq - eliminate adjacent rows with duplicate fields, maybe
7       counting
8

SYNOPSIS

10       dbrowuniq [-cFLB] [uniquifying fields...]
11

DESCRIPTION

13       Eliminate adjacent rows with duplicate fields, perhaps counting them.
14       Roughly equivalent to the Unix uniq command, but optionally only
15       operating on the specified fields.
16
17       By default, all columns must be unique.  If column names are specified,
18       only those columns must be unique and the first row with those columns
19       is returned.
20
21       Dbrowuniq eliminates only identical rows that adjacent.  If you want to
22       eliminate identical rows across the entirefile, you must make them
23       adajcent, perhaps by using dbsort on your uniquifying field.  (That is,
24       the input with three lines a/b/a will produce three lines of output
25       with both a's, but if you dbsort it, it will become a/a/b and dbrowuniq
26       will output a/b.
27
28       By default, dbrowuniq outputs the first unique row.  Optionally, with
29       "-L", it will output the last unique row, or with "-B" it outputs both
30       first and last.  (This choice only matters when uniqueness is
31       determined by specific fields.)
32
33       dbrowuniq can also count how many unique, adjacent lines it finds with
34       "-c", with the count going to a new column (defaulting to "count").
35       Incremental counting, when the "count" column already exists, is
36       possible with "-I".  With incremental counting, the existing count
37       column is summed.
38

OPTIONS

40       -c or --count
41           Create a new column (count) which counts the number of times each
42           line occurred.
43
44           The new column is named by the "-N" argument, defaulting to
45           "count".
46
47       -N on --new-name
48           Specify the name of the count column, if any.  Please specify the
49           type with the name, if desired (allowing one to pick sizes smaller
50           than the default quad, if desired).  (Default is "count:q".)
51
52       -I on --incremental
53           Incremental counting.  If the count column exists, it is assumed to
54           have a partial count and the count accumulates.  If the count
55           column doesn't exist, it is created.
56
57       -L or --last
58           Output the last unique row only.  By default, it outputs the first
59           unique row.
60
61       -F or --first
62           Output the first unique row only.  (This output is the default.)
63
64       -B or --both
65           Output both the first and last unique rows.
66
67       This module also supports the standard fsdb options:
68
69       -d  Enable debugging output.
70
71       -i or --input InputSource
72           Read from InputSource, typically a file name, or "-" for standard
73           input, or (if in Perl) a IO::Handle, Fsdb::IO or Fsdb::BoundedQueue
74           objects.
75
76       -o or --output OutputDestination
77           Write to OutputDestination, typically a file name, or "-" for
78           standard output, or (if in Perl) a IO::Handle, Fsdb::IO or
79           Fsdb::BoundedQueue objects.
80
81       --autorun or --noautorun
82           By default, programs process automatically, but Fsdb::Filter
83           objects in Perl do not run until you invoke the run() method.  The
84           "--(no)autorun" option controls that behavior within Perl.
85
86       --header H
87           Use H as the full Fsdb header, rather than reading a header from
88           then input.
89
90       --help
91           Show help.
92
93       --man
94           Show full manual.
95

SAMPLE USAGE

97   Input:
98           #fsdb      event
99           _null_getpage+128
100           _null_getpage+128
101           _null_getpage+128
102           _null_getpage+128
103           _null_getpage+128
104           _null_getpage+128
105           _null_getpage+4
106           _null_getpage+4
107           _null_getpage+4
108           _null_getpage+4
109           _null_getpage+4
110           _null_getpage+4
111           #  | /home/johnh/BIN/DB/dbcol event
112           #  | /home/johnh/BIN/DB/dbsort event
113
114   Command:
115           cat data.fsdb | dbrowuniq -c
116
117   Output:
118           #fsdb       event   count
119           _null_getpage+128   6
120           _null_getpage+4     6
121           #   2       /home/johnh/BIN/DB/dbcol        event
122           #  | /home/johnh/BIN/DB/dbrowuniq -c
123

SAMPLE USAGE 2

125       Retaining the last unique row as an example.
126
127   Input:
128               #fsdb event i
129               _null_getpage+128 10
130               _null_getpage+128 11
131               _null_getpage+128 12
132               _null_getpage+128 13
133               _null_getpage+128 14
134               _null_getpage+128 15
135               _null_getpage+4 16
136               _null_getpage+4 17
137               _null_getpage+4 18
138               _null_getpage+4 19
139               _null_getpage+4 20
140               _null_getpage+4 21
141               #  | /home/johnh/BIN/DB/dbcol event
142               #  | /home/johnh/BIN/DB/dbsort event
143
144   Command:
145           cat data.fsdb | dbrowuniq -c -L event
146
147   Output:
148               #fsdb event i count
149               _null_getpage+128       15      6
150               #  | /home/johnh/BIN/DB/dbcol event
151               #  | /home/johnh/BIN/DB/dbsort event
152               _null_getpage+4 21      6
153               #   | dbrowuniq -c
154

SAMPLE USAGE 3

156       Incremental counting.
157
158   Input:
159           #fsdb       event   count
160           _null_getpage+128   6
161           _null_getpage+128   6
162           _null_getpage+4     6
163           _null_getpage+4     6
164           #  /home/johnh/BIN/DB/dbcol event
165           #  | /home/johnh/BIN/DB/dbrowuniq -c
166
167   Command:
168           cat data.fsdb | dbrowuniq -I -c event
169
170   Output:
171               #fsdb event count
172               _null_getpage+128   12
173               _null_getpage+4     12
174               #  /home/johnh/BIN/DB/dbcol     event
175               #  | /home/johnh/BIN/DB/dbrowuniq -c
176               #   | dbrowuniq -I -c event
177

SEE ALSO

179       Fsdb.
180
182       Copyright (C) 1997-2022 by John Heidemann <johnh@isi.edu>
183
184       This program is distributed under terms of the GNU general public
185       license, version 2.  See the file COPYING with the distribution for
186       details.
187
188
189
190perl v5.38.0                      2023-07-20                      DBROWUNIQ(1)
Impressum