db_to_csv (1) Linux Manual Page
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_dbAUTHOR 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.
