Fsdb::F...sv_to_db(3)

okay bestie, welcome to the Fsdb::F...sv_to_db(3) page from the User Contributed Perl Documentation — it’s giving “CSV goes in, fsdb comes out,” and we’re gonna get through it together 💖

✨ NAME ✨

csv_to_db — convert comma-separated-value data into fsdb. That’s the whole assignment, no cap.

🌸 SYNOPSIS 🌸

csv_to_db <source.csv

🦋 DESCRIPTION 🦋

Converts a comma-separated-value data stream to Fsdb format. Literally the main character move of this whole program.

The input is CSV-format (not fsdb, bestie — don’t get it twisted). The first row is taken to be the names of the columns, so that row is doing important label duty.

The output is two-space-separated fsdb. (Someday more general field separators should be supported.) Fsdb fields are a normalized version of the CSV file: spaces are converted to single underscores. Slay, normalization.

💅 OPTIONS 💅

• -F, --fs, --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. Detective mode: on.
• -i, --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, --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, --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. We love a quick assist.
• --man — Show full manual. You are here, bestie.

🎀 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 🔥

Go check out Fsdb. And also db_to_csv — the other direction of the pipeline friendship, iykyk.

👑 CLASS FUNCTIONS 👑

🧚 new

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

Create a new csv_to_db object, taking command-line arguments. Fresh object, fresh vibes.

🍓 set_defaults

$filter->set_defaults();

Internal: set up defaults. Somebody has to do the behind-the-scenes work.

🦋 parse_options

$filter->parse_options(@ARGV);

Internal: parse command-line arguments. Reading the room, option-style.

🌸 setup

$filter->setup();

Internal: setup, parse headers. Getting the whole situation organized.

⭐ run

$filter->run();

Internal: run over each rows. Row by row, we move.

💜 AUTHOR and COPYRIGHT 💜

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! cute little sign-off: perl v5.32.1, date 2024-08-02, page Fsdb::F...sv_to_db(3) — periodt 💖✨