1CSV_TO_DB(1) User Contributed Perl Documentation CSV_TO_DB(1)
2
3
4
6 csv_to_db - convert comma-separated-value data into fsdb
7
9 csv_to_db <source.csv
10
12 Converts a comma-separated-value data stream to Fsdb format.
13
14 The input is CSV-format (not fsdb). The first row is taken to be the
15 names of the columns.
16
17 The output is two-space-separated fsdb. (Someday more general field
18 separators should be supported.) Fsdb fields are normalized version of
19 the CSV file: spaces are converted to single underscores.
20
22 -F or --fs or --fieldseparator S
23 Specify the field (column) separator as "S". See dbfilealter for
24 valid field separators. Default is S (double space).
25
26 This module also supports the standard fsdb options:
27
28 -d Enable debugging output.
29
30 -i or --input InputSource
31 Read from InputSource, typically a file name, or "-" for standard
32 input, or (if in Perl) a IO::Handle, Fsdb::IO or Fsdb::BoundedQueue
33 objects.
34
35 -o or --output OutputDestination
36 Write to OutputDestination, typically a file name, or "-" for
37 standard output, or (if in Perl) a IO::Handle, Fsdb::IO or
38 Fsdb::BoundedQueue objects.
39
40 --autorun or --noautorun
41 By default, programs process automatically, but Fsdb::Filter
42 objects in Perl do not run until you invoke the run() method. The
43 "--(no)autorun" option controls that behavior within Perl.
44
45 --help
46 Show help.
47
48 --man
49 Show full manual.
50
52 Input:
53 paper,papertitle,reviewer,reviewername,score1,score2,score3,score4,score5
54
55 1,"test, paper",2,Smith,4,4,,,
56 2,other paper,3,Jones,3,3,,,
57
58 Command:
59 csv_to_db
60
61 Output:
62 #fsdb -F S paper papertitle reviewer reviewername score1 score2 score3 score4 score5
63 1 test, paper 2 Smith 4 4 - - -
64 2 other paper 3 Jones 3 3 - - -
65 # | csv_to_db
66
68 Fsdb. db_to_csv.
69
71 Copyright (C) 1991-2008 by John Heidemann <johnh@isi.edu>
72
73 This program is distributed under terms of the GNU general public
74 license, version 2. See the file COPYING with the distribution for
75 details.
76
77
78
79perl v5.30.0 2019-09-19 CSV_TO_DB(1)