DBFDUMP

Section: User Contributed Perl Documentation (1)
Updated: 2009-07-27
Index Return to Main Contents
 

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)