dbfdump.pl

Langue: en

Version: 2009-02-26 (fedora - 04/07/09)

Section: 1 (Commandes utilisateur)

NAME

dbfdump.pl - Dump the record of the dbf file

FORMAT

         dbfdump.pl [options] files
 
 

where options are

         --rs            output record separator (default newline)
         --fs            output field separator (default colon)
         --fields        comma separated list of fields to print (default all)
         --undef         string to print for NULL values (default empty)
         --memofile      specifies unstandard name of attached memo file
         --memosep       separator for dBase III dbt's (default \x1a\x1a)
 
         --nomemo        do not try to read the memo (dbt/fpt) file
         --info          print info about the file and fields
                 with additional --SQL parameter, outputs the SQL create table
         --version       print version of the XBase library
         --table         output in nice table format (only available when
                 Data::ShowTable is installed, overrides rs and fs)
 
 

SYNOPSIS

         dbfdump.pl -fields id,msg table.dbf
         dbfdump.pl -fs=' : ' table
         dbfdump.pl --nomemo file.dbf
 
         ssh user@host 'cat file.dbf.gz' | gunzip - | dbfdump.pl -
 
 

DESCRIPTION

Dbfdump prints to standard output the content of dbf files listed. By default, it prints all fields, separated by colons, one record on a line. The output record and column separators can be changed by switches on the command line. You can also ask only for some fields to be printed.

The content of associated memo files (dbf, fpt) is printed for memo fields, unless you use the "--nomemo" option.

You can specify reading the standard input by putting dash (-) instead of file name.

AUTHOR

(c) 1998--1999 Jan Pazdziora, adelton@fi.muni.cz, http://www.fi.muni.cz/~adelton/ at Faculty of Informatics, Masaryk University in Brno, Czech Republic

SEE ALSO

perl(1); XBase(3)