home
***
CD-ROM
|
disk
|
FTP
|
other
***
search
/
Shareware Overload
/
ShartewareOverload.cdr
/
database
/
dbutil.zip
/
COPYFLD.DOC
< prev
next >
Wrap
Text File
|
1987-02-14
|
4KB
|
71 lines
Documentation Maintained by PC Professional Users Group
P.O. Box 2350 Wilmington DE. 19899
FILENAME: COPYFLD.PRG
PROGRAM NAME: Copyfield program
VERSION NUMBER: 1.0
VERSION DATE: 00-00-00
AUTHOR (ORIGINAL): Kenneth Eagle
" ADDRESS/PHONE: 2304 Rockwell Rd. 302-475-2763
LATEST REVISOR: .
" ADDRESS/PHONE: .
OBTAINED FROM: Author
PROGRAM TYPE: dBASEII Utility
********************** EQUIPMENT REQUIRED **********************
The dBASEII Program
********************* PURPOSE; DESCRIPTION *********************
A generalized dBASEII utility to copy a field or combination of
fields from one file to another. It has much greater speed than
the JOIN operation, and can be used in a number of different ways.
************************* INSTRUCTIONS *************************
-Copy this program onto your dBASE working disk
-Bootup in any DOS (if not already done).
-Type DBASE <RETURN/ENTER key>
-Type DO COPYFLD <RETURN/ENTER key>
-Further instructions included in the program.
-To end program prematurely, push Esc key
************************* PECULIARITIES ************************
-There must be room on your data disk for up to 2 index files
if your TO and FROM files are not in order.
-Some earlier versions of the dBASE program (eg CP/M) require
that a command program of this sort have an extension of .CMD.
If you have one of these versions, rename the program to
COPYFLD.CMD (This utility has been tested on both an IBM-PC
and a SUPERBRAIN II.
-The default convention for macros has been used i.e. an &
If your dBASE has been installed with some other symbol,
you must change all "&"s to that symbol
*********************** GENERAL COMMENTS ***********************
-Copyright 1983 by Kenneth Eagle
This program is contributed to the public domain with the
restriction that it may not be used for commercial purposes
without written permission from the author.
A dBASEII program to copy field(s) from one file to another
Both files must contain a common 'KEY FIELD'.
Both files must be in order of (or indexed on) 'KEYFIELD'.
(the program will do this on a temporary basis if you like)
FROM file must have a KEYFIELD entry for every one in the TO file.
As presently programmed, the TO file must already be structured
with the field to be copied into already created (filled or empty)
-I have found this utility to be useful for a number of different
purposes. I have used it to change identification codes using
a cross-reference list as the FROM file. It is very effective
for "merging" one or two fields from one file to another without
the complication (and slowness!) of a third file created by the
"JOIN" operation. Another useful feature is the ability to
combine two or more fields into a single field "as you go".
For example. Suppose the FROM file has two fields called
FIRSTNAME and LASTNAME with entries of KEN and EAGLE respectively,
and you want to combine these into a single field called NAME in
the TO file. When the program asks for the FROM field name, you
respond with LASTNAME-","-FIRSTNAME (using standard dBASE con-
ventions). The answer to the TO field name question would be
NAME. The result in the TO file's NAME field would be a single
entry of: EAGLE,KEN . The more I work with this utility, the
more uses I find for it.
-An improvement would be: add a way to automatically create the
new field in the TO file when it doesn't already exist