dbfdump.pl man page

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.

Available from

http://www.adelton.com/perl/DBD-XBase/

Author

(c) 1998--2011 Jan Pazdziora.

See Also

perl(1); XBase(3)

Info

2016-05-15 perl v5.24.0 User Contributed Perl Documentation