Page History

Escape Quotes

If enabled, this setting adds an extra pair of double quotes around any part of a field value that’s already double quoted. This ensures that the double quoted portion is treated as part of the same field, and displayed with quotes, rather than a separate field.

Include Headings

Use this to show or hide report table headings. If enabled, the first row of the CSV file will be the column heading names. This also works for cross tab reports, in which case the row heading names are also included.

Character Set

Select the character set with which to encode the export file. Using the right character encoding set is essential if the exported file is to be reused in other applications that use a particular file encoding. 

Tip: Yellowfin uses the standard UTF-8 for storing double-byte characters.

Select from CR, CRLF and LF as line break characters for carriage returns. This is a useful setting when working with third-party tools which may require a specific carriage return type to correctly process CSV files.

Field Separator

This is the character that will be used to separate individual fields (or data values) in the exported CSV file. Choose predefined separators, such as comma, semicolon, tab, or define a custom separator character.

Field Separator Character

If the ‘Other’ option was selected for Field Separator definition, then specify a character to be used to separate values.

This could be any character, alphabet, number; you are also able to specify multiple characters.

Quote Commas

This will add Field Enclosure characters around any field value which contains commas, if enabled. This ensures that values containing commas are not treated as separate values before and after the comma. 

This is ideal for numeric values such as invoices that contain commas, eg: $6,328,754.

Quote all Values

This toggle will add Field Enclosure characters around all individual fields. 

If this toggle is enabled, the Quote Commas option will be switched off.

Field Enclosure

This is the character used to quote individual field values if either the Quote Commas or Quote all Values settings are switched on. 

Choose pre-defined enclosures such as single or double quotes, or define a custom enclosure character.

Field Enclosure Character

If ‘Other’ is selected for the Field Enclosure character then specify a character to be used to quote fields in. This could be any character, alphabet, number; you are also able to specify multiple characters.