dbcolmerge man page

dbcolmerge — merge multiple columns into one

Synopsis

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

Description

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

Options

-C S or --element-separator S
Specify the separator used to join columns. (Defaults to a single underscore.)
-e E or --empty E
give value E as the value for empty (null) records

This module also supports the standard fsdb options:

-d
Enable debugging output.
-i or --input InputSource
Read from InputSource, typically a file name, or "-" for standard input, or (if in Perl) a IO::Handle, Fsdb::IO or Fsdb::BoundedQueue objects.
-o or --output OutputDestination
Write to OutputDestination, typically a file name, or "-" for standard output, or (if in Perl) a IO::Handle, Fsdb::IO or Fsdb::BoundedQueue objects.
--autorun or --noautorun
By default, programs process automatically, but Fsdb::Filter objects in Perl do not run until you invoke the run() method. The "--(no)autorun" option controls that behavior within Perl.
--help
Show help.
--man
Show full manual.

Sample Usage

Input

#fsdb      first   last
John    Heidemann
Greg    Johnson
Root    -
# this is a simple database
#  | /home/johnh/BIN/DB/dbcol fullname
#  | dbcolrename fullname first_last
#  | /home/johnh/BIN/DB/dbcolsplit -C _ first_last
#  | /home/johnh/BIN/DB/dbcol first last

Command

cat data.fsdb | dbcolmerge -C _ first last

Output

#fsdb      first   last    first_last
John    Heidemann       John_Heidemann
Greg    Johnson Greg_Johnson
Root    -        Root_
# this is a simple database
#  | /home/johnh/BIN/DB/dbcol fullname
#  | dbcolrename fullname first_last
#  | /home/johnh/BIN/DB/dbcolsplit first_last
#  | /home/johnh/BIN/DB/dbcol first last
#  | /home/johnh/BIN/DB/dbcolmerge -C _ first last

See Also

Fsdb. dbcolsplittocols. dbcolsplittorows. dbcolrename.

Referenced By

dbcolsplittocols(1), dbcolsplittorows(1), dbfilepivot(1).

2016-11-30 perl v5.24.0 User Contributed Perl Documentation