DBCOLSPLITTOCOLS(1)

💖 dbcolsplittocols — DBCOLSPLITTOCOLS(1) 💖

okay bestie, gather round: this is a User Contributed Perl Documentation page for dbcolsplittocols, aka DBCOLSPLITTOCOLS(1). It's giving main character energy, it ate, and the vibe check says: split one column into several new ones. No cap. 💅

✨ SYNOPSIS ✨

dbcolsplittocols [-E] [-C ElementSeparator] column

🌸 DESCRIPTION 🌸

Create new columns by splitting an existing column. The fragments of the column are each divided by ElementSeparator (default is underscore).

This command is literally the opposite of dbcolmerge. Names of the new columns are given by splitting the name of the existing column. dbcolrename may be useful to set column names.

Input treated as strings and output columns are of type string. fr fr.

🎀 OPTIONS 🎀

🦋 the dbcolsplittocols-specific ones 🦋

• -C S or --element-separator S — specify the separator S used to join columns. Usually a single character, it can also be a regular expression (so, for example, [,_] matches either , or _ as an element separator). Defaults to a single underscore.
• -E or --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. Not currently implemented, but planned. See dbcolsplittorows.
• -N on --new-name — specify the names of the new columns as a space separated list. Default is to apply the separator to the name of the column that is being split. (The original really prints on here, not or — we're keeping it exactly as printed 🙈.)

By default, column "a_b" will split to columns a and b. If the column is given as ab with option "-N 'a b'", one will get the same result.

• -E or --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. Not currently implemented, but planned. See dbcolsplittorows.

bestie, yes, -E/--enumerate is literally listed twice in the original. We're keeping both so nothing gets lost 💅.

🌈 standard fsdb options 🌈

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 the input.
• --help — show help.
• --man — show full manual.

🍓 SAMPLE USAGE 🍓

📥 Input:

#fsdb      first_last
John_Heidemann
Greg_Johnson
Root
# this is a simple database
#  | dbcolrename fullname first_last
#  | /home/johnh/BIN/DB/dbcol first_last

🪄 Command:

cat data.fsdb | dbcolsplittocols first_last

📤 Output:

#fsdb      first_last      first   last
John_Heidemann  John    Heidemann
Greg_Johnson    Greg    Johnson
Root    Root
# this is a simple database
#  | dbcolrename fullname first_last
#  | /home/johnh/BIN/DB/dbcol first_last
#  | /home/johnh/BIN/DB/dbcolsplittocols first_last

👑 SEE ALSO 👑

Fsdb(3). dbcolmerge(1). dbcolsplittorows(1). dbcolrename(1).

💜 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 is from perl v5.32.1, dated 2024-08-02, and yes bestie it's the DBCOLSPLITTOCOLS(1) manual. periodt. 🫶