DELIMIT version 4.10 Copyright 1987-1994 _______ QUICK REFERENCE Roy G. Grosbach Program DELIMIT Environment DOS, Turbo Pascal 3.0 - 7.0 Author Roy Grosbach Copyright Copyright 1987-1994 Roy G Grosbach Version v4.10 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). - Convert data from multiple lines in a print file to one record. 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). Constants may be inserted into the output record (Konstant 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 DELIMIT version 4.10 Copyright 1987-1994 _______ QUICK REFERENCE Roy G. Grosbach FILE FORMAT COMMANDS COMMAND USAGE InFileName InFileName= Default name for the input file to process. Can be overridden on the command line (the second parameter). OutFileName OutFileName= Default name for the file created for output. Can be overridden on the command line (the third parameter). LogFileName LogFileName{=} Creates a log file of all activity performed by DELIMIT. This parameter can an be overridden on the command line (the fourth parameter). This is NOT a required parameter. If you do not specify the filename the file "DELIMIT.LOG" is used. This is helpful for debugging PARM files, or for running DELIMIT from .BAT files. OneToOne OneToOne One record for input is treated as one record for output (this is the default mode). ManyToOne ManyToOne{=} Many records for input can be treated as one record for output. The multi-line records commands are used to gather data from multiple lines to be put into one output record. 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 bytes long. 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 where nnn is an 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 where nnn is an ASCII code ** NOTE Snone or Rnone replaces the separator with NOTHING! * comment * All text is ignored. ; comment ; All text is ignored. ALL text following a semicolon will be treated as a comment. DELIMIT version 4.10 Copyright 1987-1994 _______ QUICK REFERENCE Roy G. Grosbach MULTI-LINE RECORD COMMANDS COMMAND USAGE [DELIMIT] [DELIMIT] This denotes commands for ALL input records. The File Format commands are placed in this area for clarity. Record Format placed in this area will be applied to EVERY record read. [] [] The 'square' bracket indicates the next type of record to be processed in multi line mode. Record type is ignored by the program (useful for documenting the parameter file). If you do NOT use the "[" commands, then DELIMIT assumes there is only 1 input record type. RECORD FORMAT COMMANDS COMMAND USAGE H Header H {} "text" {;comments} text to be excluded (all lines that match are excluded from conversion). D Detail D {} "text" {;comments} text to be included (ONLY records that match are converted). 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 last digit of 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. 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. C Character C {;comments} Surrounds field with double quotes. Trailing blanks are removed. DELIMIT version 4.10 Copyright 1987-1994 _______ QUICK REFERENCE Roy G. Grosbach I InputRecordCount I {} {;comments} Inserts the INPUT record number being processed into the output record. Default length is 10 positions. O OutputRecordCount O {} {;comments} Inserts the OUTPUT record number being processed into the output record. Default length is 10 positions. This is useful if the destination file must have a unique key. K Konstant K {} "constant string" {;comments} Places this string in every record. K {} \nnn Where "nnn" are ASCII codes NOT surrounded by quotes