Linux and UNIX Man Pages

Linux & Unix Commands - Search Man Pages

anydata::format::pipe(3pm) [debian man page]

AnyData::Format::Pipe(3pm)				User Contributed Perl Documentation				AnyData::Format::Pipe(3pm)

NAME
AnyData::Format::Pipe - tiedhash & DBI/SQL access to Pipe delimited files SYNOPSIS
use AnyData; my $table = adHash( 'Pipe', $filename,'r',$flags ); while (my $row = each %$table) { print $row->{name}," " if $row->{country} =~ /us|mx|ca/; } # ... other tied hash operations OR use DBI my $dbh = DBI->connect('dbi:AnyData:'); $dbh->func('table1','Pipe', $filename,$flags,'ad_catalog'); my $hits = $dbh->selectall_arrayref( qq{ SELECT name FROM table1 WHERE country = 'us' }); # ... other DBI/SQL operations DESCRIPTION
This is a plug-in format parser for the AnyData and DBD::AnyData modules. It will read column names from the first row of the file, or accept names passed by the user. In addition to column names, the user may set other options as follows: col_names : a pipe separated list of column names If you are using this with DBD::AnyData, put ad_ in front of the flags, e.g. ad_eol. Please refer to the documentation for AnyData.pm and DBD::AnyData.pm for further details. AUTHOR &; COPYRIGHT copyright 2000, Jeff Zucker <jeff@vpservices.com> all rights reserved perl v5.10.1 2004-08-17 AnyData::Format::Pipe(3pm)

Check Out this Related Man Page

AnyData::Format::HTMLtable(3pm) 			User Contributed Perl Documentation			   AnyData::Format::HTMLtable(3pm)

NAME
HTMLtable - tied hash and DBI/SQL access to HTML tables SYNOPSIS
use AnyData; my $table = adHash( 'HTMLtable', $filename ); while (my $row = each %$table) { print $row->{name}," " if $row->{country} =~ /us|mx|ca/; } # ... other tied hash operations OR use DBI my $dbh = DBI->connect('dbi:AnyData:'); $dbh->func('table1','HTMLtable', $filename,'ad_catalog'); my $hits = $dbh->selectall_arrayref( qq{ SELECT name FROM table1 WHERE country = 'us' }); # ... other DBI/SQL operations DESCRIPTION
This module allows one to treat the data contained in an HTML table as a tied hash (using AnyData.pm) or as a DBI/SQL accessible database (using DBD::AnyData.pm). Both the tiedhash and DBI interfaces allow one to read, modify, and create HTML tables from perl data or from local or remote files. The module requires that CGI, HTML::Parser and HTML::TableExtract are installed. When reading the HTML table, this module is essentially just a pass through to Matt Sisk's excellent HTML::TableExtract module. If no flags are specified in the adTie() or ad_catalog() calls, then TableExtract is called with depth=0 and count=0, in other words it finds the first row of the first table and treats that as the column names for the entire table. If a flag for 'cols' (column names) is specified in the adTie() or ad_catalog() calls, that list of column names is passed to TableExtract as a headers parameter. If the user specifies flags for headers, depth, or count, those are passed directly to TableExtract. When exporting to an HTMLtable, you may pass flags to specify properties of the whole table (table_flags), the top row containing the column names (top_row_flags), and the data rows (data_row_flags). These flags follow the syntax of CGI.pm table constructors, e.g.: print adExport( $table, 'HTMLtable', { table_flags => {Border=>3,bgColor=>'blue'}; top_row_flags => {bgColor=>'red'}; data_row_flags => {valign='top'}; }); The table_flags will default to {Border=>1,bgColor=>'white'} if none are specified. The top_row_flags will default to {bgColor=>'#c0c0c0'} if none are specified; The data_row_flags will be empty if none are specified. In other words, if no flags are specified the table will print out with a border of 1, the column headings in gray, and the data rows in white. CAUTION: This module will *not* preserve anything in the html file except the selected table so if your file contains more than the selected table, you will want to use adTie() or $dbh->func(...,'ad_import') to read the table and then adExport() or $dbh->func(...,'ad_export') to write the table to a different file. When using the HTMLtable format, this is the only way to preserve changes to the data, the adTie() command will *not* write to a file. AUTHOR &; COPYRIGHT copyright 2000, Jeff Zucker <jeff@vpservices.com> all rights reserved perl v5.10.1 2004-08-17 AnyData::Format::HTMLtable(3pm)
Man Page

Featured Tech Videos