home
***
CD-ROM
|
disk
|
FTP
|
other
***
search
/
High Voltage Shareware
/
high1.zip
/
high1
/
DIR2
/
DELIM327.ZIP
/
QUICKREF.TXT
< prev
next >
Wrap
Text File
|
1993-04-25
|
5KB
|
133 lines
QUICK REFERENCE
Program DELIMIT
Environment DOS, Turbo Pascal 3.0 - 7.0
Author Roy Grosbach
Copyright Copyright 1987-1993 Roy Grosbach
Date DELIMIT V3.27 TP7.0 04/25/93
Some of DELIMIT's MANY uses: _______
- Convert a print file (report printed to disk) to a file to be
read into a spread sheet or data base (remove the report headers
and convert numbers).
- Convert a fixed format file to a comma (or tab) delimited file.
- Extract selected fields (i.e. totals from a print file, to be
read into a spread sheet or data base, disregard all other
fields).
- Extract selected fields from a fixed record format (mainframe
data base) for importing to a data base.
- Extract selected fields from a fixed format file and create a
smaller fixed format file.
- Reformat a fixed format file into a different fixed format file.
(data conversion from one system to another).
The Numeric fields in comma (or tab) delimited files are expected NOT
to have commas or other non numeric characters. The negative sign is
expected to be in the first position of the field. Many reports use a
negative sign at the last position of the field, DELIMIT will move it _______
to the front. Other reports use parenthesis to inclose negative
amounts, which DELIMIT removes, and places a negative sign in the _______
first position.
Text fields may be moved as is (Move parameter), or surrounded by
double quotes (Character parameter).
Fields are separated by commas, or by a user defined character,
(Separator parameter) or by nothing. IF fields are separated by NO
character, the fields are fixed format. IF fields are separated by
any 'separator', extra spaces are trimmed from the fields.
Records (lines) are separated by CR-LF (Carriage Return-Line Feed), by
a user defined character (Record separator parameter), or by nothing.
Command line:
DELIMIT <parmfile> <input file> <output file>
QUICK REFERENCE
Valid PARAMETER TYPES
* - comment * All text is ignored.
H - Header H <position> <length> <text> {comments}
text to be excluded (all lines that match are excluded from
conversion). Up 10 Headers parms.
D - Detail D <position> <length> <text> {Comments}
text to be included (ONLY records that match are converted).
Up to 10 Detail parms.
N - Numeric N <position> <length> {Comments}
Leading zeros and commas are removed. Formatting for
negative numbers is removed and a '-' placed at the
beginning of the field. IF the field separator is Snone or
Rnone, then spaces are included to right justify the field.
@ - Signed Numeric @ <position> <length> {Comments}
Signed fields from the mainframe replace the LAST position
with a character that represents the number AND the sign
(positive or negative). Leading zeros are removed. IF the
field separator is Snone or Rnone, then spaces are included
to right justify the field.
C - Character C <position> <length> {Comments}
Surrounds field with double quotes. Trailing blanks are
removed.
M - Move M <position> <length> {Comments}
Does not surround with quotes, trailing spaces are removed.
IF the field separator is Snone or Rnone, then trailing
spaces are NOT removed.
L - Length L <length> {Comments}
Length of fixed records (that have no CR-LF). Sometimes
data files from main frames have no end of record marker.
Can be up to 4000.
S - Separator S<separator between fields>
Change the field separator from a comma to something else.
** must NOT have a space between the 'S' and the separator
S\nnn - nnn = ASCII code
R - Record Sep R<separator between records>
Change the record separator from a CR-LF to something else.
** must NOT have a space between the 'R' and the separator
R\nnn - nnn = ASCII code
** NOTE Snone or Rnone replaces the separator with NOTHING!