EXPORTING

The exporting features included in II allows you to use the information or created by II in your word processor, spreadsheet or database programs. The export function copies the current database to a new file. If a filter is set, records not visible will not be copied. The export function will not copy any 'hidden' columns in the database. Records will be copied in the order of the controlling index. Basically, the export function obeys the what you see is what you get philosophy. With the Shareware version of II you get the choice of three types of export files:

SDF-> specifies the output as a system data format ASCII file. The file is given the .txt extension. Record are fixed length, each separated by a carriage return/line feed. Fields are fixed length and there is no field separator. Character fields are padded with trailing blanks, numeric fields are padded with leading blanks, date fields are written in the form yyyymmdd, and logical fields are written as T or F. The end-of-file mark is 1A hex or CHR(26).

DELIMITED specifies the output file type as a delimited ASCII file. The file is given the .txt extension. Records are variable length, each separated by a carriage return/line feed. Fields are variable length and separated by commas. Character fields are enclosed in delimiters (the double quote mark). Leading and trailing spaces for numeric and character fields are truncated, date fields are written in the form yyyymmdd, and logical fields are written as T or F. The end-of-file mark is 1A hex or CHR(26).

dBase-> specifies the output type as a dBase III compatible file. The file name is give the .dbf extension.