1DBCOLMERGE(1) User Contributed Perl Documentation DBCOLMERGE(1)
2
3
4
6 dbcolmerge - merge multiple columns into one
7
9 dbcolmerge [-C ElementSeparator] [columns...]
10
12 For each row, merge multiple columns down to a single column (always a
13 string), joining elements with ElementSeparator (defaults to a single
14 underscore).
15
17 -C S or --element-separator S
18 Specify the separator used to join columns. (Defaults to a single
19 underscore.)
20
21 -e E or --empty E
22 give value E as the value for empty (null) records
23
24 This module also supports the standard fsdb options:
25
26 -d Enable debugging output.
27
28 -i or --input InputSource
29 Read from InputSource, typically a file name, or "-" for standard
30 input, or (if in Perl) a IO::Handle, Fsdb::IO or Fsdb::BoundedQueue
31 objects.
32
33 -o or --output OutputDestination
34 Write to OutputDestination, typically a file name, or "-" for
35 standard output, or (if in Perl) a IO::Handle, Fsdb::IO or
36 Fsdb::BoundedQueue objects.
37
38 --autorun or --noautorun
39 By default, programs process automatically, but Fsdb::Filter
40 objects in Perl do not run until you invoke the run() method. The
41 "--(no)autorun" option controls that behavior within Perl.
42
43 --header H
44 Use H as the full Fsdb header, rather than reading a header from
45 then input.
46
47 --help
48 Show help.
49
50 --man
51 Show full manual.
52
54 Input:
55 #fsdb first last
56 John Heidemann
57 Greg Johnson
58 Root -
59 # this is a simple database
60 # | /home/johnh/BIN/DB/dbcol fullname
61 # | dbcolrename fullname first_last
62 # | /home/johnh/BIN/DB/dbcolsplit -C _ first_last
63 # | /home/johnh/BIN/DB/dbcol first last
64
65 Command:
66 cat data.fsdb | dbcolmerge -C _ first last
67
68 Output:
69 #fsdb first last first_last
70 John Heidemann John_Heidemann
71 Greg Johnson Greg_Johnson
72 Root - Root_
73 # this is a simple database
74 # | /home/johnh/BIN/DB/dbcol fullname
75 # | dbcolrename fullname first_last
76 # | /home/johnh/BIN/DB/dbcolsplit first_last
77 # | /home/johnh/BIN/DB/dbcol first last
78 # | /home/johnh/BIN/DB/dbcolmerge -C _ first last
79
81 Fsdb. dbcolsplittocols. dbcolsplittorows. dbcolrename.
82
84 Copyright (C) 1991-2022 by John Heidemann <johnh@isi.edu>
85
86 This program is distributed under terms of the GNU general public
87 license, version 2. See the file COPYING with the distribution for
88 details.
89
90
91
92perl v5.34.1 2022-04-04 DBCOLMERGE(1)