dbcolmerge - merge multiple columns into one
dbcolmerge [-C ElementSeparator] [columns...]
For each row, merge multiple columns down to a single column (always a string), joining elements with ElementSeparator (defaults to a single underscore).
Specify the separator used to join columns. (Defaults to a single underscore.)
give value E as the value for empty (null) records
This module also supports the standard fsdb options:
Enable debugging output.
Read from InputSource, typically a file name, or - for standard input, or (if in Perl) a IO::Handle, Fsdb::IO or Fsdb::BoundedQueue objects.
-
Write to OutputDestination, typically a file name, or - for standard output, or (if in Perl) a IO::Handle, Fsdb::IO or Fsdb::BoundedQueue objects.
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.
--(no)autorun
Use H as the full Fsdb header, rather than reading a header from then input.
Show help.
Show full manual.
#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
cat data.fsdb | dbcolmerge -C _ first last
#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
Fsdb. dbcolsplittocols. dbcolsplittorows. dbcolrename.
$filter = new Fsdb::Filter::dbcolmerge(@arguments);
Create a new dbcolmerge object, taking command-line arguments.
$filter->set_defaults();
Internal: set up defaults.
$filter->parse_options(@ARGV);
Internal: parse command-line arguments.
$filter->setup();
Internal: setup, parse headers.
$filter->run();
Internal: run over each rows.
Copyright (C) 1991-2022 by John Heidemann <johnh@isi.edu>
This program is distributed under terms of the GNU general public license, version 2. See the file COPYING with the distribution for details.
To install Fsdb, copy and paste the appropriate command in to your terminal.
cpanm
cpanm Fsdb
CPAN shell
perl -MCPAN -e shell install Fsdb
For more information on module installation, please visit the detailed CPAN module installation guide.