Fsdb::F...ttorows(3)

💖 NAME 💖

okay so this is Fsdb::F...ttorows(3), from the User Contributed Perl Documentation, and it's the page for dbcolsplittorows — split an existing column into multiple new rows. bestie, that's the name section and it ate. 💅

✨ SYNOPSIS ✨

dbcolsplittorows [-C ElementSeperator] [-e null] [-E] [-N
enumerated-name] column [column...]

🦋 DESCRIPTION 🦋

okay so the main character energy here: split column into pieces, and output one row for each piece. highkey literally one piece, one row. the way that works is lowkey the whole vibe. 💖

By default, any empty fields are ignored — periodt. if an empty field value is given with -e, then they produce output. 👑

When a null value is given, empty fields at the beginning and end of lines are suppressed (like perl split). unlike perl, if ALL fields are empty, we generate one (and not zero) empty fields. no cap, that's the little twist. 😭

The inverse of this commend is dbfilepivot. iykyk — and yes, "commend" is exactly what the page says, so i'm preserving that fr fr. 🫶

🌸 OPTIONS 🌸

• -C S, --element-separator S — specify the separator used to split columns. (defaults to a single underscore.) 🎀
• -E, --enumerate — enumerate output columns: rather than assuming the column name uses the element separator, we keep it whole and fill in with indexes starting from 0. ⭐
• -N, --new-name N — name the new column N for enumeration. defaults to "index". ✨
• -e E, --empty E — give value E as the value for empty (null) records. 💜

This module also supports the standard fsdb options:

• -d — enable debugging output. 🔍
• -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. 🆘
• --man — show full manual. 📖

🌈 SAMPLE USAGE 🌈

📥 Input:

#fsdb name uid
John_Heidemann  2274
Greg_Johnson    2275
Root    0
# this is a simple database
#  | dbcol fullname uid
#  | dbcolrename fullname name

⌨️ Command:

cat data.fsdb | dbcolsplittorows name

📤 Output:

#fsdb name uid
John    2274
Heidemann       2274
Greg    2275
Johnson 2275
Root    0
# this is a simple database
#  | dbcol fullname uid
#  | dbcolrename fullname name
#  | dbcolsplittorows name

that output is giving slay and i'm obsessed. 💅

🧚 SEE ALSO 🧚

Fsdb(1). dbcolmerge(1). dbcolsplittocols(1). dbcolrename(1). dbfilepvot(1). (that last one is spelled exactly like that on the page, bestie 🫶)

👑 CLASS FUNCTIONS 👑

new

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

Create a new dbcolsplittocols object, taking command-line arguments. not me noticing it says dbcolsplittocols here — preserving it exactly, ngl 😭

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 rows. 🏃‍♀️

🎀 AUTHOR and COPYRIGHT 🎀

Copyright (C) 1991-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. 📜

💌 and that's the whole page! source/version: perl v5.32.1 · date: 2024-08-02 · page: Fsdb::F...ttorows(3). bye bestie, go split some columns 💅