Skip site navigation (1)Skip section navigation (2)

FreeBSD Manual Pages

  
 
  

home | help 
AnyData::Format::FixedUser Contributed Perl DocumentaAnyData::Format::Fixed(3)

NAME
	AnyData::Format::Fixed - tiedhash & DBI/SQL access to Fixed length data

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

	OR

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

DESCRIPTION
       This is a parser	for fixed length record	files.	You must specify an
       unpack pattern listing the widths of the	fields e.g. {pattern=>'A3 A7
       A20'}.  You can either supply the column	names or let the module	get
       them for	you from the first line	of the file.  In either	case, they
       should be a comma separated string.

       Refer to	<http://perldoc.perl.org/functions/pack.html> for the
       formatting of the pattern.

       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.32.1			  2015-01-28	     AnyData::Format::Fixed(3)
NAME | SYNOPSIS | DESCRIPTION | AUTHOR & COPYRIGHT

Want to link to this manual page? Use this URL:
<https://www.freebsd.org/cgi/man.cgi?query=AnyData::Format::Fixed&sektion=3&manpath=FreeBSD+13.1-RELEASE+and+Ports>

home | help