NAME

dbcolsplittocols - split an existing column into multiple new columns

SYNOPSIS

dbcolsplittocols [-E] [-C ElementSeparator] column [column...]

DESCRIPTION

Create new columns by spliting an existing column. The fragments of the column are each divided by ElementSeparator (default is underscore).

This command is the opposite of dbcolmerge. Names of the new columns are given by splitting the name of the existing column. dbcolrename may be useful to set column names.

OPTIONS

-C S or --element-separator S

Specify the separator S used to join columns. (Defaults to a single underscore.)

-E or --enumerate

Enumerate output columns: rather than assuming the column name uses teh element separator, we keep it whole and fill in with indexes starting from 0. (Not currently implemented, but planned. See dbcolsplittorows.)

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
#  | dbcolrename fullname first_last
#  | /home/johnh/BIN/DB/dbcol first_last

Command:

cat data.fsdb | dbcolsplittocols first_last

Output:

#fsdb      first_last      first   last
John_Heidemann  John    Heidemann
Greg_Johnson    Greg    Johnson
Root    Root
# this is a simple database
#  | dbcolrename fullname first_last
#  | /home/johnh/BIN/DB/dbcol first_last
#  | /home/johnh/BIN/DB/dbcolsplittocols first_last

SEE ALSO

Fsdb(3). dbcolmerge(1). dbcolsplittorows(1). dbcolrename(1).

CLASS FUNCTIONS

new

$filter = new Fsdb::Filter::dbcolsplittocols(@arguments);

Create a new dbcolsplittocols object, taking command-line arguments.

set_defaults

$filter->set_defaults();

Internal: set up defaults.

parse_options

$filter->parse_options(@ARGV);

Internal: parse command-line arguments.

setup

$filter->setup();

Internal: setup, parse headers.

run

$filter->run();

Internal: run over each rows.

AUTHOR and COPYRIGHT

Copyright (C) 1991-2008 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.

cpanm Fsdb

perl -MCPAN -e shell
install Fsdb