AnyDat...t::Tab(3pm)

💖 AnyData::Format::Tab — the bestie guide 💖

ok so this page lives in the User Contributed Perl Documentation section, section 3pm if you're keeping score, and it's all about AnyData::Format::Tab — a lil plug-in that gives you tiedhash and DBI/SQL access to Tab delimited files. tabs!! the humble tab, the icon, the moment. 🎀

---

✨ NAME ✨

AnyData::Format::Tab — tiedhash & DBI/SQL access to Tab delimited files 🦋

---

🌸 SYNOPSIS 🌸

ok bestie here's the vibe. two whole ways to do this:

 use AnyData;
 my $table = adHash( 'Tab', $filename,'r',$flags );
 while (my $row = each %$table) {
     print $row->{name},"\n" if $row->{country} =~ /us|mx|ca/;
 }
 # ... other tied hash operations

OR — and this is the other main character option 💅

 use DBI
 my $dbh = DBI->connect('dbi:AnyData:');
 $dbh->func('table1','Tab', $filename,$flags,'ad_catalog');
 my $hits = $dbh->selectall_arrayref( qq{
     SELECT name FROM table1 WHERE country = 'us'
 });
 # ... other DBI/SQL operations

like. literally two ways to eat. pick your fighter. 🔥

---

🧚 DESCRIPTION 🧚

so what even is this. it's a plug-in format parser for the AnyData and DBD::AnyData modules, no cap. it will read column names from the first row of the file, or it'll accept names passed by the user, whatever you prefer bestie, it's flexible like that ✨

and not just column names — you can set other options too, as follows:

  col_names   : a tab separated list of column names
  eol         : the end of record mark, \n by default
  quote_char  : the character used to quote fields " by default
  escape_char : the character used to escape the quote char, " by default

the way it's giving customizable 💅

heads up bestie!! if you're using this with DBD::AnyData, you gotta put ad_ in front of the flags, e.g. ad_eol. don't forget the prefix, that's the whole trick, iykyk 😭

and if you want further details (and honestly, you might!), please refer to the documentation for AnyData.pm and DBD::AnyData.pm. go read those, they eat. 📚

---

👑 AUTHOR & COPYRIGHT 👑

copyright 2000, Jeff Zucker <jeff@vpservices.com> all rights reserved

---

ok that's the whole page bestie, you're officially a Tab file girlie now 🌈

this iconic little doc shipped with perl v5.36.0 and got its glow-up on 2023-08-06 — and yeah, its own header/footer calls it AnyDat...t::Tab(3pm) because the terminal is dramatic and truncates things, but you and me both know the real name 💖 periodt.