bundle::dbd::csv(3) [suse man page]

Bundle::DBD::CSV(3)					User Contributed Perl Documentation				       Bundle::DBD::CSV(3)

NAME

       Bundle::DBD::CSV - A bundle to install the DBD::CSV driver

SYNOPSIS

	 perl -MCPAN -e 'install Bundle::DBD::CSV'

CONTENTS

       DBI 1.611

       Text::CSV_XS 0.71

       SQL::Statement 1.25

       DBD::File 0.38

       DBD::CSV 0.28

DESCRIPTION

       This bundle includes all that's needed to access so-called CSV (Comma Separated Values) files via a pseudo SQL engine (SQL::Statement) and
       DBI.

AUTHOR

       This module is currently maintained by

	   H.Merijn Brand <h.m.brand@xs4all.nl>

COPYRIGHT AND LICENSE

       Copyright (C) 2009-2010 by H.Merijn Brand Copyright (C) 2004-2009 by Jeff Zucker Copyright (C) 1998-2004 by Jochen Wiedmann

       All rights reserved.

       You may distribute this module under the terms of either the GNU General Public License or the Artistic License, as specified in the Perl
       README file.

perl v5.12.1							    2010-03-16						       Bundle::DBD::CSV(3)

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

NAME

	AnyData::Format::CSV - tiedhash & DBI/SQL access to CSV data

SYNOPSIS

	use AnyData;
	my $table = adTable( 'CSV', $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','CSV', $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 comma separated list of column names
	 eol	     : the end of record mark, 
 by default
	 quote_char  : the character used to quote fields " by default
	 escape_char : the character used to escape the quote char, " by default

       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::CSV(3pm)