dbcolmerge - Man Page

merge multiple columns into one

Synopsis

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

Description

For each row, merge multiple columns down to a single column (always a string), 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.
--header H: Use H as the full Fsdb header, rather than reading a header from then input.
--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

AUTHOR and COPYRIGHT

This program is distributed under terms of the GNU general public license, version 2. See the file COPYING with the distribution for details.

Referenced By

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

2024-08-02 perl v5.40.0 User Contributed Perl Documentation