dbcolmerge (1) Linux Manual 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.AUTHOR and COPYRIGHT
Copyright (C) 1991-2008 by John Heidemann <johnh [at] 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.