Comma Separated Value (CSV) Emulation
CSV emulation tells the document 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 the document uses to distinguish the different fields of a record. The document 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.
In CSV emulation, the emulation adds lines to 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 used to mark the beginning and end of each field within the data. Text delimiters are required if the character entered in the Delimiter box is present within the data itself. If the fields are separated using commas, and if the data itself contains commas, for example, then individual fields may be split into multiple ones. Using text delimiters ensures that actual commas within the data will not be interpreted as delimiters. If backslashes (\) are used in the data as text delimiters, enter double backslashes (\\) in this box. You can also specify ASCII characters using octal values preceded by a single backslash (for example, \041 for an exclamation mark).
- Force one record per page: Select to prevent splitting records across pages. If this option is not selected, when a document is printed, it may happen that the last record at the bottom of a page may be split between two pages.
- Field delimiter: Enter the character used to separate each field within the data. If backslashes (\) are used in the data as delimiters, enter double backslashes (\\) in this box. You can also specify ASCII characters using octal values preceded by a single backslash (for example, \041 for an exclamation mark).
- Set tab as field delimiter: Select if tabs used to separate each field within the data. Selecting this option overrides any value entered in the Field delimiter box.