Dec 092017
 
This program is designed to convert an ASCII file that is not delimited to a Dbase format data file (dbf).
File CONVERTA.ZIP from The Programmer’s Corner in
Category Dbase Source Code
This program is designed to convert an ASCII file that is not delimited to a Dbase format data file (dbf).
File Name File Size Zip Size Zip Type
CONVERT.DOC 2575 806 deflated
CONVERT.EXE 196274 88010 deflated

Download File CONVERTA.ZIP Here

Contents of the CONVERT.DOC file




This program is designed to convert an ASCII file that is
not delimited to a data base file (dbf).

To use this program you must feed in the first 3
parameters (as listed below) from the DOS prompt.

THIS PROGRAM ASSUMES ALL DATABASE FILES HAVE AN
AN EXTENSION OF (.DBF). The name of the ASCII file
may have any extension.



Syntax:

CONVERT ASCIIFile FromDBF ToDBF [HeaderBytes] [Footbytes]

ASCIIFile - Name of ASCII File to Convert
FromDBF - Name of DBF File to use a pattern for
reading data from ASCII File
ToDBF - Name of DBF File to save converted
Data. This file will be created for
you if not found. If found, records
from the ASCII file will be appended to
this file. Therefore this file name
may be the same as the FromDBF file
name.
HeaderBytes - Number of Bytes preceeding data in
ASCII file.
Footbytes - Number of Bytes following the data in
the ASCII file.



Examples:

CONVERT LIST MASTER DEPT
Name of database to contain data
Name of Database to use as a pattern
Name of ASCII File




CONVERT TEXT PEOPLE LIST 100 20

20 bytes follow data
100 bytes preceed ASCII data
Name of database to contain data
Name of Database to use as a pattern
Name of ASCII File



To give you a micro example:

'TEXT' ASCII File contains: 10FRED20JANE30TONY

'TEMPLATE' From DBF File Stru.: Code NUM 2 0
Name CHAR 4

'NAMES' To DBF File does not exist

Syntax to Convert:

CONVERT TEXT TEMPLATE NAMES

Would Create NAMES.DBF containing:

Code Name

10 FRED
20 JANE
30 TONY


End of Help Text



 December 9, 2017  Add comments

Leave a Reply