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

NAME

6       dbcolmerge - merge multiple columns into one
7

SYNOPSIS

9       dbcolmerge [-C ElementSeparator] [columns...]
10

DESCRIPTION

12       For each row, merge multiple columns down to a single column, joining
13       elements with ElementSeparator (defaults to a single underscore).
14

OPTIONS

16       -C S or --element-separator S
17           Specify the separator used to join columns.  (Defaults to a single
18           underscore.)
19
20       -e E or --empty E
21           give value E as the value for empty (null) records
22
23       This module also supports the standard fsdb options:
24
25       -d  Enable debugging output.
26
27       -i or --input InputSource
28           Read from InputSource, typically a file name, or "-" for standard
29           input, or (if in Perl) a IO::Handle, Fsdb::IO or Fsdb::BoundedQueue
30           objects.
31
32       -o or --output OutputDestination
33           Write to OutputDestination, typically a file name, or "-" for
34           standard output, or (if in Perl) a IO::Handle, Fsdb::IO or
35           Fsdb::BoundedQueue objects.
36
37       --autorun or --noautorun
38           By default, programs process automatically, but Fsdb::Filter
39           objects in Perl do not run until you invoke the run() method.  The
40           "--(no)autorun" option controls that behavior within Perl.
41
42       --header H
43           Use H as the full Fsdb header, rather than reading a header from
44           then input.
45
46       --help
47           Show help.
48
49       --man
50           Show full manual.
51

SAMPLE USAGE

53   Input:
54           #fsdb      first   last
55           John    Heidemann
56           Greg    Johnson
57           Root    -
58           # this is a simple database
59           #  | /home/johnh/BIN/DB/dbcol fullname
60           #  | dbcolrename fullname first_last
61           #  | /home/johnh/BIN/DB/dbcolsplit -C _ first_last
62           #  | /home/johnh/BIN/DB/dbcol first last
63
64   Command:
65           cat data.fsdb | dbcolmerge -C _ first last
66
67   Output:
68           #fsdb      first   last    first_last
69           John    Heidemann       John_Heidemann
70           Greg    Johnson Greg_Johnson
71           Root    -        Root_
72           # this is a simple database
73           #  | /home/johnh/BIN/DB/dbcol fullname
74           #  | dbcolrename fullname first_last
75           #  | /home/johnh/BIN/DB/dbcolsplit first_last
76           #  | /home/johnh/BIN/DB/dbcol first last
77           #  | /home/johnh/BIN/DB/dbcolmerge -C _ first last
78

SEE ALSO

80       Fsdb.  dbcolsplittocols.  dbcolsplittorows.  dbcolrename.
81
83       Copyright (C) 1991-2018 by John Heidemann <johnh@isi.edu>
84
85       This program is distributed under terms of the GNU general public
86       license, version 2.  See the file COPYING with the distribution for
87       details.
88
89
90
91perl v5.32.0                      2020-11-16                     DBCOLMERGE(1)
Impressum