home
***
CD-ROM
|
disk
|
FTP
|
other
***
search
/
High Voltage Shareware
/
high1.zip
/
high1
/
DIR9
/
S3DSIZ21.ZIP
/
S3DSIZ21.DOC
< prev
Wrap
Text File
|
1993-08-24
|
6KB
|
140 lines
Program: S3 Delimitted Field Size Utility (DSIZE)
Version: 2.1
Author: George Spafford
Date: 08/24/93
Purpose:
To identify the number of records in a file, the maximum and minimum number
of fields in the records encountered as well as the maximum and minimum size
of each field that is encountered.
Procedure:
There are two .EXE files, DSIZE21.EXE and DSIZE386.EXE. The first one is aimed
at users with 8088 and 80286 systems. DSIZE386 is optimized for use with 80386
and above systems.
Usage: DSIZE file.nam delim LogTo
File.nam This is the file you want to check.
Delim This is the field delimitter that you want to
use.
LogTo This is the device or file that you want
to log the results to. It is an optional
parameter. Devices supported are: LPT1, LPT2,
LPT3, COM1, COM2, COM3, COM4, SCRN.
Files are opened from scratch each time. In
other words, the files are created each time -
not appended to.
Example: DSIZE TEST.FIL ,
TEST.FIL will be processed using the comma as a field
separator. No Logging will occur.
DSIZE TEST.FIL , LPT1:
This will process TEST.FIL using commas as delimitters
and will log the results to printer port one.
-----------------------------------------------------------------------
SPECIAL! IF YOU SPECIFY THE VERTICAL PIPE ( | ) AS A DELIMITTER ON
THE COMMAND LINE YOU MUST SPECIFY A LOG TO DEVICE OR FILE. OTHERWISE,
DOS WILL INTERPRET THE PIPE AS INDICATING A REDIRECTION! IF YOU
ABSOLUTELY DO NOT WANT TO LOG THE DATA, DO NOT RUN THE PROGRAM FROM
THE COMMAND LINE.
-----------------------------------------------------------------------
If you run DSIZE without any command line options, the program will ask you
for the data file, delimitter and where to log the results to. Pressing
ENTER alone on the data file will end the program. Pressing ENTER alone when
specifying where to log data to will disable the logging routine. Remember,
the screen can only show 36 fields.
DSIZE expects records to be terminated with the standard DOS carriage return
(Decimal 10) and line feed (Decimal 13) characters. You will get an overflow
error message if the records are not thusly delimitted.
The program can identify on the screen up to 36 fields per record. This is a
limitation of the screen size. The program can handle a theoretical limit of
1,000 fields per record.
For each record that is processed, the program will display the field specs.
At the bottom of the screen, you will see a maximum and minimum field count
spec. This will tell you if the data file has a variable number of fields.
When customers send me these, it is a hanging offense. If the MAX and MIN
counts are equal, then you know there is always an equal number of fields.
For each field, a minimum and maximum size in bytes is given. The format:
Field Number: Min: nnnn Max: nnnn
For some reason, people always change field sizes without telling anybody.
If nothing else, you can use this program to determine the maximum number
of fields and the maximum size for each field rather than importing blindly.
History:
v2.1 08/24/93
Oooops. For those of you that had more than 36 fields and
were getting an Invalid Function message, it was an error in
the video routine that I wrote.
New: - The program can handle up to 1,000 fields.
- Results can be logged to a data file or device.
- Corrected the program logic to track fields that
are dropped at the end of records. v2.0 ignored
fields that were dropped at the end.
v2.0 08/14/93
I have completely rewritten the program.
v1.0 Written sometime in the deep, dark past.
============================
Please Register This Program
============================
The S3 DSIZE program is distributed as SHAREWARE. It is not Public Domain.
If you find that this program aids you in your work, it must be registered
within 30 days of your first usage of it. Continued use of the program without
paying for it is a violation of the site license and constitutes software
piracy. This product is priced at $10 US per concurrently used copy.
Registration of this product will allow me to continue developing
specialized software for you, the consumer, at shareware prices.
Payments (please do not send cash) can be sent to:
George Spafford
3003 Lakeshore Drive, #216
St. Joseph, MI 49085
USA
I can also be reached on the EXEC-PC BBS and the Channel One BBS.
SHAREWARE DISTRIBUTORS:
You may distribute this program as long as it is made clear that you are
only a distributor and that the program is not registered until they make
payment to me. Please do not charge more than $5 per disk to distribute
SFP to your customers.
::::: Legal :::::
DSIZE IS DISTRIBUTED AS IS. THE AUTHOR (GEORGE SPAFFORD) MAKES
NO WARRANTIES OF APPROPRIATENESS, MERCHANTABILITY OR FITNESS FOR A
PARTICULAR PURPOSE. THE AUTHOR ASSUMES NO LIABILITY FOR ANY DAMAGES
(INCLUDING LOST PROFITS, WAGES OR ANY OTHER CONSEQUENTIAL OR INCIDENTAL
DAMAGES) ARISING OUT OF THE MISUSE OR INABILITY TO USE THIS PRODUCT.