Fsdb::F...olmerge(3)

💖 NAME 💖

dbcolmerge — merge multiple columns into one. okay so this is the Fsdb::F...olmerge(3) manual page, bestie, and it's literally about smashing columns together. 💅

✨ SYNOPSIS ✨

dbcolmerge [-C ElementSeparator] [columns...]

That's the whole entrance. No cap.

🦋 DESCRIPTION 🦋

For each row, merge multiple columns down to a single column (always a string), joining elements with ElementSeparator (defaults to a single underscore). It's giving "column group chat becomes one iconic message", fr fr. 🎀

🌸 OPTIONS 🌸

• -C S or --element-separator S — Specify the separator used to join columns. (Defaults to a single underscore.) Pick your separator, bestie — this is the glue holding the whole merge together. ✨
• -e E or --empty E — give value E as the value for empty (null) records. So empty records get your chosen value. 🫶

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.
• --header H — Use H as the full Fsdb header, rather than reading a header from then input. (Not me pointing out the "then input" typo — I'm just keeping it exactly as the page says. 🙈)
• --help — Show help.
• --man — Show full manual.

---

🍓 SAMPLE USAGE 🍓

Input:

#fsdb      first   last
John    Heidemann
Greg    Johnson
Root    -
# this is a simple database
#  | /home/johnh/BIN/DB/dbcol fullname
#  | dbcolrename fullname first_last
#  | /home/johnh/BIN/DB/dbcolsplit -C _ first_last
#  | /home/johnh/BIN/DB/dbcol first last

Command:

cat data.fsdb | dbcolmerge -C _ first last

Output:

#fsdb      first   last    first_last
John    Heidemann       John_Heidemann
Greg    Johnson Greg_Johnson
Root    -        Root_
# this is a simple database
#  | /home/johnh/BIN/DB/dbcol fullname
#  | dbcolrename fullname first_last
#  | /home/johnh/BIN/DB/dbcolsplit first_last
#  | /home/johnh/BIN/DB/dbcol first last
#  | /home/johnh/BIN/DB/dbcolmerge -C _ first last

Look at that output — John_Heidemann, Greg_Johnson, Root_. The merge ate and left no crumbs. 👑🔥

🌈 SEE ALSO 🌈

Fsdb. dbcolsplittocols. dbcolsplittorows. dbcolrename.

👑 CLASS FUNCTIONS 👑

🌟 new 🌟

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

Create a new dbcolmerge object, taking command-line arguments.

🌟 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-2022 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.

---

mwah 💋 this page was cooked with perl v5.32.1 on 2024-08-02, and it's the Fsdb::F...olmerge(3) manual. Bye bestie, go merge something iconic! 🫶✨ periodt.