CSV_TO_DB(1)

📦
version 3.9 · 3 versions
, in epel 9

💖 CSV_TO_DB(1) — csv_to_db 💖

okay so this is the CSV_TO_DB(1) page from the User Contributed Perl Documentation corner of the universe 🌈✨, and it's all about csv_to_db, bestie. Buckle up, it's giving useful.

✨ NAME ✨

csv_to_db — convert comma-separated-value data into fsdb 💅

🌸 SYNOPSIS 🌸

csv_to_db <source.csv

🦋 DESCRIPTION 🦋

Converts a comma-separated-value data stream to Fsdb format. no cap.

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. periodt.

💅 OPTIONS 💅

  • -F, --fs, or --fieldseparator S — specify the field (column) separator as S. See dbfilealter for valid field separators. Default is S (double space). 🎀

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:

paper,papertitle,reviewer,reviewername,score1,score2,score3,score4,score5

1,"test, paper",2,Smith,4,4,,,
2,other paper,3,Jones,3,3,,,

🍓 Command:

csv_to_db

🍓 Output:

#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

🔥 SEE ALSO 🔥

Fsdb. and db_to_csv. — that's the related reading, bestie. 🫶

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. ⚖️

okay that's the whole page, bestie — page CSV_TO_DB(1), source/version perl v5.32.1, dated 2024-08-02. byeee 💖🫶✨

📦 where this page comes from