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 QUICK REFERENCE Valid PARAMETER TYPES * - comment * All text is ignored. H - Header H {comments} text to be excluded (all lines that match are excluded from conversion). Up 10 Headers parms. D - Detail D {Comments} text to be included (ONLY records that match are converted). Up to 10 Detail parms. N - Numeric N {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 @ {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 {Comments} Surrounds field with double quotes. Trailing blanks are removed. M - Move M {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 {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 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 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!