CSV emulation

CSV emulation tells the process to read the input data one line at a time and to treat each line as a database record. It also specifies the field delimiter used to distinguish the different fields of a record.

The process reads the data stream one line at a time and puts each field of the database record on a separate line in the data page buffer, until the buffer is full. You can force a new data page for each record when you set up the emulation.

Note that a double text delimiter within a field is not considered a normal character when not using the Optimized PostScript Stream option or when printing using a Windows printer driver.

CSV emulation options

• Text delimiter: Enter the character that starts and ends the data in each field of the record. If you do not set a text delimiter and the data in a field contains the character you set as the delimiter, the data is split into two fields. If you want to use a backslash character (\) as a delimiter, you must precede it with another backslash character (thus you would enter \\). You can also specify an ASCII character using its octal value preceded by a backslash (for example, \041 is the exclamation mark character [!]).
• Force one record per page: Select to force a single record per data page. If you clear the selection, a record may be split across data pages if necessary. If you want to avoid splitting a record across data pages, yet have several records in the buffer, select Force one record per page, and set the Pages in buffer option to the number of records you want the buffer to hold.
• Delimiter: Enter the character that separates the fields of each record in the input data. If you want to use a tab as a delimiter, select Set tab as field delimiter. If you want to use a backslash character (\) as a delimiter, you must precede it with another backslash character (thus you would enter \\). You can also specify an ASCII character using its octal value preceded by a backslash (for example, \041 is the exclamation mark character [!]).
• Set tab as field delimiter: Select to define a tab as the character that separates the fields of each record in the input data. Clear to use the Delimiter box to define that character.