






          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!








