NAME

db_to_csv - convert fsdb to the comma-separated-value file-format

SYNOPSIS

db_to_csv [-C]

DESCRIPTION

Covert an existing fsdb file to comma-separated value format.

Input is fsdb format.

Output is CSV-format plain text (not fsdb).

OPTIONS

-C or <--omit-comments>

Also strip all comments.

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 -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  -  -  -
2  input double space  3  Jones  3  3  -  -  -
#  | csv_to_db 

Command:

cat data.fsdb | db_to_csv

Output:

paper,papertitle,reviewer,reviewername,score1,score2,score3,score4,score5
1,"test, paper",2,Smith,4,4,-,-,-
2,"other paper",3,Jones,3,3,-,-,-
2,"input double space",3,Jones,3,3,-,-,-
#  | csv_to_db 
#  | db_to_csv 

SEE ALSO

Fsdb. dbfilealter. csv_to_db

CLASS FUNCTIONS

new

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

Create a new db_to_csv 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 row.

AUTHOR and COPYRIGHT

Copyright (C) 2007-2018 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.