csv_to_db - convert comma-separated-value data into fsdb
csv_to_db <source.csv
Converts a comma-separated-value data stream to Fsdb format.
The input is CSV-format (not fsdb). The first row is taken to be the names of the columns.
The output is two-space-separated fsdb. (Someday more general field separators should be supported.) Fsdb fields are normalized version of the CSV file: spaces are converted to single underscores.
Specify the field (column) separator as S. See dbfilealter for valid field separators. Default is S (double space).
S
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
Show help.
Show full manual.
paper,papertitle,reviewer,reviewername,score1,score2,score3,score4,score5 1,"test, paper",2,Smith,4,4,,, 2,other paper,3,Jones,3,3,,,
csv_to_db
#fsdb -F S paper papertitle reviewer reviewername score1 score2 score3 score4 score5 1 test, paper 2 Smith 4 4 - - - 2 other paper 3 Jones 3 3 - - - # | csv_to_db
Fsdb. db_to_csv.
$filter = new Fsdb::Filter::csv_to_db(@arguments);
Create a new csv_to_db 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-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.
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.