DBFDUMP(1) User Contributed Perl Documentation DBFDUMP(1)NAME
dbfdump - Dump the record of the dbf file
FORMAT
dbfdump [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 x1ax1a)
--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 -fields id,msg table.dbf
dbfdump -fs=' : ' table
dbfdump --nomemo file.dbf
ssh user@host 'cat file.dbf.gz' | gunzip - | dbfdump -
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)perl v5.12.1 2010-07-05 DBFDUMP(1)
Check Out this Related Man Page
INDEXDUMP(1) User Contributed Perl Documentation INDEXDUMP(1)NAME
indexdump - Show the content of the index file
FORMAT
indexdump [options] file [ tag ]
where options are
--debug output record separator (default newline)
--type specifies the num/date/char type of the index
--start defines the value to start dump from
--n prints also the total number of records
in the file
SYNOPSIS
indexdump rooms.cdx FACILITY
indexdump --debug=14 --start=Dub rooms.cdx ROOMNAME
DESCRIPTION
Indexdump prints to standard output the content of the index file. The type of the index is one of those supported by the XBase::Index
Perl module (cdx, idx, ntx, ndx, mdx).
The output contains the index key and the value, which is the record number in the correcponding dbf file.
For mulitag index files (like cdx), you need to specify the tag name to get the actual data.
AUTHOR
(c) 1999--2000 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::Index(3)perl v5.12.1 2010-07-05 INDEXDUMP(1)
I've got a file with each record on a separate line and each record contains 34 fields separated by a colon and i'm trying to re-arrange the order of the fields and merge together certain fields separated by a slash (like field7/field28). I tried using an awk print statement like
awk -F: 'BEGIN... (5 Replies)
Hi,
I have a file like this:
mgr1.dbf
tool.dbf
usr.dbf
wow19.dbf
wow2wow.dbf
Can anyone help change the format after each line of reading to:
mgr2.dbf # add 1 of *1.dbf
tool2.dbf # if not a number exist, make it default to 2
usr2.dbf
wow20.dbf # add 1 of *19.dbf
wow3wow.dbf ... (5 Replies)
Hi all,
I would want to copy everything in a particular directory. However would want to exclude 2 files:
DIMStemp01.dbf
DIMSts01.dbf
Don't really know how to do so, any suggestions?
Thanks in advance. (5 Replies)
Hi all,
I would want to copy everything in a particular directory. However would want to exclude 2 files:
DIMStemp01.dbf
DIMSts01.dbf
I tried to:
(1) ls files except these 2 files into abc.txt
(2) Read from abc.txt and start copying.
It works, however is there any easier way? Eg.... (6 Replies)
Hi all,
I am new to shell scripting.
I have dbf file and I need to convert it into csv file.
OR, can i read the fields from a .dbf file and OR seprate the records in dbf file and put into .csv or txt.
Actually in the .dbf files I am getting , the numbers of fields may vary in very record and... (6 Replies)
Hi,
I have a string like the following:
/db1/data/GLIDER/SYSTEM.dbf
need to find the postion where "SYSTEM.dbf" starts, so I tried:
LOCATION=/db1/data/GLIDER/SYSTEM.dbf
$ expr index $LOCATION SYSTEM
expr: syntax error
$ expr index "$LOCATION" SYSTEM
expr: syntax error
... (5 Replies)
Hi,
I have a file which has the following
/u12/data/oracle/abc.dbf
/u12/data/oracle/def.dbf
/u12/data/oracle/daf.dbf
/u12/data/oracledb/fgh.dbf
/u12/data/oracledb/fkh.dbf
/u12/data/oracledb/kdq.dbf
I want to do something like this
/u12/data/oracle
/u12/data/oracle... (7 Replies)
Hi,
There were a few files deleted from a server by user xyz.
The file names are:-
/oraextME4/oradata/ME11G22/TEST_IMPORT_01.dbf
/oraextME4/oradata/ME11G22/RKVITR1_03.dbf
/oraextME4/oradata/ME11G22/TEST_IMPORT_02.dbf
need to know the ip address of the terminal from which that... (10 Replies)
Hi,
I need to back up a RH file system (96G).
The files are oracle .dbf format some of which are 5G in size.
I know that tar has got a size restriction of 2G so I cannot use this.
Can anyone recommend an alternative way of backuping up this FS?
I have been looking at dump but this... (6 Replies)
I am trying to compare two files (separted by a pipe) using 2 fields (field 1,3 from fileA and 1,2 from fileB) if the two files match i want the whole record of fileA adding the extra fields left from fileB.
1. A.txt
cat|floffy|12|anything|anythings
cat|kitty|15|lala|lalala... (6 Replies)
Hi experts,
I need to print the first field first then last two fields should come next and then i need to print rest of the fields.
Input :
a1,abc,jsd,fhf,fkk,b1,b2
a2,acb,dfg,ghj,b3,c4
a3,djf,wdjg,fkg,dff,ggk,d4,d5
Expected output:
a1,b1,b2,abc,jsd,fhf,fkk... (6 Replies)
Hello All,
I have a file, but I want to separate the file at a particular record with comma"," in the line
Input file
APPLE6SSAMSUNGS5PRICEPERPIECEDOLLAR600EACH010020340URX581949695US
to
Output file
APPLE6S,SAMSUNGS5,PRICEPERPIECE,DOLLAR600EACH,010020340URX581949695,US
This is for... (11 Replies)
Hello to all,
Please some help on this. I have the file in format as below.
How can I set the record separator as the string below in red
"No. Time Source Destination Protocol Length Info"
I've tried code below but it doesn't seem to... (6 Replies)